none
Setting up Teradata connection manager

    Question

  • Hi,

    I am running SSIS 2005 and has requirements to source data from Teradata but I do not see a costume Teradata provider in the SSIS Connection Manager list. Any help in setting up a connection manager to Teradata is appreciated.

    Thanks


    Francis, MCTS: BI 2008, MCITP: BI 2008 Stay Thirsty My Friends

    Thursday, August 29, 2013 9:16 PM

Answers

  • Hi,

    I am running SSIS 2005 and has requirements to source data from Teradata but I do not see a costume Teradata provider in the SSIS Connection Manager list. Any help in setting up a connection manager to Teradata is appreciated.

    Thanks


    Francis, MCTS: BI 2008, MCITP: BI 2008 Stay Thirsty My Friends

    Could you Install Teradata ODBC driver in you machine where SQL server exists.

    can you get that .net provider from

    http://developer.teradata.com/doc/tools/ttu/install/index.jsp?topic=%2F14_00_HelpWindowsDVD%2FDownloadingDotNetDataProviderTD.html

    and install it.


    Please Help People When they need..!!


    Friday, August 30, 2013 3:22 AM
  • Hi MostInterestingMan,

    As BKomm said, you can install the Teradata ODBC Driver for Windows. It can be downloaded from:
    http://downloads.teradata.com/download/connectivity/odbc-driver/windows

    Then, you can create a custom System DSN by using the Teradata ODBC driver and use it in your package:
    http://developer.teradata.com/doc/tools/ttu/install/index.jsp?topic=%2F14_00_HelpWindowsDVD%2FConfiguringODBCDatasSources_win_hpux.html

    Regards,
    Mike Yin

    If you have any feedback on our support, please click here


    Mike Yin
    TechNet Community Support


    Guys,

    I successfully installed the Teradata ODBC Driver but can't find Teradata in the "Create New Data Source" list when attempting to configure the ODBC Data Source. I've rebooted the server multiple times already.

    Thanks,


    Francis, MCTS: BI 2008, MCITP: BI 2008 Stay Thirsty My Friends

    Tuesday, September 03, 2013 1:37 PM

All replies

  • Hi,

    I am running SSIS 2005 and has requirements to source data from Teradata but I do not see a costume Teradata provider in the SSIS Connection Manager list. Any help in setting up a connection manager to Teradata is appreciated.

    Thanks


    Francis, MCTS: BI 2008, MCITP: BI 2008 Stay Thirsty My Friends

    Could you Install Teradata ODBC driver in you machine where SQL server exists.

    can you get that .net provider from

    http://developer.teradata.com/doc/tools/ttu/install/index.jsp?topic=%2F14_00_HelpWindowsDVD%2FDownloadingDotNetDataProviderTD.html

    and install it.


    Please Help People When they need..!!


    Friday, August 30, 2013 3:22 AM
  • Hi MostInterestingMan,

    As BKomm said, you can install the Teradata ODBC Driver for Windows. It can be downloaded from:
    http://downloads.teradata.com/download/connectivity/odbc-driver/windows

    Then, you can create a custom System DSN by using the Teradata ODBC driver and use it in your package:
    http://developer.teradata.com/doc/tools/ttu/install/index.jsp?topic=%2F14_00_HelpWindowsDVD%2FConfiguringODBCDatasSources_win_hpux.html

    Regards,
    Mike Yin

    If you have any feedback on our support, please click here


    Mike Yin
    TechNet Community Support


    Tuesday, September 03, 2013 3:34 AM
  • Hi MostInterestingMan,

    As BKomm said, you can install the Teradata ODBC Driver for Windows. It can be downloaded from:
    http://downloads.teradata.com/download/connectivity/odbc-driver/windows

    Then, you can create a custom System DSN by using the Teradata ODBC driver and use it in your package:
    http://developer.teradata.com/doc/tools/ttu/install/index.jsp?topic=%2F14_00_HelpWindowsDVD%2FConfiguringODBCDatasSources_win_hpux.html

    Regards,
    Mike Yin

    If you have any feedback on our support, please click here


    Mike Yin
    TechNet Community Support


    Guys,

    I successfully installed the Teradata ODBC Driver but can't find Teradata in the "Create New Data Source" list when attempting to configure the ODBC Data Source. I've rebooted the server multiple times already.

    Thanks,


    Francis, MCTS: BI 2008, MCITP: BI 2008 Stay Thirsty My Friends

    Tuesday, September 03, 2013 1:37 PM
  • Hi MostInterestingMan,

    Thanks for your posting.

    Which version of Teradata ODBC Driver have you installed, 32- bit or 64-bit? It can because that the ODBC driver and the ODBC Data Source Administrator is not matched. For example, if you install the 32-bit driver, please create the DSN within  the 32-bit ODBC Data Source Administrator. In a 64-bit OS, the path of 32-bit ODBC Data Source Administrator is C:\Windows\SysWOW64\odbcad32.exe, the path of 64-bit ODBC Data Source Administrator is C:\Windows\System32\odbcad32.exe.

    Regards,
    Mike Yin

    If you have any feedback on our support, please click here


    Mike Yin
    TechNet Community Support

    Tuesday, September 03, 2013 2:18 PM
  • Mike,

    It was the wrong version I am on win std 32 bit. I downloaded tdodbc__windows_i386.13.00.00.08.zip which includes several files. Do I need to install everything in that folder?

    Also, since I am behind a firewall do I need to expose Teradata specific ports on the SQL side?

    Thanks


    Francis, MCTS: BI 2008, MCITP: BI 2008 Stay Thirsty My Friends

    Tuesday, September 03, 2013 3:51 PM
  • Mike,

    It works now. Thanks for your help.


    Francis, MCTS: BI 2008, MCITP: BI 2008 Stay Thirsty My Friends

    Tuesday, September 03, 2013 9:16 PM