You use Classic Data Architect to map tables to data structures
on your data sources and then promote those tables to the metadata catalog
of a data server. Before you promote those tables (and any views that reference
the tables or stored procedures that you might want to use), you need to establish
a connection to a data server.
You'll complete this step now as part of configuring Classic Data
Architect.
Before you connect to a data server, ensure that you configured
the data server in Classic Data Architect.
You need the following information
to complete this lesson:
- The IP address or host name of the system on which the data server is
running.
- The port number or TCP service name that the TCP/IP connection handler
is listening on.
- The name of the query processor, which comes from field 2 of the service
information entry for the query processor. By default, the name is CACSAMP.
To connect to a data server:
- In the Database Explorer, right-click the Connections folder
and select New Connection. The Database
Explorer is directly below the Data Project Explorer and looks like this:
Figure 1. The Database Explorer
In this view, you create the connections to the different remote systems
that you might need to access.When you select New Connection,
the New Connection wizard opens.
- In the New Connection wizard, under Select
a database manager, check that V9 under Classic
Integration is selected. Also, check that Classic Integration
Server JDBC Driver is selected in the JDBC driver field.
The JDBC driver is located in the eclipse\plugins\com.ibm.datatools.db2.cac_1.0.0\driver directory
- In the Data source field, type the name
of the query processor that is running in the data server. Query
processors are also referred to as data sources because, to a client application,
the query processor acts as a data source. The client application sends SQL
queries to the query processor and the query processor queries the data on
the actual data source, such as Adabas or CA-IDMS.
- In the Host field, type the IP address or
host name of the remote system that the data server is running on.
- In the Port number field, type the port
number that the TCP/IP connection handler is listening on, or the name of
the service that is being used as an alias for the port number.
- Optional: In the Code page field,
select the EBCDIC code page that you want the JDBC driver to use to convert
the messages that it sends to the remote system.
- Click Finish.
The new connection appears in the Database Explorer. Below this view,
Classic Data Architect indicates that the connection is open.
Figure 2. The
Database Explorer after you create the connection to the data server