Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Universe connection error on JDBC driver - DF

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 Member
replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question