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.
You'll need to ask a lawyer to get an answer on this that you should actually use. That said if the ERP supplier said that their embedded licensed version doesn't allow you to do it, there's a decent chance they know what they're talking about.