Designer Guide

10.5
- 10.4.1
- 10.4.0

Back Next

Working with Sources Overview

To extract data from a source, first define sources in the repository. You can import or create the following types of source definitions in the Source Analyzer:

Relational tables, views, and synonyms

Fixed-width and delimited flat files that do not contain binary data.

COBOL files

XML files

Web Services Description Language (WSDL)

Data models using certain data modeling tools through Metadata Exchange for Data Models (an add-on product)

You can import sources that use multibyte character sets. Source code pages must be a superset of the target code pages.

Source definitions can be single- or multi-group. A single-group source has a single group in the source definition. Relational sources use a single-group source definition. A multi-group source has multiple groups in the source definition. Non-relational sources such as XML sources use multi-group source definitions.

Because source definitions must match the source, you should import definitions instead of creating them manually.

Working with Sources

Oracle Sources

Special Character Handling in Source Definitions

Updating Source Definitions

Creating Sessions