Using SAP Analytics Cloud to connect to data.world data

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

To accomplish this you need to download the dw-jdbc.jar file from https://data.world/integrations/java-jdbc

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: https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/release/en-US/0d5ffbb6951b45778c1a90ffd0114f04.html

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 data.world connection

 

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

 

Save the certificate as a file.

 

Import the saved file into cacerts.

 

The cacerts file should now have the data.world 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 data.world username

[dataset id] is the data.world id of the dataset

JDBC Class is world.data.jdbc.Driver

For credentials for the user name your data.world username and for password use your data.world token which you can obtain from: https://data.world/integrations/sap-analytics-cloud?tab=settings

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 data.world!