Oracle Import

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • Answered
  1. Is there a way to automate an import directly from Oracle?
  2. When importing data to a child table how to I make sure it references the correct parent record?

Photo of Bradley Damron

Bradley Damron

  • 320 Points 250 badge 2x thumb

Posted 4 months ago

  • 0
  • 1
Photo of dwhawe

dwhawe, Champion

  • 662 Points 500 badge 2x thumb
I use QuNect (QuNect.com) and Microsoft Access.  There are probably better tools than Access but it is what I know.  QuNect gives me ODBC to Quick Base.

I harvest what I need from the Oracle tables using their ODBC then append it to Quick Base.

For the Child Parent situation, you populate the Reference field in the Child table with the value of the Key Field of the Parent record.  Without knowing your table structure, it is difficult to give much more.

If I am using the Record ID as the Key Field, then the Parent record must be created first, then the Record ID harvested so it can be used to populate the Reference field in the Child record.
Photo of cvonroesgen

cvonroesgen

  • 20 Points
Or you could create a Linked Server in your Oracle database:

http://www.dba-oracle.com/t_heterogeneous_database_connections_sql_server.htm