SAP Analytics Cloud (SAC) connection to SQL

[former_member330929]

Cannot select a connection when creating an SQL database in SAP Analytics Cloud (SAC). Snote 2801176 didn't help.

[DebjitSingha]

Please share details about SQL DB version, Cloud Connector and Agent version.

[DebjitSingha · Accepted solution]

No error and missing connection type means driverconfig.properties either ignored or entries are not readable by agent.

Please check below Q&A thread, may help you with your issue-

SAC: Import data from Database SQL Server 2019

• Let us know if still encounter same issue after checking below components-
• Tomcat Initial Memory Pool and Maximum Memory Pool (1024MB and 2048MB)
• tomcat-users.xml with correct role, username and password details
• driverconfig.properties contain this text (for testing create two entries as below) -
• MS SQL Server 2014=C:\DriverConfig\mssql-jdbc-8.4.1.jre14;
• MS SQL Server 2012=C:\DriverConfig\mssql-jdbc-8.4.1.jre14
• Define an environment variable pointing to the ‘driverconfig.properties’ file

In case you find this helpful - accept this as best answer (flag available below), to build the knowledgebase and help query easy to search.

Viewers - If you find above information helpful, feel free to up-vote.

Thanks,

Debjit

[former_member330929 · Accepted solution]

Thank you for the information. First that I found that the file extension was missing and it should be MS SQL Server 2014=C:\DriverConfig\mssql-jdbc-8.4.1.jre14.jar. Also I updated folder name to DriverConfig and the issue was fixed.

[former_member330929]

I would like to connect to MS SQL Server 2014. Connector version: 2.12.2. Used next two documents:https://help.sap.com/viewer/00f68c2e08b941f081002fd3691d86a7/release/en-US/0d5ffbb6951b45778c1a90ffd0114f04.html and https://www.sapanalytics.cloud/wp-content/uploads/2017/10/SQL.pdf . Also tried to old(sqljdbc42) and new(mssql-jdbc-8.4.1.jre14) version of JDBC(driverconfig.properties). Any recommendations for the troubleshooting from SAP SAC side as I don't have any errors when creating connection, connection type just empty.