Contact Us 1-800-596-4880

Configure Azure Active Directory Authentication for MS SQL Server using the Database Connector

Anypoint Connector for Database (Database Connector) enables you to configure Azure Active Directory Authentication for MS SQL Server by setting the IntegratedSecurity value in the connection configuration. The following example shows how to configure this value in Anypoint Studio:

  1. In Studio, navigate to the Global Elements tab.

  2. Click Create.

  3. In the filter box, search database.

  4. Select Database Config.

  5. Click OK.

  6. In the Database Config window, for Connection, select MySQL Connection.

  7. In the Advanced tab, set Connection properties to Edit inline.

  8. Click the green plus sign.

  9. Set Key to Integratedsecurity.

  10. Set Value to true.

  11. Click Finish.

  12. Complete the remaining connection settings for the database.

  13. Click OK.

Integratedsecurity key configuration in Anypoint Studio

In the Configuration XML editor, the key="integratedsecurity configuration looks like this:

<db:config name="Database_Config1" doc:name="Database Config" >
		<db:my-sql-connection >
			<db:connection-properties >
				<db:connection-property key="integratedsecurity" value="true" />
View on GitHub