1 Reply Latest reply: Mar 19, 2013 6:18 AM by Tridus RSS

    Embedded license ODBC connection for 11g

      We are a small IT department. We support a large ERP system on Oracle 11g. The licensing for Oracle is an embedded license provided by the ERP supplier so is not a full Oracle license.

      At the moment we are limited to extracting data into CSV files and uploading them into our SQL database. Slow and prone to error. Does anyone know if we can use an ODBC driver to extract data from the Oracle tables into our SQL based BI system? Our ERP supplier has stated that we need to purchase the full Oracle license for this which is prohibitively expensive.