DataBase Connector

[Mirani03]

Hello!

My question here is that, can we connect a local MySQL database to our Saviynt EIC as a connection?

And if yes then how can we configure it?

If no then how can I configure a Database Connector?

I have gone through Saviynt Documents but no success yet!

[sudeshjaiswal]

Hello @Mirani03,

Any database that supports the JDBC driver can be integrated to Saviynt.

For Ref:- https://docs.saviyntcloud.com/bundle/Database-v23x/page/Content/Database-Integration-Overview-v2022.... 

[Mirani03]

Unable to connect to MySQL DB. Attached error screenshot. However I am able to connect to it through another system but not able to connect through Saviynt. Please assist.

[This message edited to mask PII from attached images by moderator]

[sudeshjaiswal]

Hello @Mirani03,

What are you seeing in the logs?

Thanks,

[Mirani03]

That's the main problem, my whole Saviynt's log is down and I have raised a ticket for it, but it is pending since last 3 months.

Or else this issue would have been resolved way back.

I think the issue is with the JDBC driver.

[rushikeshvartak]

You can't connect local instance with Cloud Saviynt

[Mirani03]

My logs are now up and running and this is the error I am getting.

Can't understand it though.

[rushikeshvartak]

Share connection Screenshot

[Mirani03]

[This message has been edited by moderator to mask PII info from image]

[rushikeshvartak]

database name not specified in connection url. 

AVOID sharing URL & Confidential Information

[Mirani03]

I have kept all the other fields blank as of now.

[rushikeshvartak]

URL : jdbc:mysql://xx.xxx.xx.xx:xxxx/DBNAME

[Mirani03]

Sorry for the previous blunder, and I looked into it again.
I have followed the same format you have mentioned for URL but I am getting same error. 

The MySQL database we are trying to connect is hosted on AWS and I am able to connect to it through my local database.

My question here is, can there be a compatible issue (version compatibility), MySQL version is 8.0.33 and Saviynt is also 23.8 version.
and can the connection (Saviynt <---> DB) be a NON-SSL connection. 

[sudeshjaiswal]

Hello @Mirani03,

Thanks for the Clarification, if your AWS IP you are able to access in your local database,
You should be able to setup the DB conection (the Only Condition is that it should be the public IP), Could be SSL or NON-SSL- Connection, should work in both scenario.

Thanks.

[Mirani03]

Yes it is a public IP.

[Mirani03]

and this is the error I am getting : .MySQLNonTransientConnectionException
There are multiple other .createSQLException(SQLError.java:928); 997; 983 and many other

[sudeshjaiswal]

Hello @Mirani03,

Currenlty this is not supported, as this the version compatibility issue, EIC version 23.9 supports the MySQL 8.

Thanks.