Oracle Direct Access plug-in functionality

The Direct Access plug-in offers functionality to extract data directly from Oracle Applications tables, integrate with data from other sources, and other benefits.

This plug-in is similar to other plug-ins for Enterprise Resource Planning business management.

• Supports
  • Extracting data directly from Oracle Applications tables.
  • Integrating with data from other sources by using the visual design process of IBM® InfoSphere™ DataStage® for modeling and deploying source-to-target transformations.
• Uses Oracle Call Interface (OCI) at runtime for table access.
• Supports browsing Oracle Applications tables using tools such as generic table search, by name and description.
• Uses Oracle Applications metadata directly, requiring no additional import of metadata by using the InfoSphere DataStage and QualityStage Designer. The plug-in uses Oracle tables to create metadata at design time. The primary column data is in the FND_COLUMNS table.
• Lets you construct SQL selection criteria with simple point and click operations.
• Enables delta processing, which captures incremental changes only, on tables or views selected at design time.
• Supports National Language Support (NLS). For more information, see the InfoSphere DataStage documentation.

The Direct Access plug-in provides the following functionality:

1. The GUI client component in the InfoSphere DataStage and QualityStage Designer client logs on to the Oracle Applications database and retrieves metadata information.
2. The GUI client component reads and writes job properties (for example, the tables and columns to extract) between the GUI client component and the InfoSphere DataStage repository.
3. The runtime server component reads job properties from the InfoSphere DataStage repository.
4. The runtime server component connects to the underlying Oracle Applications database by using the user-specified connection properties and extracts data directly from this database.