SAP Analytics Cloud Kit – update SQL Driver

Continuing the SAP Analytics Cloud Kit thread – today there will be a few words about updating the SQL driver. Earlier articles are here and here.

In my case, I’ll be updating MSSQL driver. Initially, we must verify SQL version compatibility and choose the correct JDBC driver version. Look here.

We can download the suitable driver from here.

Update driver

1. Stop Apache and SAP Cloud connector services.
2. Unzip and copy the driver to the directory: C:\Program Files\SAP\SACAgentKit\drivers or other location where You have installed SACAgentKit.
3. Backup file C:\Program Files\SAP\SACAgentKit\c4a_agent_drivers.properties and next edit it.
4. In the file, c4a_agent_drivers.properties specify the location of the driver – look at the screen below.
5. Save changes and start Apache and SAP Cloud connector services.
6. Verify SQL connection, which uses a new driver.