Big Data Platform
Cloud API Services Platform
Cloud Big Data Platform
Cloud Data Fabric
Cloud Data Management Platform
Data Management Platform
Data Services Platform
Real-Time Big Data Platform
This article applies to version 5.6 onwards of all platform Studios with Data Quality .Procedure
If you want to define the report data mart 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.
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-18.104.22.168.0.i386.rpm and oracle-instantclient11.2-devel-22.214.171.124.0.i386.rpm .
Install and configure Oracle OCI client, use alien , dpkg and aio :
Install alien .
sudo apt-get install alien
Transform rpm to deb .
sudo alien ./oracle-instantclient11.2-basic-126.96.36.199.0.i386.rpm sudo alien ./oracle-instantclient11.2-devel-188.8.131.52.0.i386.rpm
Install the deb files.
sudo dpkg -i ./oracle-instantclient11.2-basic_184.108.40.206.0-2_i386.deb sudo dpkg -i ./oracle-instantclient11.2-devel_220.127.116.11.0-2_i386.deb
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.
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.
This example supposes that you use Oracle 10gr2 and you want to configure OCI on Windows x86.
Download the appropriate instant client zip file for Windows 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.
Install and configure Oracle OCI client.
Unzip all the files to a folder, for example c:\oracle_oci_client .
Add system environment variables as the following:
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>
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) ) )
- Install and configure the Oracle OCI client appropriate to your system as described above.
Add the below parameter into the .ini file of your Studio.
Start your Talend Studio and from the Profiling perspective, define Oracle OCI as the report data mart from the report editor or from the Preferences window.