1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Inserting data of Oracle Apps R12 Payroll Results into MySQL database tables.

Discussion in 'Other Databases' started by mogalafzal, Dec 15, 2013.

  1. mogalafzal

    mogalafzal Active Member

    Likes Received:
    Trophy Points:
    Hi ,

    We got a requirement to integrate between oracle database and MySQL Server.
    The payroll will be run in the Oracle Apps R12, and need to develop an API to insert data of payroll results into MySQL database tables, this will be for 4,5 months as Finance Modules of Apps will be implemented for them too, So this MySQL will be replaced totally by Oracle.

    Kindly suggest all the steps, as this is my first time.

    Our Database of Oracle is in Linux. Apps Version is R12.1.3

    I went through a online document, but it says 'updates, delete or inserts might fail' by using the dg4odbc gateway, need to use 'different gateway called DG4MSQL, which requires purchase of new licensing.'

    Thanks a lot in advance.