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
- Instllation
of Teradata prerequisite
Following is list of Drive
I have install ( in a sequence)
- Microsoft Dot net 3.5
- Shared ICU Libraries For Teradata 14.00.0.1
- Teradata GSS Client V 14.0.2.2
- Teradata Data connector V 14.00.0.10
- .NET Data Provider for Teradata V 14.00.0.1 (For .NET Driver of SSIS)
- ODBC Driver for Teradata V14.00.0.4 (For having ODBC connection)
- Teradata SQL Assistant V 14.01.0.2 ( A SQL browser like Todd, help you check connectivity with TERADATA)
- Teradata Administrator v14.00.0.2
- Teradata CLIv2 v14.00.0.4
- Teradata BTEQ v14.00.0.5
- Teradata ARC v14.00.0.4
- Teradata MultiLoad v14.00.0.8
- Teradata FastLoad v14.00.0.7
- Teradata FastExport v14.00.0.5
- Teradata TPump v14.00.0.6
- Java Runtime Environment
- Teradata Parallel Transporter Base v14.00.0.8
- 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.
- 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.
- 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.
You can also view Microsoft
documentation on this here http://download.microsoft.com/download/D/B/D/DBDE7972-1EB9-470A-BA18-58849DB3EB3B/SSIS_Teradata_Connectors.docx
