2 Replies Latest reply: Jan 2, 2013 3:44 AM by Mkirtley-Oracle RSS

    Connect to MYSQL DB from Oracle

    Lokanath Giri
      MY SQL version- (5.1.61)
      Oracle (11.2.0.2.0 - 64bit)

      We need to read a view in MYSQL from Oracle & dump the data into Oracle stage table.
      Kindly give the steps in details.

      Thank you.

      Best Regards,
      Lokanath Giri
        • 1. Re: Connect to MYSQL DB from Oracle
          damorgan
          Dump the MySQL data to an ASCII file and read it using an external table.

          Fastest, simplest, and doesn't require licensing any other products or performing any special configuration steps.
          • 2. Re: Connect to MYSQL DB from Oracle
            Mkirtley-Oracle
            Hi,
            You could use the Database Gateway for ODBC (DG4ODBC) to make a connection to the MySQL database and then use the copy, 'create table as select..." or select/insert commands to move the MySQL data into Oracle tables.
            You will need access to My Oracle Support but the folloiwng notes have details on setting up Dg4ODBC on variosu platforms -

            How to Configure DG4ODBC on Linux x86 32bit or on HP-UX RISC (DG4ODBC 11.1 only) to Connect to Non-Oracle Databases post install (Doc ID 466228.1)
            How to Configure DG4ODBC on 64bit Unix OS (Linux, Solaris, AIX, HP-UX Itanium) to Connect to Non-Oracle Databases Post Install (Doc ID 561033.1)
            How to Setup DG4ODBC (Oracle Database Gateway for ODBC) on Windows 32bit (Doc ID 466225.1)
            How to Configure DG4ODBC (Oracle Database Gateway for ODBC) on 64bit Windows Operating Systems to Connect to Non-Oracle Databases Post Install (Doc ID 1266572.1)

            Then this note has information on moving the data -

            Copying Data Between an Oracle Database and Non-Oracle Foreign Data Stores or Databases Using Gateways (Doc ID 171790.1)

            You could also use GoldenGate which allows real-time replication of data between Oracle and non-Oracle databases.

            Regards,
            Mike