Use the following steps to create an ODBC source module:įrom the Projects Navigator, create an ODBC source module. FALSE is the default setting for this parameter. Remember to restart the listener after making these modifications.Įnsure that the initialization parameter GLOBAL_NAMES is set to FALSE in the database's initialization parameter file. The value associated with the PROGRAM keyword defines the name of the agent executable. (OWB_HOME = C:\oracle11g\product\11.2.0\db_1)įor the SID_NAME parameter, use the SID that you specified when creating the initialization parameter file for the Heterogeneous Services, which, in this case, is excelsid.Įnsure that the OWB_HOME parameter value is the path to your Oracle Database home directory. To set up the listener, modify the entries in the listener.ora file located in the OWB_HOME \network\admin directory as follows: When a request is received, the agent spawns a Heterogeneous Services agent. Set up the listener on the agent to listen for incoming requests from the Oracle Database. excelsid is the name of the Oracle system identifier used for the agent. Here, odbc_excel is the name of the system DSN you created in Step 3. This file is located in the OWB_HOME \hs\admin directory.Ĭreate the initexcelsid.ora file in the OWB_HOME \hs\admin directory as follows: ora, where SID is the Oracle system identifier used for the agent. The name of the Heterogeneous Services initialization file is init SID. Each agent has its own heterogeneous services initialization file. To configure the agent, you must set the initialization parameters in the heterogeneous services initialization file. Step 4: Create the Heterogeneous Services Initialization File Verify that the Version field lists the correct version of the source Excel file. For example, odbc_excel.Ĭlick Select Workbook to select the Excel file from which you want to extract data. The ODBC Microsoft Setup dialog box is shown in Figure 5-1.įigure 5-1 ODBC Microsoft Excel Setup Dialog Boxĭescription of "Figure 5-1 ODBC Microsoft Excel Setup Dialog Box"
ODBC EXCEL AUTOTRANSLATE DRIVER
Select Microsoft Excel Driver as the driver for which you want to set up the data source.Ĭlick Finish to open the ODBC Microsoft Excel Setup dialog box. Navigate to the System DSN tab and click Add to open the Create New Data Source dialog box. This opens the ODBC Data Source Administrator dialog box. Select Start, Settings, Control Panel, Administrative Tools, Data Sources (ODBC). Set up a System Data Source Name (DSN) using the Microsoft ODBC Administrator. Ensure that the column names confirm to the rules for naming columns in the Oracle Database.įrom the Insert menu, select Name and then Define. 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)
ODBC EXCEL AUTOTRANSLATE WINDOWS
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.
ODBC EXCEL AUTOTRANSLATE HOW TO
This case study shows you how to use an Excel file called employees.xls as a source in Oracle Warehouse Builder.
0 kommentar(er)
