Oracle Warehouse Builder use the gateway capabilities of the oracle database to create Non-Oracle Module.
This article will create an ODBC Non-Oracle Module on Excel data source.
To set up the ODBC connectivity to a data source, you have perform the steps :
of this article : Oracle Database - How to read data through an ODBC connection with Gateway (Heterogeneous services)
After you set up the ODBC connectivity to a data source, you must create an ODBC module to import the metadata from this data source. The ODBC node is available under the Databases node in the Projects Navigator. To create an ODBC module:
At the end of the module wizard, you can see than the Non-Oracle Module is an Oracle Database - Gateway (Heterogeneous services) application.
The newly created ODBC module is now available under the ODBC node.
Select the Connection Type to be one of :
If you selected Host:Port:Service, then provide the following connection details:
If you selected Database Link, then provide the following connection details:
For SQL*Net, provide the following connection details:
Click Test Connection to verify that you have provided the correct details and click OK to set the connection details.
When you want to import the metadata, you will see the name define in the creation step of the excel file.