Microsoft Azure Repository Connection

Is there a way to set up a repository connection with Microsoft Azure Service user?

In SSMS it's called "Microsoft Entra Service Principal"

We tried adding it by clicking build on the connection window and manually entering the connection stringThat connection succeeds. But as soon as you close it out and click Test Connection on that Repository Connection screen the Test Connection does not work. I am not sure what to put in here to make it work. If you open up the OleDB Manager again then all those settings are not the same. You can put that connection string back in and click Build and it all comes back up and tests fine. Is it possible? And if so, how do we properly do it?

Are you using latest version?

What is new in Advanced ETL Processor 6.5.3.0

• Improved: SQL Server connectivity, particularly Windows Authentication, SQL Server Authentication, Microsoft Entra Service Principal, Microsoft Entra Managed Identity, Microsoft Entra Default, and Microsoft Entra Password.
• Improved: Minor data transformation and import performance improvement for ODBC and SQL Server.
• Fixed: Memory leaks.

I updated the application and I can see the new option. I was able to create the repository, but there's a strange issue.
I can set the authentication method to Microsoft Entra and it connects successfully, but then when I hit ok and try to connect, it doesn't open the connection.
When I go back into the connection settings the method is automatically set back to "SQL Server Authentication" instead of "Microsoft Entra Service Principal"

Is there a step I'm missing? Maybe a driver that needs to be installed?

Please install Microsoft OLE DB Driver 19 for SQL Server and ODBC Driver 18 for SQL Server

www.etl-tools.com/wiki/knowledgebase/rep...l-server-repository/

I got it installed and used the OleDb driver with a connection string instead of the microsoft entra option and it worked.

Thanks

Looks like it is a bug which we have to fix... 

It should work with the microsoft entra option, is there any chance you can email us temporary connection details so we can use them for testing?

You can delete/disable them later