Universe connection error on JDBC driver - DF

[Former Member]

Hi,

I am getting the following errors while creating a JDBC connection in the Universe using data federator.

"CS: Java Class not found in classpath : LeSelect.ThinDriver.ThinDriver"

"DBD: No suitable driver"

Below is the entries for DF in the jdbc.sbo file.Please let me know what am I doing wrong in the process.

<DataBase Active="Yes" Name="Data Federator Server">

<JDBCDriver>

<!-- Uncomment and edit the following lines

to define java classes required by JDBC driver

&lt;ClassPath&gt;

&lt;Path&gt;your jar or class files directory&lt;/Path&gt;

&lt;/ClassPath&gt;

-->

<ClassPath><Path>D:\Program Files\Business Objects\BusinessObjects Data Federator 12\JdbcDriver\lib\thindriver.jar</Path></ClassPath>

<Parameter Name="JDBC Class">LeSelect.ThinDriver.ThinDriver</Parameter>

<Parameter Name="URL Format">jdbc:leselect://$DATASOURCE$/$DATABASE$</Parameter>

</JDBCDriver>

<Parameter Name="Family">Business Objects</Parameter>

<Parameter Name="Version">rdbms_datafederatorjdbc.txt</Parameter>

<Parameter Name="SQL External File">datafederator</Parameter>

<Parameter Name="SQL Parameter File">datafederator</Parameter>

<Parameter Name="Driver Capabilities">Query</Parameter>

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

<Parameter Name="Query TimeOut Available">No</Parameter>

<Parameter Name="Array Fetch Size">10</Parameter>

<Parameter Name="Strategies File">datafederator</Parameter>

</DataBase>

Regards,

Sreeni

[former_member793810 · Accepted solution]

Hi,

Look at chapter three of this document...

Data Federator Release Notes

[http://help.sap.com/businessobject/product_guides/boexi3SP1/en/xi3_sp1_df_releasenotes_en.pdf]

Regards,

Bashir Awan

[Former Member · Accepted solution]

Thanks Bashir for your input.I have intalled the Driver component in the local machine from where I would be creating the universe but am getting a below error now.Instead of catalog earlier, the universe is now prompting to enter the database name

and also throw the below error .

CS: Building ConnectString/ParamString failed : SBO parameter "URL Format" not specified.

Plesae let me know whether the connect string in the error is reffering some database .

FYI, below is my .sbo entries for DF.

<DataBase Active="Yes" Name="Data Federator Server">

<JDBCDriver>

<!-- Uncomment and edit the following lines

to define java classes required by JDBC driver

&lt;ClassPath&gt;

&lt;Path&gt;your jar or class files directory&lt;/Path&gt;

&lt;/ClassPath&gt;

-->

<ClassPath>

<Path>C:\Program Files\Business Objects\BusinessObjects Data Federator 12\JdbcDriver\lib\thindriver.jar</Path>

<Path>C:\Program Files\Business Objects\common\4.0\java\lib\ebus405.jar</Path>

</ClassPath>

<Parameter Name="JDBC Class">LeSelect.ThinDriver.ThinDriver</Parameter>

<Parameter Name="URL format">jdbc:datafederator://$DATASOURCE$;catalog=&quot;$DATABASE$&quot;;commProtocol=EBUS</Parameter>

</JDBCDriver>

<Parameter Name="Family">Business Objects</Parameter>

<Parameter Name="Version">rdbms_datafederatorjdbc.txt</Parameter>

<Parameter Name="SQL External File">datafederator</Parameter>

<Parameter Name="SQL Parameter File">datafederator</Parameter>

<Parameter Name="Driver Capabilities">Query</Parameter>

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

<Parameter Name="Query TimeOut Available">No</Parameter>

<Parameter Name="Array Fetch Size">10</Parameter>

<Parameter Name="Strategies File">datafederator</Parameter>

</DataBase>

[Former Member · Accepted solution]

Hi SreeniS,

I have exactly the same issue.

Could you please let me know how did you resolved this?

-Thanks,

DEEPU.

[amitrathi239 · Accepted solution]

Hi,

Try with below entries in JDBC.SBO file.

Change the path driver path according to your installation.

<DataBase Active="Yes" Name="Data Federator Server">

<JDBCDriver>

<ClassPath><Path>C:\Program Files\Business Objects\BusinessObjects Data Federator 12 Drivers\JdbcDriver\lib\thindriver.jar</Path></ClassPath>

<Parameter Name="JDBC Class">com.businessobjects.datafederator.jdbc.DataFederatorDriver</Parameter>

<Parameter Name="URL Format">jdbc:datafederator://$DATASOURCE$/$DATABASE$</Parameter>

</JDBCDriver>

<Parameter Name="Family">SAP BusinessObjects</Parameter>

<Parameter Name="Version">datafederator_jdbc.setup</Parameter>

<Parameter Name="Description File">datafederator</Parameter>

<Parameter Name="SQL External File">datafederator</Parameter>

<Parameter Name="SQL Parameter File">datafederator</Parameter>

<Parameter Name="Strategies File">datafederator</Parameter>

<Parameter Name="Driver Capabilities">Query</Parameter>

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

<Parameter Name="Query TimeOut Available">No</Parameter>

<Parameter Name="Array Fetch Size">10</Parameter>

</DataBase>

Make sure ports are opened between the server and client machine.

Thanks,

Amit