Introduction to Integrating SAP Leonardo with Tableau
- SAP Leonardo is a comprehensive digital innovation system that integrates new technologies and runs them seamlessly in the cloud.
- Tableau is a powerful data visualization tool used for converting raw data into an understandable format.
Prerequisites
- Understand the basic operations of both SAP Leonardo and Tableau.
- Access to an SAP Leonardo account with necessary APIs enabled.
- Installation of Tableau Desktop or Server where integration is required.
Step-By-Step Guide to Integration
Establish Connection with SAP Leonardo
- Log into your SAP Leonardo account.
- Navigate to the API Management section to identify available data endpoints.
- Ensure your API access is securely configured for authorized data sharing.
Generate SAP Leonardo API Key
- Within the API Management, create a new API key for Tableau to use for connecting.
- Store the API key securely, as it will be used in the next steps for authentication.
Install & Configure Tableau Web Data Connector
- Refer to the Tableau documentation for guidance on installing a Web Data Connector (WDC) if not already present.
- Create a Web Data Connector that will facilitate the connection between SAP Leonardo and Tableau.
Create a Custom Web Data Connector Script
- Create a new HTML file and write a script to connect to SAP Leonardo's API using the previously generated API key.
<script type="text/javascript" src="tableauwdc-2.3.latest.js"></script>
<script>
(function() {
var myConnector = tableau.makeConnector();
myConnector.getSchema = function(schemaCallback) {
var cols = [{
id: "id",
alias: "Identifier",
dataType: tableau.dataTypeEnum.string
}, {
id: "measure",
alias: "Measure Name",
dataType: tableau.dataTypeEnum.string
}];
var tableSchema = {
id: "leonardoData",
alias: "SAP Leonardo Data",
columns: cols
};
schemaCallback([tableSchema]);
};
myConnector.getData = function(table, doneCallback) {
var apiCall = 'YOUR_SAP_LEONARDO_API_ENDPOINT';
$.getJSON(apiCall, function(resp) {
var data = resp.data;
table.appendRows(data);
doneCallback();
});
};
tableau.registerConnector(myConnector);
})();
</script>
Ensure to replace 'YOUR_SAP_LEONARDO_API_ENDPOINT' with the actual endpoint URL.
Save the file and ensure it is accessible to your Tableau interface.
Connect Tableau to SAP Leonardo
- Open Tableau and select Web Data Connector from the Connect panel.
- Enter the path to your WDC HTML file created in the previous step.
- Follow the prompts to authenticate and allow Tableau to retrieve data from SAP Leonardo in real-time.
Visualize SAP Leonardo Data in Tableau
- After creating the connection, explore the data imported from SAP Leonardo.
- Create dashboards, stories, and perform analysis using Tableau's robust set of features.
- Utilize joins, filters, and dynamic visualizations to gain insights from the data.
Troubleshooting
- In case of API authentication issues, confirm API key permissions and regenerate if necessary.
- Ensure network firewall settings allow communication between SAP Leonardo API and Tableau.
- Check Tableau logs and console for any script errors during WDC execution.
Conclusion
- Completing the integration enables efficient real-time data visualization and discovery using Tableau.
- Regularly update your Web Data Connector script to accommodate any changes in SAP Leonardo's API.