Summary of Supported Sources and Targets

This section summarizes the supported sources and targets for each Location node as displayed in the Connections Navigator.

OWB supports sources from:

• Oracle Database releases 8.1 and later.

• Any database accessible through Oracle Heterogeneous Services (Gateways), including but not limited to DB2, DRDA, Informix, SQL Server, Sybase, and Teradata.

• Any data store accessible through the Code Templates (which use JDBC), including, but not limited to, DB2, SQL Server, Sybase, and Teradata.

• Any data store accessible through the ODBC Data Source Administrator, including but not limited to Excel and MS Access

• Delimited and fixed-length flat files.

• ERP and CRM applications such as Oracle E-Business Suite, Peoplesoft and Siebel, from which data can be extracted using SQL.

• SAP R/3, from which data is extracted using officially supported methods based on native ABAP code.

OWB supports the following targets:

• Oracle Database release 8.1 and later.

• Third-party databases accessed through Oracle gateways or ODBC.

• Comma-delimited and XML format flat files.

• Oracle BI tools, such as Oracle Business Intelligence Suite Enterprise Edition (OBI EE).

• OWB can deploy or execute process flows and schedules to Oracle Enterprise Manager and Oracle Workflow. In general, you can deploy a schedule in any Oracle Database location, release 10g or later.