Skip to Content
Technical Articles
Author's profile photo Henry Kam

Using SAP Analytics Cloud to connect to data is a cloud platform for teams to collaborate on data.  SAP Analytics Cloud is able to connect to datasets stored in

To accomplish this you need to download the dw-jdbc.jar file from

You first need to have the SAP Analytics Cloud Agent deployed before you can deploy the JDBC driver.  Install the Agent by using the SAP Analytics Cloud Agent Simple Deployment Kit or by performing a manual setup:

You then need to import the SSL certificates for data world into the cacerts file of JVM used by Tomcat.  A tool called  portecle.jnlp (which you can find online) is handy in adding certs to the cacerts file.

Double click portecle.jnlp to launch it and Open cacerts files used by Tomcat.  In my case I was using BI platform Tomcat so the file was under C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win64_x64\sapjvm\jre\lib\security


Default password for cacert is “changeit”


Examine the connection


Review the Certificates and click on PEM Encoding to view the certificate.  We only need the one with


Save the certificate as a file.


Import the saved file into cacerts.


The cacerts file should now have the cert imported.


Save the cacerts file and restart Tomcat


In SAP Analytics Cloud, create a new data connection by navigating to Home -> Connections

Click the “+” and select “Import Data Connection” -> “SQL Databases”

Give the connection a name and for “Connection Type” select “Generic JDBC datasource”


For the JDBC URL use jdbc:data:world:sql:[user id]:[dataset id]

[user id] is your username

[dataset id] is the id of the dataset

JDBC Class is

For credentials for the user name your username and for password use your token which you can obtain from:

by clicking the “Enable Integration button” – > “Authorize SAP Analytics Cloud” -> “Get Token”



Now with the data connection created successfully you can create a model in SAP Analytics Cloud.

Navigate to:

Home ->Create -> Model -> Use a datasource -> Acquire data from: SQL Databases

For Connection Type select “Generic JDBC datasource”, for Connection Name select from the drop down box  the data connection name you created earlier above.  Select the radio button option “Create a new query”.


After clicking “OK” you will be presented with the “Create New Query” screen.  Select the “Freehand SQL” option and enter your SQL statement.




Give the model a name and click “Create Model”


Once you have created you model you can proceed to create a story and use this model as the data source.


Congratulations you have now successfully create a SAP Analytics Cloud story against data from!


Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Eric Madariaga
      Eric Madariaga

      Hi! This is exactly the functionality that I'm looking for (connecting to Generic JDBC datasources from SAP Analytics Cloud). However, when I click through according to your instructions, I don't see "Generic JDBC datasource" in my list of available Connection Types. Do I need to install something else or configure SAP Cloud Connector/SAP Cloud Agent differently?

      Author's profile photo Henry Kam
      Henry Kam
      Blog Post Author

      Hi, did you configure the .properties file?