JDBC Connection

[Jared]

Hi folks,

I have the following situation. I installed Business Objects Enterprise XI 3.1 on Sparc Solaris 10. The CMS database is Oracle 10g. However the data to be reported on is on Windows MS SQL Server 2005. The issue is now that the customer decided to go with the MS SQL JDBC driver for UNIX (which is supported by BOBJ) in order to access the MS SQL Server 2005 from CMS/WEB Intelligence (on Solaris) rather than to use the ODBC Data Direct Driver (which is not for free).

As I have not found anything about the configuration of the JDBC driver in the Unix installation Guide nor in the Admin Guide nor on the Internet, what is the procedure to configure the JDBC driver after it has been installed on Solaris?

How does CMS/Web Intelligence know how to access the MS SQL Server on Windows?

And how should the Universe be created? By using an ODBC driver or JDBC driver to access the SQL database?

Thanks a lot for your help

Jared

[Former Member · Accepted solution]

There are 2 different things that need to be configured:

In order to access the MS SQL server from unix you should get an odbc manager and a jdbc/odbc driver.

I have tried this odbc manager (on Linux RHEL 4) in order to access different vendor databases (Informix, MS SQL server):

http://www.unixodbc.org/

In that page you can get more information on how to get the driver to access the database.

If you want to create or modify a universe, you have to use the Windows program Designer.

And in order to access the database, you have to configure the windows odbc driver that Microsoft provides (the access to the database from Designer is not related to the BO server, is independent)

[Jared · Accepted solution]

Hi Alejandro,

thanks for your answer.

It is a bit confusing now. My main source is the document called BOXI Data Access Guide which explains how to set up a JDBC connection for Business Objects WebI on a Server. But there is not mentioned an ODBC Manager that needs to be installed/available at all. It just says to install the respective JDBC driver and to set up a jdbc related file. That is all. I intend to set up a JDBC connection only.

Are you referring to Business Object Enterprise as well? Please advise.

Thanks Jared

[Former Member · Accepted solution]

I am talking about the installation of BOE XI R2 on Linux. Maybe in the BOE 3.1 environment the connection management has changed, so I recommend you to follow the Access Guide:

http://help.sap.com/businessobject/product_guides/boexir31/en/xi3-1_data_access_guide_en.pdf

You can get the JDBC driver from microsoft:

http://www.microsoft.com/spain/sql/technologies/jdbc/default.mspx