Blogs / SAP / SAP BusinessObjects / SAP Lumira / SAP Lumira Discovery: Connecting to Salesforce using JDBC and OData

SAP Lumira Discovery: Connecting to Salesforce using JDBC and OData

Sep 6, 2017

SHARE

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.

SAP Lumira Discovery: Connecting to Salesforce using JDBC and OData

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

SAP Lumira Discovery: Connecting to Salesforce using JDBC and OData

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.

SAP Lumira Discovery: Connecting to Salesforce using JDBC and OData

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.

SAP Lumira Discovery: Connecting to Salesforce using JDBC and OData

Interested to learn how to leverage SAP Lumira for your enterprise. Write to us by clicking here.


Corporate HQ:
5920 Windhaven Pkwy, Plano, TX 75093

+1 888-227-2794

+1 972-232-2233

+1 888-227-7192

solutions@visualbi.com


Copyright © Visual BI Solutions Inc.

Subscribe To Our Newsletter

Subscribe To Our Newsletter

Join our mailing list to receive the latest news and updates from our team.

You have Successfully Subscribed!

Share This!

Share this with your friends and colleagues!