This is part of the SAP Lumira Discovery blog series.

Connecting to Salesforce via JDBC

SAP Lumira Discovery connects to Salesforce.com via its JDBC connector for data acquisition. Data once imported can be later manually refreshed as required.

Acquire Data from Salesforce and OData in SAP Lumira Discovery - 1

Basic requirements include server URL (entered against Proxy Address field) and your credentials.

Acquire Data from Salesforce and OData in SAP Lumira Discovery - 2

For the password, you need to enter Salesforce password+token key. The key consists of 10 characters and can be found in Salesforce.com > My Settings > Personal.

Once done, you can select a table from the list of tables or write freehand SQL query to preview the data before completing the acquisition.

Connecting to OData

SAP Lumira Discovery can also acquire Salesforce data as an OData feed via Generic OData 2.0 connector. This requires the setting up of an API Server.

A quick note about OData: The OData protocol enables the creation and consumption of REST APIs, which allow Web clients to publish and edit resources, identified using URLs and defined in a data model, using simple HTTP messages. OData shares some similarities with JDBC and ODBC; OData is not limited to relational databases.

 

Acquire Data from Salesforce and OData in SAP Lumira Discovery - 3

Enter your credentials to proceed to the next stage. Once done, you can select entities or use freehand SQL to preview the data before completing the acquisition.

Acquire Data from Salesforce and OData in SAP Lumira Discovery - 4

Interested to learn how to leverage SAP Lumira for your enterprise (or) train your business users in SAP Lumira Discovery? Reach out to us today.

Subscribe to our Newsletter

5920 Windhaven Pkwy
Plano TX 75093.

+1 888-227-2794

+1 972-232-2233

+1 888-227-7192

solutions@visualbi.com