SAP Lumira Query with SQL

[Former Member]

Hi we are doing a POC on SAP Lumira using Freehand SQL for our business users.

We are trying to connect SQL Server 2012 / Oracle 12.

Taking both the routes I am hitting the same roadblock.

Java Class not found in classpath .com.microsoft.sqlserver.jdbc.SQLServerDriver.

I downloaded both JDBC Driver 4.0 & 4.1 and tried to setup the jar executable but still I am getting the same error.

Am i placing the driver in correct location.

C:\Program Files\SAP Lumira\Desktop\plugins\com.businessobjects.connectionserver.standalone_3.2.4.B_20141030-231603\ConnectionServer\drivers\java

I even tried completely copying the folder content of 4.0 & 4.1 to the following location after seeing salesforce folder there. We are able to connect to Salesforce without any issues.

C:\Program Files\SAP Lumira\Desktop\plugins\com.businessobjects.connectionserver.standalone_3.2.4.B_20141030-231603\ConnectionServer\jdbc\drivers

But I still end up with same error after installing the drivers from the preferences in LUMIRA.

What am I missing do I need to EDIT any SBO file or Classpath XML file add the String for SQL Server for it to work correctly.

Any help or guidance is appreciated.

Best

Monty.

[TammyPowlas · Accepted solution]

Are you using the free or paid version of Lumira?

I don't think the personal (free) version will allow you to connect to SQL data sources.

[Former Member · Accepted solution]

We have the full suite license and with the download I am able to connect to our BI platform and access all the BI Content. It is not a free version as I entered the key. However we do not have the LUMIRA server or HANA.

[TammyPowlas · Accepted solution]

Hi Monty - please have a look at the Lumira PAM at support.sap.com/pam

https://websmp201.sap-ag.de/~sapidb/011000358700001095842012E

Pages 8- 9

It references different JDBC drivers than you do - can you check?

Source: SAP

Source: SAP

Just a thought.

[Former Member · Accepted solution]

Tammy We have used the same jar file for SQL server but we still get the error. What else am I missing I am just not able to get this off my plate today.

[TammyPowlas · Accepted solution]

Hi Monty - if you are using the correct JDBC file and you have the full suite license, I recommend opening an incident with SAP Support (assuming no one else replies here)

[Former Member · Accepted solution]

Thanks Tammy I was able to update the SBO file with the class path and bam it worked.

<xs:complexType name="JDBCDriver">

  <xs:sequence>

  <xs:element ref="jdbc:sqlserver://<server_name>:14330;databaseName=<db_name>" minOccurs="0"/>

  <xs:element ref="C:\Program Files\SAP Lumira\Desktop\plugins\com.businessobjects.connectionserver.standalone_3.2.4.B_20141030-231603\ConnectionServer\drivers\java\sqljdbc4.jar" minOccurs="0"/>

  <xs:element ref="Parameter" maxOccurs="unbounded"/>

  <xs:element ref="Properties" minOccurs="0"/>

  </xs:sequence>

[former_member28381]

Hello, I hit the same error(Java Class not found in classpath: oracle.jdbc.OracleDriver) in Lumira 1.27 desktop connecting to oracle 10g and I've tried this post answer, but won't work.

The difference is my 1.27 oracle.sbo file is as follows and I updated the <Path>. I copied oracle 10g jdbc jar file at  "C:\Program Files\SAP
Lumira\Desktop\plugins\com.businessobjects.connectionserver.standalone_3.2.4.D_20150325-205027\ConnectionServer\java\orai18n.jar"

Here is my  oracle.sbo in 1.27. Please take a look what's wrong.

   <DataBases>

        <DataBase Active="Yes" Name="Oracle 10">

      <Aliases>

                <!-- You can add an alias here if you are using some connections

that are defined with an older database engine -->

                <Alias>Oracle 7.3</Alias>

                <Alias>Oracle 8</Alias>

                <Alias>Oracle 8.0</Alias>

                <Alias>Oracle 8.1</Alias>

                <Alias>Oracle 9</Alias>

            </Aliases>

            <JDBCDriver>

                 <ClassPath>

                  <Path>C:\Program Files\SAP Lumira\Desktop\plugins\com.businessobjects.connectionserver.standalone_3.2.4.D_20150325-205027\ConnectionServer\java

</Path>

                </ClassPath>

                <Parameter Name="JDBC Class">oracle.jdbc.OracleDriver</Parameter>

                <Parameter Name="URL Format">jdbc:oracle:thin:@//$DATASOURCE$/$DATABASE$</Parameter>

            </JDBCDriver>

            <Parameter Name="Extensions">oracle10,oracle,jdbc</Parameter>

            <Parameter Name="Escape Character">/</Parameter>

            <Parameter Name="Force Execute">Always</Parameter>

            <Parameter Name="Catalog Separator">.</Parameter>

        </DataBase>

Thanks a lot.

JH

[Henry_Banks]

Hi,

Your server-side SBO file  should rather be pointing like this:

<ClassPath>

<Path>C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\jdbc\drivers\jdbc\ojdbc7.jar<Path>

<ClassPath>

Regards,

H

[former_member28381]

Hi Henri,

I've tried it and failed to connect with error "Building ConnectString/ParamString Failed: Building ConnectString/ParamString Failed : SBO parameter "JDBC Class"not specified"

<JDBCDriver>

                 <Path>C:\Program Files\SAP Lumira\Desktop\plugins\com.businessobjects.connectionserver.standalone_3.2.4.D_20150325-205027\ConnectionServer\java\orai18n.jar

</Path>

                <Parameter Name="JDBC Class">oracle.jdbc.OracleDriver</Parameter>

                <Parameter Name="URL Format">jdbc:oracle:thin:@//$DATASOURCE$/$DATABASE$</Parameter>

            </JDBCDriver>

Any idea ? Where did I miss ?

Thanks a lot

JH.

[Former Member]

I even tried using the default dbd_mssql available under to configure the drivers but I still end up with the same error.

C:\Program Files\SAP Lumira\Desktop\plugins\com.businessobjects.connectionserver.standalone_3.2.4.B_20141030-231603\ConnectionServer\drivers\java