Goal This document describes how to configure an ODBC data source for an OBIEE Linux installation to connect to Denodo Virtual DataPort. Content To connect an Oracle Business Intelligence installation (from a Linux system) with Denodo VDP, follow the next steps: • Configure the Linux environment. • Configure the ODBC driver. • Modify the bi-init, opmn.xml, user.sh and odbc.ini files. • Create a new Oracle BI metadata repository. • Create the DSN. • Install the OBI Administration Tool.

• Create the repository. • Import the repository in the Oracle BI instance. • Import from FMW Configure the Linux environment Oracle Business Intelligence bundles UNIX ODBC drivers (Merand a.k.a DataDirect a.k.a Progress Software) for some data sources including PostgreSql. As Denodo is compatible with the PostgreSql ODBC Driver it is possible to leverage the bundled driver.

The driver is located at: /Oracle_BI1/common/ODBC/Merant/7.0.1/lib/ARpsql26.so The folder version and file name may be different (e.g. 6.1/lib/ARpsql25.so), so use the latest version available. To enable SSL for the connection specific versions will have to be used as described later in this document. In order to configure the driver path we need to edit the following files to point to the correct version of the driver.

By default it may be using version 5.3 which does not include PostgreSql. The files are: • ORACLE_INSTANCE/bifoundation/OracleBIApplication/coreapplication/setup/user.sh. • ORACLE_INSTANCE/bifoundation/OracleBIApplication/coreapplication/setup/bi-init.sh.

• ORACLE_INSTANCE/config/OPMN/opmn/opmn.xml We need to a dd the path for the driver to one of the path variables inside those files. Note the following: • For Solaris and Linux, the library path variable is LD_LIBRARY_PATH. • For HP-UX, the library path variable is SHLIB_PATH. • For AIX, the library path variable is LIBPATH. Find the occurrences of Merant/5.3 in those files and adjust to the driver path.

Once the files are modified, edit the odbc.ini file that can be found at: ORACLE_INSTANCE/bifoundation/OracleBIApplication/coreapplication/setup/odbc.ini Create an entry for each Denodo database to access ensuring that the ODBC connection name is identical to the data source name specified in the connection pool defined in the OBIEE repository. Set the Driver parameter to the file name and location of the Denodo ODBC driver, with the library suffix appropriate for the operating system (for example,.so for Solaris and AIX, or. Renal Nutrition Games here. sl for HP-UX).

The Microsoft® ODBC Driver for Oracle allows you to connect your ODBC-compliant application to an Oracle database. The ODBC Driver for Oracle conforms to the Open.

The following example provides details for a Denodo data source, with “Denodo” as data source name.

ODBC connector to Oracle database provides high-performance and feature-rich connectivity solution for ODBC-based applications to access Oracle databases from Windows, Linux, Mac OS X, both 32-bit and 64-bit. Full support for standard ODBC API functions and data types implemented in our driver makes interaction of your database applications with Oracle fast, easy and extremely handy. Key Features: - Direct Connection. Database applications based on our solution get an opportunity to establish connection to Oracle by means of native Oracle client software and in Direct Mode. Direct Mode gives your applications an unrivaled advantage - connection to Oracle databases directly via TCP/IP avoiding Oracle Client. That improves performance of your applications, their quality, reliability and especially the deployment process, since there is no need to supply additional client software together with your application. - Development Platforms Variety. Pokemon Zipper Jacket.

ODBC driver for Oracle doesn't limit your choice of the development platform and environment. The driver installations are available for various operational systems and platforms. The current version supports Windows, Linux and Mac OS X, both 32-bit and 64-bit. - DB Compatibility. ODBC driver for Oracle supports Oracle servers: 12c, 11g, 10g, 9i, 8i, 8. Rehanfx Registration Code Serial. 0, including Oracle Express Edition 11g and 10g. ODBC driver for Oracle supports both x86 and x64 versions of the following Oracle Clients: 12c, 11g, 10g, 9i, 8i, 8.0.