Connect 2.0 to connect to on-prem SQL server

[Shanmathi]

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.

[NikhilGuptaSav]

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

[Shanmathi]

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

[rushikeshvartak]

You need to saviynt freshdesk ticket for same.

provide below information

server ip

server port

saviynt sever url

[NikhilGuptaSav]

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

[rushikeshvartak · Accepted solution]

https://saviynt.freshdesk.com/support/solutions/articles/43000631400-saviynt-connect-2-0-faq-v1

https://saviynt.freshdesk.com/support/solutions/articles/43000620714-saviynt-connect2-0-client-confi...

[Shanmathi]

That makes sense. Thank you for providing the documentation.

[rushikeshvartak]

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