#2019 - Oracle ODBC?
Has this been tested with Oracle ODBC? I'm not terribly familiar with using ODBCs, and am having trouble getting the right components installed and showing up available in ETLS.
Has this been tested with Oracle ODBC? I'm not terribly familiar with using ODBCs, and am having trouble getting the right components installed and showing up available in ETLS.
8 years ago
Oracle ODBC setup requires proper driver installation and a detailed example of the components and installation steps can be found at [https://itkbs.wordpress.com/2014/07/28/how-to-install-odbc-driver-for-oracle-in-windows-7] (https://itkbs.wordpress.com/2014/07/28/how-to-install-odbc-driver-for-oracle-in-windows-7). The last paragraph in the example covers configuration issues and offers help on how to resolve them.
When you get to the proper ODBC administration panel, please add a File DSN _instead _of a System DNS - then point to the File DSN as a Data Source in ETLSetup (DemoAccess.config and DemoExcel.config in ETLSetup use such File DSN as Data Sources).
Thanks for you inquiry and hope this helps.