< Previous | Next >
WebSphere logo Classic Federation Server for z/OS, Version 9.1
WebSphere logo Classic Replication Server for z/OS, Version 9.1
WebSphere logo Classic Data Event Publisher for z/OS, Version 9.1
WebSphere logo Data Integration Classic Connector for z/OS, Version 9.1


Lesson 1.4: Connecting to a data server

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:

To connect to a data server:

  1. 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
    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.

  2. 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
  3. 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.
  4. In the Host field, type the IP address or host name of the remote system that the data server is running on.
  5. 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.
  6. 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.
  7. 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
The Database Explorer after you create the connection to the data server


Feedback

Update icon Last updated: 2007-07-11


< Previous | Next >