Using Attunity SSIS Adapter for Oracle

1. Download the adapters from:
   SQL 2012: http://www.microsoft.com/en-us/download/details.aspx?id=29283
   SQL 2019: https://www.microsoft.com/en-us/download/details.aspx?id=58228
   
2. Select “New Connection” on Connection Managers, and choose “MSORA”
   

3. Enter the connection details
   

4. I’m connecting to PeopleSoft – this is how the connection looks like:
   

TNS File: C:\Oracle\product\11.2.0\client_1\network\admin\tnsnames.ora

FS9UAT =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = talsv302)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = FS9UAT.towerlife.com.au)
    )
  )

5. Drop an Oracle Destination from the SSIS Toolbox into the data flow task, and configure it accordingly
   

Happy coding !