Striim 3.9.8 documentation

Supporting Active Directory authentication for Azure

When reading from or writing to Azure SQL Database or writing to Azure SQL Data Warehouse, you may use Active Directory authentication. This is not supported in sources running in a Forwarding Agent.

Caution

Updating .jar files in striim/lib may cause problems with other Striim functions that use them. If you encounter problems, delete the files added in step 3, restore the files in striim/lib.backup, and restart Striim.

  1. Follow the instructions in Installing the Microsoft JDBC driver.

  2. Move the following files from striim/lib to striim/lib.backup:

    • adal4j-1.0.0.jar

    • asm-all-5.0.3.jar

    • commons-codec-1.10.jar

    • commons-lang-2.6.jar

    • gson-2.2.4.jar

    • jcip-annotations-1.0.jar

    • json-smart-1.1.1.jar

    • lang-tag-1.4.jar

    • nimbus-jose-jwt-3.1.2.jar

    • oauth2-oidc-sdk-4.5.jar

  3. Download the following from mvnrepository.com and copy them to striim/lib:

    • accessors-smart-1.2.jar

    • adal4j-1.6.4.jar

    • asm-5.0.4.jar

    • commons-codec-1.11.jar

    • commons-lang3-3.5.jar

    • gson-2.8.0.jar

    • javax.mail-1.6.1.jar

    • jcip-annotations-1.0-1.jar

    • json-smart-2.3.jar

    • lang-tag-1.4.4.jar

    • nimbus-jose-jwt-8.2.1.jar

    • oauth2-oidc-sdk-6.5.jar

  4. Restart Striim.

.

To use Active Directory authentication, in the source or target adapter properties, for Username enter the fully qualified Active Directory user name, for Password enter its password, and use the following syntax for the Connection URL:

jdbc:sqlserver://<SQL Server IP address>:<port>;authentication=ActiveDirectoryPassword;
hostNameInCertificate=*.database.windows.net;

See Connecting using Azure Active Directory authentication for more information. Striim does not support the ActiveDirectoryIntegrated or ActiveDirectoryMSI properties.