Generix
telephone +44 (0) 1924 500 151
products
evaluation
faq
support
contact
news
solutions
home
CONNX for DB2

The CONNX for DB2 Module provides secure, real-time, read/write access to DB2 databases running on any platform using 64-bit and 32-bit ODBC OLE DB JDBC and .NET. In conjunction with other CONNX modules, you can perform seamless joins between DB2 and CONNX supported databases.

With CONNX for DB2 a single metadata model can be created that spans all enterprise data sources and applications requiring data access. The result is an enterprise-wide view of data that provides a reusable standards-based framework for information access.

The CONNX for DB2 distributed SQL engine reduces the workload placed on the server by performing CPU-intensive operations on the client, while allowing the database engine to perform tasks for which it is best suited. This distributed SQL engine facilitates truly scaleable application development because of the additional processing power gained by the use of the client in addition to the database server.

CONNX for DB2 supports the creation of views, which facilitates hiding table relationships from the end user. CONNX views facilitates the creation of heterogeneous joins between multiple disparate databases.

CONNX directly imports your DB2 metadata from the system catalog. In addition, CONNX for DB2 includes support for stored procedures, remote commands, passthrough SQL execution and static SQL. CONNX for DB2 performs seamless joins between different DB2 databases, using ODBC, OLE DB, .NET or JDBC.

All members of the CONNX family have the following features:

Metadata information Compatible with ANY ODBC, OLE DB, .NET and JDBC compliant applications
Heterogeneous Joins Wizard Assistance & CONNX InfoNaut Query Tool
Intensive Security Extensive Data Type Conversions
Views Mass Record Definition Imports
Full SQL Support Multithreaded Asynchronous Execution


CONNX SUPPORTS
RMS, Oracle Rdb, VSAM, IMS, C-ISAM, D-ISAM, Micro Focus, DB2, Oracle, Oracle DBMS, Dataflex, POWERflex, SQL server and any OLEDB or ODBC data source.

CONNX is used by more than 3000 organisations world-wide to enable web/application development, data warehousing, business intelligence, data synchronization, enhanced reporting and data migration.


Click on the CD to request an evaluation and realise how your organisation can benefit from using CONNX
overview
architecture
details
case studies
info request
e-Vantage
KEA!
nu/TPU
TeVISTA
C-ISAM
D-ISAM
DataFlex
DataSync
DB2
Desktop Adapter
OLEDB Adapter
infonaut
informix
microfocus
Oracle
DBMS
Rdb
powerflex
RMS
SQL
Sybase
VSAM