x

The iWay Informix CDC Agent is a key component of the iWay CDC Solution for Informix, which enables integration between IBM Informix Dynamic Server (IDS) and other iWay accessible enterprise systems. The agent accomplishes this task by exploiting the IDS 11.5 CDC API, a significantly improved technology for Change Data Capture (CDC) over previous methods. The second component of this solution is the iWay Log Event Listener that runs on the target Oracle database server.

The combination of iWay Integration Technology and the IDS 11.5 CDC API provides:

• Real-time CDC capture and staging of CDC records in a standard form.
• Remote retrieval of IDS CDC records via shared file system.
• Natural queuing while network connections are unavailable.

This architecture exploits the IDS logging facilities, so that overall impact upon existing IDS systems is minimal. Security is ensured by limiting CDC data capture to only preselected schemas, tables and columns with an existing DBMS.

Top of page

x

The iWay CDC Solution for Microsoft SQL Server consists of the iWay Log Event Adapter for Microsoft SQL Server, which is used to integrate a Microsoft SQL 2000/2005/2008 database with an Oracle and SQL database with near real-time data replication. The iWay Log Event Adapter for Microsoft SQL Server consists of several components. The key component is the SQL Server wrapper (C# .NET client), which interacts with the server-side components.

Top of page

x

The iWay CDC Solution for Oracle consists of the iWay Log Event Adapter for Oracle. This adapter is designed to replicate data changes from Oracle 10g/11g to Oracle 10g/11g or SQL 2000, 2005, or 2008. The iWay Log Event Adapter for Oracle uses a listener to capture the changed data from the Oracle redo logs using Oracle LogMiner.

The following types of supported operations can be captured from the source Oracle 10g/11g database table:

• INSERT
• DELETE
• UPDATE
• DDL

  Note: DDL can be captured only and not replicated.

Top of page

x

The iWay Relational Database High Water Mark listener (RDBHWM) provides the ability to read records from an RDBMS if a column or set of columns is defined with increasing values, such as a timestamp of last change.

The iWay RDBHWM operates in real-time to acquire newly inserted or updated rows from a relational database. In order to identify the desired rows, a column (or concatenation of columns) must exist, which contains an increasing high water mark value.

The listener saves the highest HWM value read with each SELECT, and constructs the subsequent query using the saved value. Unlike the iWay RDBMS listener, no deletes or updates are necessary to prevent the rereading of processed rows. Because the iWay RDBHWM listener can access the database as read-only, the performance of the iWay RDBHWM listener is faster than the iWay RDBMS listener.

Support for UNION

The iWay RDBHWM listener can also address more sophisticated SQL in which the HWM predicate appears multiple times in the SELECT statement. This situation may arise in situations in which the SQL addresses multiple databases in JOIN or UNION statements. The net effect is to allow support for more complex SQL and as a consequence, simplify the resulting application.

Top of page

x

The iWay LDAP High Water Mark listener provides the ability to read new or modified entries from an LDAP server, provided there is an attribute which steadily increases over time. Attributes such as an employee number or a timestamp may serve this purpose.

The iWay LDAP High Water Mark (HWM) listener follows the HWM design pattern by acquiring new or changed records (LDAP entries) from a data store (the LDAP server) that meet a specific, evolving criteria. The data that is returned is determined by the scope and the specified filter. To avoid retrieving duplicate entries, the iWay LDAP HWM listener keeps track of the highest value of the filter attribute which has been read. Usually the filter value is the creation or modification time of the entry, but any unique and steadily increasing value can be used. Each entry satisfying the filter is returned as an iWay XML document for further processing in an iWay Service Manager channel.

The iWay LDAP HWM listener is triggered (begins processing messages) when an entry is inserted or modified in the LDAP directory that is based on an increasing value of an attribute. The iWay LDAP HWM listener works similar to the iWay Relational Database High Water Mark listener.

A diagnostic tool (testldap), is provided in the extension to manually access and explore the LDAP directory from the iSM command console.

Top of page

x

The Schedule provider allows you to schedule defined iSM processes and tasks for execution (separate from the channel architecture) at specific times of the day, week, or month.

Top of page

x

The Calendar provider allows you to define 18 months (starting with the current month) of Holiday/Skip dates, which when used with the Schedule provider, allows you to fine tune your scheduler execution.

Once configured, the Calendar provider can be:

1. Exported to a centralized file system.
2. Imported from a centralized file system and used within this iWay Service Manager (iSM) instance.
3. Imported from a centralized iSM and used within this iSM instance.
4. Accessed from a centralized iSM.

This allows the Calendar provider to be shared in real time by any iSM instance to which it has access.

Top of page

x

See the following manual at http://ecl.informationbuilders.com/iway/index.jsp:

• iWay Service Manager Extensions User's Guide