Installing and configuring Oracle OCI to be used as the datamart for reports

author
Talend Documentation Team
EnrichVersion
6.4
6.3
6.2
6.1
EnrichProdName
Talend Data Management Platform
Talend Real-Time Big Data Platform
Talend Data Fabric
Talend MDM Platform
Talend Big Data Platform
Talend Data Services Platform
task
Installation and Upgrade
Data Quality and Preparation
Data Quality and Preparation > Profiling data
EnrichPlatform
Talend Studio

Installing and configuring Oracle OCI to be used as the datamart for reports

This article gives you some guidance about the installation procedure. For detail information, please refer to the Oracle installation documents. Before being able to use Oracle OCI as the database where you keep a history of the reports you run in the Profiling perspective of the studio, you must first install the Oracle OCI client environment and configure it to work correctly with Talend.
Environment

This article applies to version 5.6 onwards of all platform studios with Data Quality .

Procedure

If you want to define the report datamart using Oracle OCI, you must first install the OCI client and then configure the .ini file of your Studio as described below.

Oracle OCI on Linux

This example supposes that you use Oracle 11gr2 and you want to configure OCI on Linux x86.

  1. Download the appropriate instant client zip file for Linux x86.

    Check Instant Client Downloads for Linux x86 ( Instant Client Downloads for Linux x86-64 ) for download links and detail information about installation.

    The most important files to have are the .so and .h head files: oracle-instantclient11.2-basic-11.2.0.2.0.i386.rpm and oracle-instantclient11.2-devel-11.2.0.2.0.i386.rpm .

  2. Install and configure Oracle OCI client, use alien , dpkg and aio :

    1. Install alien .

      sudo apt-get install alien
    2. Transform rpm to deb .

      sudo alien ./oracle-instantclient11.2-basic-11.2.0.2.0.i386.rpm
      sudo alien ./oracle-instantclient11.2-devel-11.2.0.2.0.i386.rpm
    3. Install the deb files.

      sudo dpkg -i ./oracle-instantclient11.2-basic_11.2.0.2.0-2_i386.deb
      sudo dpkg -i ./oracle-instantclient11.2-devel_11.2.0.2.0-2_i386.deb
      
    4. Install aio.

      sudo apt-get install libaio-dev
      

      After installation, the two .deb files will be located at /usr/lib/oracle/11.2/client/lib and /user/include/oracle/11.2/client respectively.

  3. Set the path of the LD_LIBRARY_PATH environment variable. You can use, for example:

    vim ~/.bashrc
    export LD_LIBRARY_PATH=/opt/oracle/instantclient_12_1:$LD_LIBRARY_PATH 

    Alternatively, you can add this path by using ldconfig but make sure first that there is no other Oracle software that will be impacted.

Oracle OCI on Windows

This example supposes that you use Oracle 10gr2 and you want to configure OCI on Windows x86.

  1. Download the appropriate instant client zip file for Winbdows x86. Installation requires the basic package.

    Check Instant Client Downloads for Windows x86 ( Instant Client Downloads for Windows x86_64 ) for download links and detail information about installation.

  2. Install and configure Oracle OCI client.

    1. Unzip all the files to a folder, for example c:\oracle_oci_client .
    2. Add system environment variables as the following:

  3. On Windows:

    1. Change the Oracle driver from thin to oci , you must change the url as the following:

      thin: jdbc:oracle:thin:@ <host>:<port>:<db name>

      oci: jdbc:oracle:oci8:@ <tns name>

    2. Copy tnsnames.ora to c:\oracle_oci_client , and add tns configuration as the following:

      OCI39 =
      
        (DESCRIPTION =
      
          (ADDRESS_LIST =
      
            (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.31.39)(PORT = 1521))
      
          )
      
          (CONNECT_DATA =
      
            (SID = root)
      
          )
      
        )
Using Oracle OCI with Talend Studio
  1. Install and configure the Oracle OCI client appropriate to your system as described above.
  2. Add the below parameter into the .ini file of your studio.

    -Djava.library.path=c:\oracle_oci_clien
  3. Start your Studio and from the Profiling perspective, define Oracle OCI as the report datamart from the report editor or from the Preferences window.

Related Jira Issues

DOCT-3650