2 Replies Latest reply: Mar 29, 2007 11:28 PM by alvinder RSS

    Connecting To Teradata from Oracle

      Can anybody please tell me how to connect to teradata from oracle and could you include some sample code too.
        • 1. Re: Connecting To Teradata from Oracle
          Even I am also finding the same... Could anybody respond fast............???!!!
          • 2. Re: Connecting To Teradata from Oracle
            Let me try to answer this one. I have done this on sun machine.

            Here are the few steps that are involved.

            1. Install the ODBC drivers for the teradata in oracle user home.
            2. create a .odbc.ini in oracle user home with the details as database name , IP address and few more details.
            3. Update the listener.ora with a new service. shutdown and restart
            4. Create an entry into the tnsnames.ora . Make sure the host should be pointing to the server where the listener is running. Also make sure you have (HS=...) in the tnsnames entry.
            5. Create a dblink.

            I have a document somewhere which i created to do this. Once i find it i will post it here.

            Hope this helps.

            1) Database link, it contains the password
            create database link "ABC.COM.AU"
            connect to ABC
            identified by "<pwd>"
            using 'DEF';

            2) tnsnames.ora
            The IP address is pointed to any server which has listener.ora, .odbc.ini and odbc set up
            DEF =
            (DESCRIPTION =
            (ADDRESS_LIST =
            (ADDRESS = (PROTOCOL = TCP)(HOST = IP_ADDRESS)(PORT = 1521))
            CONNECT_DATA = (SID = DEF)

            3) listener.ora on the host pointed by the tnsnames.ora of the database server, in this case IP_ADDRESS
            SID_LIST_LISTENER =
            (SID_LIST =
            (SID_DESC =
            (SID_NAME = PLSExtProc)
            (ORACLE_HOME = /u01/app/oracle/product/10.1.0/db_1)
            (PROGRAM = extproc)
            (SID_DESC =
            (SID_NAME = DEF)
            (ORACLE_HOME = /u01/app/oracle/product/10.1.0/db_1)
            (PROGRAM = hsodbc)

            4) .odbc.ini
            Description=Group Data Warehouse V2R4.1

            Message was edited by:

            Message was edited by: