Scenario 4: Oracle and Java

CONNX Data Integration Suite 14.7.0 | Enterprise Planning Guide | CONNX Scenarios | Scenario 4: Oracle and Java

This scenario shows a JAVA standalone application on Windows using the Oracle JDBC Client connecting to Oracle on Solaris and accessing VSAM under VSE (CICS) via Oracle Heterogeneous Services.

In this scenario A Java desktop app is using the Oracle JDBC client to establish a remote connection to Oracle. Oracle uses Oracle Heterogeneous Services and UNIXODBC to establish a direct connection to the CONNX ODBC Client. The CONNX Client has a direct connection to the CDD and remote connections to the CONNX Server and the CONNX License Server.

This Oracle Heterogeneous Services example in this scenario is analogous to the SQL Server linked servers example outlined in a previous scenario.

The Java desktop application uses the Oracle JDBC driver to connect to an Oracle database and access both Oracle and VSAM data.

In this scenario, a legacy data source is accessed as if it were just another relational table. The user can create stored procedures and other routines as if the disparate data sets all belonged to the same database. CONNX provides the seamless connectivity and access to the legacy data source.

Store the CDD where the CONNX Core Client technology can access it; in our scenario, the CONNX client and CDD both reside on the Solaris machine.