The range should include the column names and the data. In the employee_details worksheet, highlight the range to query from Oracle. If you want to delimit the data to be imported from the Excel file, then define a name for the range of data being sourced: Step 2: Delimit the Data in the Excel File (Optional) By default, the ODBC driver for Excel is installed on a Windows system. To read data from Microsoft Excel, you need the ODBC driver for Excel. The datasource (DSN) is now set up.ĮP Evaluator 12.1 DOC ID:EE12.1_HELP Help Version:1.0 Filename: odbc_im_setup_DSN.This case study shows you how to use an Excel file called employees.xls as a source in Oracle Warehouse Builder. Click Test Connection, enter the LPM database password then click OK.Batch Autocommit Mode should be set to Commit only if all statements succeed. Uncheck Enable Query Timeout and leave the rest unchecked. Application: Check Enable Result Sets.From the driver configuration window, enter the following data in the available fields:.This driver is no longer supported by Microsoft and it will not import data into EE. You may also see an Oracle ODBC Driver from Microsoft. NOTE: Check in the third column that the company listed is Oracle. Select the Oracle ODBC driver and click Finish.Once the Oracle ODBC driver is installed, open Data Acquisition - Middleware from the RRE menu in EE.The DSN button in EE launches the correct ODBC Manager for use with EE. The default ODBC Manager on 64-bit systems creates 64-bit ODBC connections which EE cannot use. The best way to ensure that you are inspecting, creating, and modifying 32-bit ODBC definitions is to use the DSN button from the EE Data Acquisition window to launch the ODBC Manager. NOTE: EE is a 32-bit application. It cannot see or use 64-bit ODBC/DSN connections. A similar process will have to be completed for other data sources. This process is also documented in the ODBC User's Guide for IM (ODBCUG). From the System DSN tab, select name of the connection you created.Close the ODBC Data Source Setup window.If the DSN connection configuration tests positively, click OK.To set a firewall exception in Windows 7 Professional type 'firewall' into the Start search box and it will run the 'Windows Firewall with Advanced Security" interface. To temporarily disable the firewall go to Control Panel, System and Security, Windows Firewall and click on Turn Windows Firewall On or off. This can be done by either disabling the firewall or setting up an exception.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |