4 Configuring an Adabas CDC Adapter

This chapter provides an example for creating an OracleAS adapter for Adabas. To work with an OracleAS adapter for Adabas, you must also configure either a BPEL process or a Mediator process. For information on using BPEL or Mediator, see Creating the Project in JDeveloper Examples.

Creating Outbound Interactions with the OracleAS Adapter for Adabas

To work with the OracleAS Adapter for Adabas and create outbound interactions, you must create a new Adabas database and use the data to create a CDC Solution.

Requirements

The following is required to perform the tasks described in this chapter:

  • Computer with Windows operating system

  • Mainframe computer with z/OS operating system

  • Oracle Connect v 11.1.1.2 installed on the Mainframe computer

  • Oracle Studio v 11.1.1.2 installed on the Windows computer.

Adding the Adabas Hospital Data Source

To create an Adabas data source you must do the following:

Prepare the System

In your Adabas database, you should create a database called Hospital. In this database create the following files and fields as described in Table 4-1.

Table 4-1 Adabas Tables and Columns

Files Fields

HOSPITAL

HOSPNAME

HOSP_ADDRESS

HOSP_PHONE

ADMIN

PATIENT

HOSPNAME

WARDNO

PATNAME

PATADRESS

PAT_PHONE

BEDIDENT

DATEADMT

PREV_STAY_FLAG

PREV_HOSP

PREV_DATE

PREV_REASON

SYMPTOM

HOSPNAME

WARDNO

BEDIDENT

DIAGNOSE

SYMPDATE

PREV_TREAT_FLAG

TREAT_DESC

SYMP_DOCTOR

SYMP_DOCT_PHONE

WARD

HOSPNAME

WARDNO

TOT_ROOMS

TOT_BEDS

BEDAVAIL

WARDTYPE


Set up Machine Access to Oracle Connect

You begin by configuring access to the Windows computer with your Adabas data. You configure this access with Oracle Connect. Open Oracle connect and follow the directions. Enter the following information in the Add machine dialog box:

  • Host name/IP address: Enter the name or IP address for the Mainframe computer with the Hospital database. This should be installed in the same directory as Oracle Connect.

  • Port: Enter the port number where the daemon is running. The default port is 2551.

  • Display name: Enter the display name (By default, the display name is the host name and the port number). It is not necessary to enter any information in this field.

  • User name: If the computer you are accessing needs an administrator password. If so enter the name of the computer's administrator.

  • Password: If necessary, enter the computer administrator's password.

  • Connect via NAT with fixed IP address: Select this if the machine uses the NAT (Network Address Translation) firewall protocol, with a fixed configuration, mapping each external IP to one internal IP, regardless of the port specified.

Figure 4-1 shows the Add Machine dialog box with the correct information:

Figure 4-1 Add Machine Dialog Box

Machine dialog

Create a Change Data Capture

You now create the change data capture for the files that you created. When you are finished you can create WSDL and binding (jca) files. See Create the JCA Configuration Files for more information.

These files contain the information needed to create the BPEL and Mediator projects in JDeveloper. For more information on using JDeveloper for the BPEL Process Manger and Mediator, see Creating the Project in JDeveloper Examples.

Before you begin to set up your change data capture ensure that Adabas is set up to handle a change data capture. For information on how this is done see Setting up the ATTSRVR Started Task.

The following sections describe how to create a change data capture in Oracle Studio.

Setting up a Change Data Capture

The following procedure describes how to set up your change data capture for this sample. For detailed information on setting up a change data capture for Adabas, see Setting up a Change Data Capture in Oracle Studio.

  1. Open the Solution perspective in Oracle Studio.

  2. In the left pane, click Create new project.

  3. Enter the following:

    • Project name: Hospital

    • Type: Adabas (Mainframe)

    Figure 4-2 shows the correct data in the Create new project screen.

    Figure 4-2 Create New Project

    Create new project
  4. Click Design and then click Next and Finish to use the default values in the screens. If you want to set up your staging area on a UNIX computer, then you must change that setting in the second screen. For more information on, see Create a CDC Project.

  5. Click Implement to go to the Implementation guide.

  6. For Server Configuration, enter the following information:

    • Machine: Enter the information for the Windows computer with Oracle Connect installed.

    • Data Source: Enter the following:

      • Database number: Enter the database number for the Adabas Hospital database that you created for this project.

      • PREDICT file number: Enter the Predict file number.

      • PREDICT database number: Enter -1 if your predict file resides in the database you created for this project.

      For more information, see Create a CDC Project.

    • CDC Service: You can use the default settings, which records all changes to the journal and does not include the capture of before-image records.

    • Logger: Enter the tracking file name and the Adabas version you are using.

    • Logging Level: Use the default settings.

    For more information, see Set up the CDC Service.

  7. For Stream Service Configuration, enter the following information:

    • Machine: Enter the information for the computer you are using as your staging area. This must be a Windows or UNIX machine.

    • Stream Service: Enter the following:

      • In the Staging Area screen, enter a location for the change files on the computer you specified and the Staging Area computer.

      • In the Changed Data Capture Table Selection, select all of the tables.

      • In the remaining screens, click Next to use the default values.

    • Access Service Manager: Click Next in all of the screens to use the default values.

      For more information, see Set up the CDC Server.

You must now Deploy the Solution.

Deploy the Solution

To deploy the solution, click Activate Workspaces. Click OK in any screen that opens. If you get a message about a naming collision, you must resolve this first.

For information on deploying a change data capture, see Deploying a Change Data Capture.

Create the JCA Configuration Files

You must create both a WSDL and JCA file to set up your connection with JDeveloper. You create the files using Oracle Studio before setting up the BPEL process or Mediator connections.

For information on how to create JCA configuration files, see Creating JCA Configuration Files. To create the files for the Hospital_CDCQueue adapter, do the following:

  1. From the Configuration pane in Oracle Studio, expand the binding for the CDC staging area that you created. The name of the binding is the Project name for the CDC solution that you created in Oracle Studio with the suffix _SA.

  2. Right-click the Hospital_CDCQueue adapter and select Generate JCA Configuration Files.

  3. Save the files to a place you can find when you create the BPEL process or Mediator connection.