cancel
Showing results for 
Search instead for 
Did you mean: 

Connect 2.0 to connect to on-prem SQL server

Shanmathi
New Contributor II
New Contributor II

Can we use Connect 2.0 to make a direct connection to a SQL server on-premise? We are planning to import user data for an application directly from a SQL server database.

7 REPLIES 7

NikhilGuptaSav
Saviynt Employee
Saviynt Employee

The basic goal of SC2.0 connection is to provide a secured connectivity between the Saviynt Cloud and customer's on-prem resources like AD or DB. So yes, if you are looking to connect to on-prem DB, you will need SC2.0 setup. Once the infrastructure is in place, you can then configure the DB connector

Thank you for the confirmation. Can you please provide documentation on how to configure the connection between Connect 2.0 and the SQL server?

You need to saviynt freshdesk ticket for same.

provide below information

server ip

server port

saviynt sever url

Again,

You don't configure SC2.0 between sql server and saviynt servers. Think of it more of a one time activity that you need to perform. Do you have access to Saviynt documentation? Search for SC2.0 and you will find the client configurations there

That makes sense. Thank you for providing the documentation.

if reply answered your question please mark accept as solution for future audience