Skip to Content
Author's profile photo Srivathsa Gunda Dixit

Connecting to a custom Salesforce URL with Lumira Desktop


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

However if the customer wants to connect to a custom salesforce URL (Eg.,, 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)


<DataBase Active=”Yes” Name=”“>


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

<Parameter Name=”URL Format”>jdbc:salesforce://localhost;Endpoint=</Parameter>


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



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:


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.








Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Hi Srivathsa,

      I'm getting the error "Unable to connect to server".  What did you mean by "password+key" , I'm using the Windows AD password here I assume correct? And if so, there is no "key" for it.  Or am I missing something here?