Use Case
How to use Active Directory Domain accounts to authenticate and build connector for MS SQL Database using Kerberos authentication mechanism.
Applicable Version(s)
v2023.x
Solution
To connect to Active Directory domain accounts with MS SQL database using Kerberos, use a format similar to the following:
jdbc:sqlserver://host:port;DatabaseName=<dabase name>;authenticationScheme=JavaKerberos;integratedSecurity=true;userName=${USERNAME};password=${PASSWORD}
To define SQL Server timeout, use the format similar to the following:
jdbc:jtds:sqlserver://<ip_address>/<db_name>;instance=<SQLserver_name>;loginTimeout=5;socketTimeout=30000
Example 3: To connect to Oracle DB with MySQL database, use a format similar to the following:
jdbc:oracle:thin:@#HOST#:#PORT#:#DB#
To define Postgres timeout, use the format similar to the following:
jdbc:postgresql://host:port/dbname?options=-c%20connectTimeout=5%20-c%20socketTimeout=30
References
https://docs.saviyntcloud.com/bundle/Database-v23x/page/Content/Configuring-the-Integration-for-Impo...
