SSIS Attunity Oracle Connector Example Step by Step

       SSIS Attunity Oracle Connector Example Step by Step

Step1 - Environment Setup:

1. Download the SQL Server Developer version from Microsoft sites Microsoft® SQL Server® 2008 Enterprise Evaluation: Trial Experience for IT Professionals (http://www.microsoft.com/en-us/download/details.aspx?id=1279). 
2. Download the Attunity connector from Microsoft site. (http://www.microsoft.com/en-us/download/details.aspx?id=29284)
3. Install the SQL Server 2008 and Attunity connector.

Step 2 - Create Simple Integration Service Project in BIDS 

 Step 3 -  Choose the Oracle Source & Oracle Destination

1. Open the Toolbar and click the choose item.
2. Select SSIS Data Flow Items section in the popup window.
3. Select the Oracle Source and Oracle Destination.

Step 4 -   Click the Control Flow and Drag the Data Flow Task

Step 5 -  Add Oracle Source in the Data Flow Task

1. Click the Data Flow Task Component then you will be moved to Task Flow editor.
2. Add the Oracle Source control from Toolbox.
3. Double click the Oracle Source Control and Configuration window will open.
4. Left side select the Connection Manager.
5. Click the new button in the Connection Manager
6. Add the Oracle connection details like connection name, TNS name (from tnsnames.org file), user id and password.
7. Click the test connection to test the connectivity.
8. Click OK button and select the connection in Connection Manager Drop down.
9. Select the SQL Command in the Data Access Mode drop down.
   
   
   

Step 6 - Add the SQL Server Destination.

1. Add the SQL Server Destination control from Toolbox.
2. Double click the SQL Server Destination Control and Configuration window will open.
3. Left side select the Connection Manager.
4. Click the new button in the Connection Manager
5. Add the SQL Server connection details like Server name, Authentication Mode, user id and password.
6. Click the test connection to test the connectivity.
7. Click OK button and select the connection in Connection Manager Drop down.
8. Select the destination SQL server table name in the drop down Use a table or view.

Step 7 - Mapping the Source and Destination Columns.

1. Click Left side select the Mapping section.
2. You can see the Source and Destination columns.
3. Map the source and destination columns.

 

Step 8 - Add the transaction link between Oracle Source and SQL Server Destination.

1. Click the Oracle Source output transaction to SQL Server destination control.
2. Configure the error transaction. 
3. 
   

 

 

Step 8 - Run the project.

Conclusion : Attunity is 20%  faster than OLE Source.

 

 

 

 

 

 

 

 

1.