OWB - Source

Location Node :

• Oracle Database : Any Oracle Database
• Non-oracle Database : Any database accessible through Oracle Oracle Database - Gateway (Heterogeneous services) :
  • DB2,
  • DRDA,
  • Informix,
  • SQL Server,
  • Sybase,
  • and Teradata.
  • ODBC Data Source as Excel and MS Access
• Files : Delimited and fixed-length flat files.
• Applications :
  • SAP R/3 3.x, 4.x
  • Oracle E-Business Suite
  • PeopleSoft 8, 9

Databases/Transportable Module Source is only valuable for moving large volume of data and may be use the Transportable Tablespaces features

• OWB - Creating an ODBC Non-Oracle Module as data source (with Excel)

• Supported Sources and Targets