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