WebSphere Adapter for JD Edwards EnterpriseOne

Selecting business objects and services

To specify which XML List you want to use for outbound processing, you provide information in the enterprise service discovery wizard.

Before you begin

Make sure you have set the connection properties for enterprise service discovery.

About this task

Specify search criteria that the enterprise service discovery wizard uses to discover XML Lists in the JD Edwards EnterpriseOne environment. Before you can run the query for XML Lists on the server, however, you must specify the table name so that enterprise service discovery can retrieve metadata about that table. After executing the query, the enterprise service discovery wizard returns a list of XML Lists.

To specify the search criteria and select an XML Lists, use the following procedure.

How to perform this task

  1. Specify the table to use in the XML List query.
    1. In the Find and Discover Enterprise Services window of the enterprise services discovery wizard, click Edit Query.
    2. In the Query Filter Properties window, click Add next to the Tables list.
    3. In the Add window that opens, type the name of the table in the JD Edwards EnterpriseOne application that contains the data, then click OK. The table name you typed is displayed in the Tables list.
    4. Click OK.
  2. Execute the XML List query to find and discover the table in the JD Edwards EnterpriseOne application that matches the table you specified.
    1. In the Find and Discover Enterprise Services window, click Execute Query.
    2. Expand the XML Lists node, navigate to the table that matches the table you created, then click Add to import list.
  3. Add search criteria to the query before importing the data from the JD Edwards EnterpriseOne environment. This allows you to specify query parameters such as table type, sorting conditions, and other query conditions.
    Note: When you make selections in the Configure Parameters for <table_name> window, the fields change causing the window to expand or collapse.
    1. In the Configuration Parameters for <table_name> window, you can either keep the default name in the Business Object Name field or rename it.
    2. In the Table Type field, select the type of table from the list. The following table types are available:
      • OWTABLE
      • OWVIEW
      • FOREIGN_TABLE
      • TABLE_CONVERSION
    3. In the Queries section that expands, you can optionally add a sorting order or add conditions to the query.
      Note: If the Queries section does not automatically expand, expand it by clicking Add Query.
      • If you want to add sorting to the query, click Add Sorting, then select an attribute and a sorting order (ascending or descending).
      • If you want to add a condition, select Add Condition, then select conditions from the following fields.
        Note: If no conditions are specified, all records are retrieved.
        • Attribute: Select the attribute for the query.
        • Clause: Select the clause for the query condition. The default is Where.
        • Operator: Select the operator when comparing the attribute to the column value.
        • Use Attribute Value: Select an attribute to compare to.
        • Default: Specify the default value for the query condition.
    4. Click OK. The XML List is displayed in the "Objects to be imported" list.
  4. Click Next.

Result

The XML List you selected is imported from the JD Edwards EnterpriseOne environment to the enterprise service discovery wizard. The Configure Objects window opens.

What to do next

Specify a name for the business object and the directory in which it should be stored.

Terms of use |

Last updated: Mon 30 Oct 2006 03:42:09

(c) Copyright IBM Corporation 2005, 2006.
This information center is powered by Eclipse technology (http://www.eclipse.org)