How to Integrate SAP Leonardo with Tableau

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.