Wednesday, 13 May 2015

Connecting to TERADATA using SSIS

Connecting to Teradata using SSIS can be tough a task if you miss installing important prerequisite.

It is best to have some Teradata Expert with you to help you understand required prerequisite installations. I was luck to have friend who provided me all the perquisite installation file in a shot.

Following is a step by step guide
  1. Instllation of Teradata prerequisite

Following is list of Drive I have install ( in a sequence)

      1. Microsoft Dot net 3.5
      2. Shared ICU Libraries For Teradata
      3. Teradata GSS Client V
      4. Teradata Data connector V
      5. .NET Data Provider for Teradata V (For .NET Driver of SSIS)
      6. ODBC Driver for Teradata V14.00.0.4  (For having ODBC connection)
      7. Teradata SQL Assistant V ( A SQL browser like Todd, help you check connectivity with TERADATA)
      8. Teradata Administrator v14.00.0.2
      9. Teradata CLIv2 v14.00.0.4
      10. Teradata BTEQ v14.00.0.5
      11. Teradata ARC v14.00.0.4
      12. Teradata MultiLoad v14.00.0.8
      13. Teradata FastLoad v14.00.0.7
      14. Teradata FastExport v14.00.0.5
      15. Teradata TPump v14.00.0.6
      16. Java Runtime Environment
      17. Teradata Parallel Transporter Base v14.00.0.8
      18. Teradata Parallel Transporter Stream v14.00.0.8

Above all are very simple setup file and required no input from installer, just double click and couple of next button will get you through.
Once you installed all these drive I recommend having a restart of your machine/server if possible. 

  1. Creating a Data Source connection

·        Create a Shared Data source like following

·        You will get option to select a Tera Data Driver.
·        Select the “.Net Data Provide for TeraData”
·        Fill the details of Server, credentials and database name

·        After filling details do a test connection.

  1. Using connection in Source

·        Drag and drop “ADO .NET Source”

·        Double click on this to configure source component like below

·        Simply select data source you have created in above steps and after that you will get option to browse the table list, select the table you want to pull data from.

That’s it. Connect this source further in transformation or destination as per your requirement. 
You will be able to source data from TERADATA.

Apart from this there is another way of connecting is by using Attunity, which you can get it from following –

if you have followed all the above steps, you should not be facing any problem using this driver.