Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2007
    Posts
    4

    Unanswered: Teradata to Oracle Migration

    Hi All,

    I want to know how i can extract data from teradata to oracle.

    If you know of BTEQ to SQL*Plus/PL/SQL converter:
    which can convert teradata files into SQL Loader or
    if you know how to create scripts to extract
    the data and creating corresponding SQL*Loader control files to load the data into Oracle tables.


    If anybody of you know about any free tool available in market/internet, plz help me on this. Its Urgent.........

    Thanks & Regards,
    Frilto
    Last edited by frilto123; 12-11-07 at 10:15.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Dec 2007
    Posts
    4
    Hi,

    Thanks for the reply,

    I am sorry,
    I am really not able to figure out the dbi driver for teradata,
    I have downloaded the file DBD-Teradata1.50

    I request you to give detail about this tool ---does this tool convert teradata database files to oracle.
    ----do i have to install perl before i install this tool.
    Thank you very much for your suggestion.

    Regards,
    Frilto.

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >do i have to install perl before i install this tool.
    Yes.
    Also download & install DBD::Oracle
    Then from a custom PERL code, you can SELECT from Teradata & INSERT directly into Oracle.

    Do all the datatypes in Teradata have comparable datatype in Oracle?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Dec 2007
    Posts
    4
    Hi,

    Thanks for the suggestion,
    I would have to use Perl scripts to access databases using the DBI/DBD Driver.

    Do all the datatypes in Teradata have comparable datatype in Oracle?We would be writing Perl scripts using DBI
    So i would say the datatypes of TERADATA and DBI DATATYPE must be comparable and then the DATATYPE between DBI and ORACLE should be.

    Check out the following sites on the portability of these:
    http://search.cpan.org/src/DARNOLD/D...c/tdatdbd.html

    http://home.fnal.gov/~dbox/SQL_API_Portability.html

    http://download.oracle.com/docs/cd/B...b.htm#BGBBBBDJ

    When loading data to oracle you would have to use flag for each bind variable for some datatypes.

    Regards,
    Abhiram.

  6. #6
    Join Date
    Dec 2007
    Posts
    4
    Hi,

    You can just use Oracle and the teradata ODBC driver alone to connect the two which is available free from http://www.teradata.com/t/page/130536

    This is more info i GOT...

    You can create an Oracle DB link that uses an ODBC connection. This ODBC connection can be a Teradata ODBC driver. Then, with appropriate synonyms, you can actually make Teradata based tables accessible from within Oracle. It's Oracle-centric in that you have to work within Oracle, but you can do both selects and inserts into Teradata tables from within Oracle, and the TD tables look like local Oracle tables to your SQL*Plus or PL/SQL code.


    The only downside is that if you try to join tables through the db link, it gets pretty slow. It's great for moving data back and forth though. It also requires no third party software if you already have Oracle and Teradata.There is a way for doing it through oracle heterogeneous services


    HERE ARE 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

    GOT IT FROM --http://forums.oracle.com/forums/thread.jspa?messageID=1763123

    More info on heterogeneous systems
    http://www.datadirect.com/developer/...eous/index.ssp

    Below is the DATASHEET for the supported versions for the Oracle Transparent Gateway---http://www.oracle.com/technology/products/oraclei/datasheets/gateways/gateway_rel2_ds.html

    This describes the way for connecting though Transperency Gateway :
    http://download.oracle.com/docs/html/B10543_01/ch1.htm

    Regards,
    Frilto.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •