Hello everyone, this blog comes up with an interesting topic of “How to consume data from salesforce into SAP Lumira Designer.

VBX OData Connector:

Native SAP Lumira Designer doesn’t have this capability yet. “OData connector” from VBX for SAP Lumira Designer makes it possible with simple configurations
 

Sample Scenario:

Consider an Enterprise has the data of business opportunities in Salesforce as below:

Visualize Data from Salesforce in SAP Lumira Designer with VBX

There are multiple third-party providers which can expose the data in Salesforce/other systems to outer world in OData Protocol (In this example skyvia is used). The output from such providers will be Endpoint URL as below:

https://connect.skyvia.com/608qq60l

Configuring VBX OData source with above details:

Visualize Data from Salesforce in Lumira Designer with VBX

Building the required Dataset and feeding it to a Component:

Visualize Data from Salesforce in Lumira Designer with VBX
Visualize Data from Salesforce in Lumira Designer with VBX

Now the data from Salesforce is visualized in Lumira Designer and below are few sample Analytics:

Opportunities value by Type:

Visualize Data from Salesforce in Lumira Designer with VBX

Opportunities by Stage:

Visualize Data from Salesforce in Lumira Designer with VBX

Alert Opportunities with budget > $50000

Visualize Data from Salesforce in Lumira Designer with VBX

That’s it, we were able to consume Data from Salesforce into SAP Lumira Designer. Similarly, we can consume Data from any ERP/CRM/other systems by using OData Connector plugin.