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

    Connecting To Teradata from Oracle

    464319
      Hi,
      Can anybody please tell me how to connect to teradata from oracle and could you include some sample code too.
      Thanks
      Lambor.
        • 1. Re: Connecting To Teradata from Oracle
          536603
          Even I am also finding the same... Could anybody respond fast............???!!!
          • 2. Re: Connecting To Teradata from Oracle
            alvinder
            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)
            )
            (HS=OK)
            )

            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)
            (ENVS=LD_LIBRARY_PATH=/u01/app/oracle/product/10.1.0/db_1/lib32:/u01/home/oracle/odbc/lib)
            )


            4) .odbc.ini
            [DEF]
            Driver=/u01/home/oracle/odbc/drivers/tdata.so
            Description=Group Data Warehouse V2R4.1
            DBCName=IP_ADDRESS
            Database=db_name
            DefaultDatabase=db_name

            Message was edited by:
            alvinder

            Message was edited by:
            alvinder