DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Inserting external data

  1. 10-09-2003, 01:41 AM #1
    GKramer
    GKramer is offline Junior Member
    Join Date
    Apr 2003
    Location
    Rosmalen, Netherlands.
    Posts
    73

    Inserting external data

    Hi,

    I'm looking for a way to insert data into an Oracle database which is stored in an external Interbase database (probably using ODBC).

    I have to gather a lot of data from different sources and put them all together for analisys. Not only one schema but all schema's in all databases ( if you can help me out on this please give me some tips or hints ). The real chalange is to extract data from other databases ( not Oracle ) and invoke it into Oracle.

    Can this be done and if so....how?

    Please help me out on this.

    GKramer
    Reply With Quote Reply With Quote
  2. 10-09-2003, 04:21 AM #2
    abhaysk's Avatar
    abhaysk
    abhaysk is offline Krishna
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Couple of options

    * Oracle Hetrogenious Services (not sure if it supports the other DB u are wanting the data to be moved).

    * ETL tool.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
    Reply With Quote Reply With Quote
  3. 10-09-2003, 06:30 AM #3
    GKramer
    GKramer is offline Junior Member
    Join Date
    Apr 2003
    Location
    Rosmalen, Netherlands.
    Posts
    73
    abhaysk

    Where can I find them ??

    GKramer
    Reply With Quote Reply With Quote
  4. 10-09-2003, 07:01 AM #4
    abhaysk's Avatar
    abhaysk
    abhaysk is offline Krishna
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    * Oracle Hetrogeneous Services (not sure if it supports the other DB u are wanting the data to be moved).

    Transparent gateways

    * ETL tool.

    One of them (most commonly used) will be Informatica.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width