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.