Skip to Content 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 API Read/Write token which you can obtain from:


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!


To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

  1. Jerod Johnson

    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?


Leave a Reply