Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
cancel
Showing results for 
Search instead for 
Did you mean: 
SrivathsaDixit
Advisor
Advisor
0 Kudos

Background:


Lumira Desktop supports connecting to https://salesforce.com to acquire data via the Free-Hand SQL option. By default Lumira connects to https://salesforce.com via the salesforce drivers available in Lumira desktop.

However if the customer wants to connect to a custom salesforce URL (Eg., http://MyTestURL.salesforce.com), following steps needs to be performed:

 

Steps to connect to a custom SalesForce URL using Lumira Desktop:


1. Update the End point in the salesforce.sbo file:


salesforce.sbo file is available in the location: C:\Program Files\SAP Lumira\Desktop\plugins\com.businessobjects.connectionserver.standalone_3.14.0.A_20170109-130819\ConnectionServer\jdbc

NOTE: the folder name _3.14.0.A_201701090-130818 can be different depending the Lumira Version being used.

Take a backup of the file salesforce.sbo in any location.

Edit the file salesforce.sbo using a suitable editor as shown below by adding the custom URL as endpoint (shown below in BOLD)

<DataBases>

<DataBase Active="Yes" Name="Salesforce.com">

<JDBCDriver>

<Parameter Name="JDBC Class">com.simba.salesforce.core.Driver</Parameter>

<Parameter Name="URL Format">jdbc:salesforce://localhost;Endpoint=https://MyTestURL.salesforce.com/services/Soap/u/27.0</Parameter>

</JDBCDriver>

<Parameter Name="Extensions">salesforce,jdbc</Parameter>

</DataBase>

</DataBases>

save the salesforce.sbo into the same location.

 

2. Edit the SAPLumira.ini file to support TLS1.2


Edit the SAPLumira.ini file available in C:\Program Files\SAP Lumira\Desktop\ and add the below entry:

-Dhttps.protocols=TLSv1.1,TLSv1.2 

Save and restart Lumira Desktop.

 

3. Connecting to custom Salesforce in Lumira Desktop


Using the Query with SQL option, desktop users can see the listed salesforce JDBC driver.

provide the username/password, followed by proxy information as shown below:



NOTE: Password is a combination of password+Key

 

With the above steps you should be able to connect to salesforce URL.

you can select the table from the list or create Free Hand SQL queries for the data you would like to acquire in the Query section, preview and complete the acquisition:



Further Lumira users can perfrom all Lumira supported analytical operations based on their needs.

 

Thanks!

 

 

 

 

 
1 Comment