Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.
No ratings
timchengappa
Saviynt Employee
Saviynt Employee

Detailed Question: Using a DB connector, can you connect to SQL DB by authenticating against an AD service account provided the AD and DB are in the same domain and provided the service account is not present in the database?

Answer: Database connector uses JDBC driver to establish a connection to  JDBC-accessible relational databases. The pre-requisite to establish a connection to a Database is as below...

  • The service account that you want to use to connect to the target database has the necessary permissions on the database objects for performing the intended operations. These permissions depend on the queries used in the connector.

  • You have to place a copy of the appropriate third-party JDBC driver jar file in the lib folder to create a secured connection with a database. The third-party JDBC drivers for the supported databases are shipped with EIC and placed under Admin > Settings > File Directory. For more information on managing files, see Managing the External Jar Files in the Enterprise Identity Cloud Administration Guide

Saviynt Documentation Reference(Database Connector Guide v2021.x. Preparing for Integration): 
https://docs.saviyntcloud.com/bundle/DB-v2021x/page/Content/Preparing-for-Integration-v2022.htm 

Additionally, you can also establish a secure connection over SSL. You can find the details in Setting Up a Secure Connection with the Database

Comments
MansoorAhmed
New Contributor
New Contributor

Can we use multiple Service Account for different DB Connections or we have to use single service account for connections ?

Version history
Last update:
‎01/24/2023 01:17 PM
Updated by:
Contributors