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

Saviynt integration with sybase

kimam
New Contributor
New Contributor

Hi, we need to integrate sysbase with Saviynt.

We want to understand how to proceed with connectivity and other configurations.

Any documentation / information - kindly provide?

I could not find any documentation on the saviynt forum regarding sybase integration.

 

8 REPLIES 8

timchengappa
Saviynt Employee
Saviynt Employee

Hello @kimam 

To my knowledge, the backend to Sybase is a database and please correct me if I am wrong. 
In which case you should be able to reference our documentation below...

Database Integration Guide v23.x
https://docs.saviyntcloud.com/bundle/Database-v23x/page/Content/Database-Integration-Overview-v2022....

rushikeshvartak
All-Star
All-Star

You can upload sybase jar in external jar folder and use database connector.


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

Pandit
New Contributor II
New Contributor II

Hi,

By // sybase jar// do you means sybase jdbc driver?

Yes http://www.java2s.com/Code/JarDownload/sybase/sybase-3.5.0.jar.zip


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

This jar fails to upload in the saviynt.

Error with jar - message.

prasannta
Saviynt Employee
Saviynt Employee

Hi @Pandit 

Can you provide more details like screenshot or the error message that is getting displayed when you are trying to upload jar?

Thanks

Pandit
New Contributor II
New Contributor II

 I am able to upload Jar successfully. It was failing because of presence of . in the file name besides file name extension.

But still, i am unable to make connection to sybase.

Tried couple of URL, Driver-name set, but it did not work.

Need exact URL pattern and driver name and the driver file.

prasannta
Saviynt Employee
Saviynt Employee

Hi @Pandit 

Are you able to connect to Sybase database using any SQL developer tool? If yes then you can use the same configuration used to connect from a SQL tool. For Sybase, you would definitely need to upload a driver jar to Saviynt and perform application restart. For reference, see below link for sample driver and corresponding URL pattern. 

https://razorsql.com/docs/help_sybase.html

Sample for connecting to Sybase DB from Oracle SQL developer: https://stackoverflow.com/questions/7980366/setup-sybase-db-connection-in-sql-developer

Please check these and let me know.

Thanks