JavaScript is required to for searching.
Skip Navigation Links
Exit Print View
Migrating from eTL to Oracle Java CAPS Data Integrator     Java CAPS Documentation
search filter icon
search icon

Document Information

Migrating From eTL to Oracle Java CAPS Data Integrator

About Migration to Oracle Java CAPS Data Integrator

About eTL Project Migration

About Using Migrated eTL Components in Java CAPS 6

About Runtime eTL Components

Uploading the eTLMigrationTool SAR File to a Repository

To Upload the eTLMigrationTool SAR File

Importing eTL Projects Into Java CAPS 6

To Import an eTL Project

Building Data Integrator Projects

To Build a Data Integrator Project

Creating, Configuring, and Building BPEL 2.0 Modules for Data Integrator

To Use the Data Integrator Web Service in a BPEL 2.0 Module

Configuring Repository-based Projects to Use Data Integrator

To Use the Data Integrator Web Service in a BPEL 1.0 Module

Using Data Integrator Components as JBI Modules in Composite Applications

To Use the Data Integrator Web Service in a BPEL 2.0 Module

Configuring Repository-based Projects to Use Data Integrator

This topic provides instructions on customizing a CAPS repository-based BPEL 1.0 project so as to use an eTL collaboration from a Data Integrator project. Typically, such projects include eTL components that have been migrated to Java CAPS 6 Data Integrator projects.


Note - JAR files created from imported eTL projects are saved in the location JavaCAPS6\.netbeans\caps\eTL\Imported Projects\projname.


To Use the Data Integrator Web Service in a BPEL 1.0 Module

In this procedure, you will import the Data Integrator WSDL file into the CAPS repository-based project. Then, in the CAPS project and corresponding environment, you will: Find instances of the 5.1.x eTL collaboration and substitute the “execute” node from the imported WSDL; create appropriate connections and mappings; extend the project's connectivity map and environment with a JBI bridge, and create a new deployment profile.

Before You Begin

If necessary, start the CAPS repository, start the NetBeans IDE, and use Tools -> CAPS Repository -> Connect to connect to the repository.


Tip - If the installation defaults were retained, the Login ID is admin and the Password is adminadmin. If a repository is connected, the Projects window contains a top-level node labeled CAPS Library Components and the Services window contains a top-level node labeled CAPS Environments.


If you have not already built the Data Integrator project, do so now. If necessary, see Building Data Integrator Projects.

  1. In the NetBeans IDE, project tree, right-click the CAPS repository-based project you want to customize: Select Import -> Web Service Definition.
  2. In the Import WSDLs wizard:
    1. In the Location Type step, accept the default of File System by clicking Next.
    2. In the Select WSDLs step, navigate to location JavaCAPS6\.netbeans\caps\eTL\Imported Projects\projname\Collaborations, select its WSDL files, and then click Next.
    3. In the Import Preview step, retain the selected checkbox for ALL WSDLs and then click Next.
    4. In the Projects Window Preview step, click Next.
    5. In the Summary step, check for any errors or warnings and then click Finish.

    In the CAPS project folder, the project tree displays a new web service node corresponding to the eInsight (BPEL) engine.

  3. In the project tree, under the CAPS project, double-click the business process node.

    The Business Process Editor (also called the BPEL 1.0 Editor) displays the uncustomized business process.

  4. In the BPEL 1.0 Editor:
    1. Delete the placeholder for the old eTL collaboration
    2. In the project tree, open the CAPS project's web service for eInsight engine -> Port Types -> eTL..._etlPortType and drag its “execute” activity onto the canvas where the old eTL collaboration used to be.
    3. Reconnect to other components in the business process as they were previously.
    4. As needed, add business rules and restore mappings as they were previously.
  5. Repeat the previous two steps as needed for other business process nodes.

    After you have restored all business process connections and mappings, you can close all instances of the BPEL 1.0 Editor.

  6. In the project tree, under the CAPS project, double-click the connectivity map.

    The Connectivity Map Editor displays the unbridged connectivity map.

  7. In the Connectivity Map Editor:
    1. Double-click the business process container to open it.
    2. Delete the obsolete container for the eTL collaboration.
    3. In the tool palette, pull down the choices for the External Applications tool and select JBIBRIDGE External Application.
    4. From the now-augmented tool palette, drag a JBIBRIDGE onto the connectivity map.
    5. Carefully connect the JBI Bridge component to the invoked service corresponding to eTL.
  8. Repeat the previous two steps as needed for other connectivity maps.

    image:Connectivity Map Editor: After JBI Bridge components have been substituted for eTL collaborations and reconnected

    After you have substituted JBI Bridge components for eTL collaborations in all connectivity maps that require it, you can close all instances of the Connectivity Map Editor.

  9. In the NetBeans IDE, Services window, open the CAPS Environments folder.
  10. For each CAPS environment that requires a JBI Bridge, right-click the environment and select menu item New -> JBI Bridge External System.
  11. As needed, configure other components in each environment. For example: Adapters for File or databases, parameters for application and message servers, and so forth.
  12. In the NetBeans IDE, Projects window, right-click the CAPS project and select menu item New -> Deployment Profile.
  13. Select the appropriate environment and connectivity maps for this deployment profile, and then click OK.
  14. In the Deployment Profile Editor, click Automap.

    image:Deployment Profile Editor: After all components in the connectivity maps have been mapped to external systems

    If any components do not map, double-check the environment to be sure that all necessary external systems have been defined and configured properly.

Next Steps

After the CAPS deployment profile is complete, you can use the corresponding EAR file in a composite application.