In Oracle : Defining Source Data Structures from a SQL Server

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

Oracle Data Warehouse & BI

In-Oracle.com  -> Oracle Data Warehouse & BI  -> Oracle Data Warehouse

-> Defining Source Data Structures from a SQL Server

 

 Defining Source Data Structures from a SQL Server

 

 

Note: I have used Oracle Warehouse Builder 11.2.0.1

 

Start the Design Center

Start button -> All Programs -> Oracle 11g Installation (Name) -> Warehouse Builder -> Design Center

 

Defining Source Data Structures from an SQLServer database

 

Note: You must have the Oracle Heterogeneous Services configured.

 


 

Right click on ODBC  (under databases).

 

Defining Source Data Structures from an SQLServer database

 

Click on "Next".

 

 

Defining Source Data Structures from an SQLServer database

 

Choose a name for the SQLServer database module, the role of the module and a description. The description is not mandatory.

 

Click on "Next".

 

Defining Source Data Structures from an SQLServer database

 

Click on "Edit". Choose the right values for User Name, Password, Host, Port, Service Name, SQL Server Schema.

 

Defining Source Data Structures from an SQLServer database

 

Click on "OK", then click on "Next".

 

Defining Source Data Structures from an SQLServer database

 

 

Click on "Finish".

 

Defining Source Data Structures from an SQLServer database

 

Right click on the SQLServer module (under ODBC) and choose "Validate".

 

Defining Source Data Structures from an SQLServer database

 

You must receive no errors.

 

Note: When a module is created no objects (tables, views, sequences) are related to this module:

 

Defining Source Data Structures from an SQLServer database

 

Now you must import the SQL Server data structures in order to create the OWB design.

 

 

In-Oracle.com  -> Oracle Data Warehouse & BI  -> Oracle Data Warehouse

-> Defining Source Data Structures from a SQL Server

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

 

     Copyright (c) 2011-2015  www.in-oracle.com  |  Disclaimer: The views expressed on this web site are my own and do not reflect the views of Oracle Corporation. You may use the information from this site only at your risk.