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:
-
In Studio, navigate to the Global Elements tab.
-
Click Create.
-
In the filter box, search
database. -
Select Database Config.
-
Click OK.
-
In the Database Config window, for Connection, select MS SQL Server Connection.
-
In the Advanced tab, set Connection properties to Edit inline.
-
Click the green plus sign.
-
Set Key to
Integratedsecurity. -
Set Value to
true. -
Click Finish.
-
Complete the remaining connection settings for the database.
-
Click OK.
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" />
</db:connection-properties>
</db:my-sql-connection>
</db:config>