SQL Database to datasphere vis DP connetor

[AkshaySakhpara]

Hello Everyone,

I am trying to connect to SQL server through DP agent. I am getting this error:

Error

Connection "SA**** couldn’t be established. - Data flows can’t be used because of errors in the connection. - Replication flows are not supported. - Remote tables can’t be used because of errors in the connection.

Data Flows: Cause: Open request could not be performed due to error: Timeout expired. select failed: 2
Invalid attribute in connection string: DriverUnicodeType.
Remote Tables: Unable to connect remote source: Adapter validation failed. [DWC_*******]Failed to establish JDBC connection. Error: Fehler bei der Anmeldung für den Benutzer "datasphere". ClientConnectionId:**************, Code: 5921, SQL State: HY000

Could Someone help me out with this problem. Thank you

Microsoft SQL Server SAP Datasphere #dPAgent

[XaviPolo · Accepted solution]

Hello @AkshaySakhpara ,

All steps for connecting to an SQL Server are available in the Microsoft SQL Server Connections | SAP Help Portal

If you want to use Data Flows, the DPAgent is not required.

Where is your SQL Server, is in the cloud or on-prem? 

If it is cloud, have you opened the access to the DSP server in your cloud provider?

If it is on-prem, if the server/port is not published to the internet, have you installed SAP Cloud Connector in your on-prem network to allow access from DSP?

Regards,

[AkshaySakhpara · Accepted solution]

Hello @XaviPolo,

[AkshaySakhpara · Accepted solution]

The SQl database is on-prem. Yes I have erver/port . You mean to say is I need to install SAP Cloud Connector on our server or SQL or anything else ?

[XaviPolo · Accepted solution]

Yes to allow DSP (cloud) to access your SQL Server (on-prem) you need a "tunnel" to allow connection between both worlds. So you need SCC installed in a local server. It can be on the SQL Server, although I prefer to have it on another intermediate server, that is close enough to the SQL Server so that it does not add latency to the communication.