This article provides information about configuring Oracle Repository connection

To create a new Oracle repository connection

Click Options
Click Plus
Enter connection name
Set type to Oracle
Select/Enter TNS name or use instant client syntax
Enter user name and password
Make sure that connection actually works

Oracle Repository

Working with Oracle:

Always install the latest relevant client

   Oracle client 8.1.7 to load data into/from Oracle
     Or
   Oracle client 9 to load data into/from Oracle
     Or
   Oracle client 10 to load data into/from Oracle
     Or
   Oracle client 11 to load data into/from Oracle
     Or
   Oracle client 12 to load data into/from Oracle

Videos

Note: 32-bit version of our ETL Software uses 32-bit version of Oracle client and 64-bit version of our ETL Software uses 64-bit version of Oracle client

Download Free Trial Learn More About Our ETL Software

We have 164 guests and no members online