Navigator User Guide

10.5.4
- 10.5.6
- 10.5.5
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

Application Groups and Applications Overview

If you use ODBC connections to extract change data, PowerExchange uses application groups and applications to maintain extraction information for change data extractions.

An application group defines the node location of the data source. The PowerExchange Navigator adds an application group when you add a registration group. You can also manually add an application group.

Applications appear under an application group. You do not add applications through the PowerExchange Navigator. Add applications dynamically when you run a CDC extraction with a new application name or run the DTLUAPPL utility. The application name is the name that you specify in the DBQUAL2 parameter of the ODBC connection or in the DTLAPP SQL override.

Informatica recommends that you specify a unique application name for each extraction process to verify that restart occurs. If you use the same application name for multiple extraction processes, errors might occur, such as the wrong data being extracted and other unexpected results.

Each application displays the history of change data extractions in descending time stamp order. For each extraction, the history includes:

Time stamp

Audit trail

Extraction status

Capture registration name and table name

Additionally, each application stores the start point for the next extraction, which you can reset in the PowerExchange Navigator or by using the DTLUAPPL utility.

The CDEP file is the control file in which PowerExchange stores application information. Application information includes the application name, the start point for the next extraction, and information about the extraction processes that have run including their history. PowerExchange ODBC uses the restart tokens associated with application names in the CDEP file to determine the starting extraction point for a session. The application group is used to filter the application information in the CDEP file for display in the PowerExchange Navigator.

If you use PowerExchange Client for PowerCenter (PWXPC) connections to extract change data as recommended, PowerExchange does not use application groups and applications. With PWXPC, PowerExchange maintains restart information for extractions in the following locations:

For relational targets, in state tables

For nonrelational targets, in the state file on the Integration Service

For more information, see the CDC guide for the operating system.

Appendix C: Application Groups and Applications

Registration Groups

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal