iWay Software's Data Adapter for DB2 – XML, JDBC, and ODBC-Based Enterprise Integration
Accelerating DB2 Database Integration
iWay Software's intelligent DB2 adapter provides highly efficient access to DB2 data and systems. The adapter is engineered in the same way as other iWay data adapters, so developers may use ANSI-standard SQL statements to access DB2 data from any iWay tool. Third-party products can also access the adapter via iWay connectors, including ODBC, OLE DB, JDBC, XML, iWay Business Services (Web services), and others. In addition, data may be integrated with more than 300 other information sources, including other relational and nonrelational databases, transaction systems, custom or packaged applications, message-oriented middleware, XML documents, EDI networks, and more. Requests that specify only DB2 data sources may also be processed using native SQL syntax.
How iWay Intelligent Data Adapters Work Together
Each adapter consists of a communications interface, an SQL translator that manages adapter operations in either SQL or iWay's universal Data Manipulation Language (DML), and a database interface that translates ANSI SQL into native SQL syntax.
Highly Optimized for DB2
The iWay Intelligent Adapter receives SQL requests and determines the most efficient method for satisfying them. Based upon their content, they are either passed directly to the RDBMS engine or translated to take advantage of iWay features such as ANSI-standard syntax for complex joins and additional security features such as field and field-value level restrictions. If required, the adapter will generate the appropriate SQL and DML statements to perform cross-database joins with other data sources.
Special features and settings for iWay's DB2 Database Adapter include:
- Read/write capability
- Automated metadata creation tools to embed transformation logic, views, joins, and virtual columns
- Dynamic assignment of tablespaces and index spaces
- Advanced interface tracing, including native SQL generation, optimization information, and return codes
- Support for Double Byte Character Sets (DBCS)
- Dynamic control of thread management
- Dynamic assignment of isolation levels at the statement level
- Direct SQL passthru facility to enable DBMS-specific SQL to be submitted without translation or syntax checking
- Interface settings to designate databases
- XA protocol support (two-phase commit) via iWay Transaction Coordinator (iTC)
- Access to multiple servers in one SQL request
Non-CLI Implementations
- DRDA and three-part table names to facilitate the access of remote subsystems
- Dynamic assignment of application plans
CLI Implementations
- XA protocol support (two-phase commit) via iWay Transaction Coordinator (iTC)
- Stored procedure support
- Access to databases on multiple servers in one SQL request
- Cancellation of queries during RDBMS engine processing
Special iWay Performance Features
The iWay adapter directly provides query control via the RECORDLIMIT feature to reduce communication traffic, CPU usage, and I/O activity. iWay's Resource Analyzer and Resource Governor products may also be used to analyze and control resources on a global basis independently of the adapter being used.
Some of our other Intelligent Adapters include:
Find Out More
For More Information
No other company provides the kind of sophisticated data integration and SOA-based integration technology that iWay Software does. To find out more, call toll-free (866) 297-4929 or e-mail us at info@iwaysoftware.com.
