Product specifications
A set of data access drivers are installed when you install the SAP BusinessObjects Business Intelligence
platform. You can use these data access drivers to create connections to databases. They are located
in the connectionserver-install-dir\connectionServer\drivers\lib32 or connection
server-install-dir\connectionServer\drivers\lib64 directory.
SAP BusinessObjects software also includes configuration files for using ODBC drivers to access your
databases. To use these drivers, you do the following:
1.
Obtain the ODBC driver software from your database supplier.
2.
Modify the supplied configuration files.
For an up-to-date list of supported ODBC drivers, check the SAP Service Marketplace at http://ser
vice.sap.com/bosap-support, or contact your SAP representative.
Note:
The Data Access layer provides the Generic ODBC connectivity to create a connection to a data source
that the SAP BusinessObjects Business Intelligence platform does not support explicitly.
About generic ODBC connections on UNIX
The Microsoft Windows operating system comes with a standard ODBC driver manager. In contrast,
UNIX does not provide any standard way to manage drivers. SAP BusinessObjects software allows
you to use either DataDirect or unixODBC driver managers for generic ODBC connections on UNIX.
Before creating a generic ODBC connection on UNIX for a specific database, you must identify the
following:
• the version of the ODBC driver
• if the driver is able to work with DataDirect driver manager or unixODBC
You then modify the supplied configuration files and configure the relevant data source to enable the
connection.
Note:
You can configure only one connection through a generic ODBC implementation.
Related Topics
• To create a generic ODBC connection
• To create a generic ODBC3 connection
5.5.1 To create a generic ODBC connection
The following procedure shows how to configure a generic ODBC connection to a database with the
following assumptions:
• The driver is ODBC2
• The driver supports the unixODBC driver manager
1.
Navigate to the directory that contains the odbc.sbo and odbc.prm files.
2012-03-1559
Creating a connection