2 Replies Latest reply on Mar 30, 2007 4:28 AM by alvinder

    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