IBM BPM, V8.0.1, All platforms > Authoring services in Integration Designer > Services and service-related functions > Access external services with adapters > Configure and using adapters > IBM WebSphere Adapters > JD Edwards EnterpriseOne > Configure the module for deployment > Configure the module for outbound processing > Generate XML Lists

Selecting business objects and services

To specify which data you want to process for the XML List, you provide information in the external service wizard.

Make sure you have set the connection properties for the external service wizard. Also, make sure you have gathered the table information, including table names and table types, for the XML Lists you want to create.

Tip: Use the JD Edwards EnterpriseOne Universal Table Browser (UTB) to gather the table information for the XML Lists you want to create. For information about using the JD Edwards EnterpriseOne UTB, refer to the JD Edwards EnterpriseOne Tools 8.96 System Administration Guide.

Specify search criteria that the external service wizard uses to discover database table information on the JD Edwards EnterpriseOne server. The external service wizard returns a list of objects that meet the search criteria.

To specify the search criteria for creating an XML List, use the following procedure.


Procedure

  1. In the Specify Composite Properties window, edit the query to prepare it to find the table information that is required for creating the XML List.

    1. Click Edit Query.

    2. In the Query Properties window, select XML Lists.

      You can optionally clear the check box for Business Functions so the query finds only XML Lists. If you leave Business Functions selected, the query returns both XML Lists and business functions.

    3. To add the table name, click Add.

    4. In the Add window, enter the name of the database table you want to add to the query.

      For example, enter F0116 for the database table. If you do not know the name of the table you need, you can use the JD Edwards EnterpriseOne Universal Table Browser (UTB) to find it on the JD Edwards EnterpriseOne server.

    5. Click OK in the Add window. The table name you entered is displayed in the Tables list.

    6. Click OK in the Query Properties window.

    The query is now ready to discover the JD Edwards EnterpriseOne database table you specified in order to create the XML List.

    Figure 1. Find Objects in the Enterprise System window, showing the Query field ready to run an XML List query

  2. Run the XML List query to find and discover the table in the JD Edwards EnterpriseOne server that matches the table you specified.

    1. Click Run Query. The external service wizard queries the JD Edwards EnterpriseOne server. The results of the query appear in the Discovered objects list.

    2. In the Discovered objects list, expand the XML Lists.
    3. Navigate to the table that matches the table you created.

    4. Click the arrow button to add the table to the Selected objects list.

      Figure 2. Click arrow to add the discovered table to Selected objects list

  3. In the Specify Composite Properties window, add search criteria to the XML List query before importing the data from the JD Edwards EnterpriseOne server. This allows you to specify query parameters such as table type and sorting conditions.

    1. In the Business Object Name field, you can either keep the default business object name or rename it to suit your needs. The default name is the name of the table.

      The business object name has no semantic value, so you can give it a meaningful name, and the name you assign it will not impact how the business object functions.

    2. In the Table type field, select the type of table from the list.

      For example, select OWTABLE table type for the F0116 table.

      Figure 3. Specify Configuration Properties window, showing OWTABLE selected in the Table type field

      The following table types are available.

      Table types for XML Lists
      Table type Description When to use
      OWTABLE A JD Edwards EnterpriseOne database table Use this table type if the table you want is located in the JD Edwards EnterpriseOne database.
      OWVIEW A business view used to define the relationship between two or more tables and joins the data into a single view Use this business view as input to the TABLE_CONVERSION table type.
      FOREIGN_TABLE A non-JD Edwards EnterpriseOne database table that resides in a database supported by JD Edwards EnterpriseOne, such as Oracle, Access, iSeries , or SQL Server Use this table type if the table you want is located in a non-JD Edwards EnterpriseOne database.
      TABLE_CONVERSION A table type that uses batch processes which allow you to rapidly manipulate data in tables. You can set up table conversions as templates, running them multiples times, then revising them using different versions to suit the needs of your environment. Use this table type if you plan to manipulate batches of data in one of the following ways:

      • Data Conversion: allows you to transfer data from an input table or business view into output tables; also allows you to update records in a table or business view

      • Data Copy: allows you to copy tables from one data source or environment to another data source or environment when the tables are identical

      • Data Copy with Table Input: allows you to copy tables based on information from an input table.
      • Batch Delete: allows you to delete records from a table or business view

    3. To add a sorting condition to the query, click Add Sorting, click Select to select the attribute you want sorted, then select ASCENDING or DESCENDING from the Sorting list.

      If you want to remove a sorting condition, click Remove Sorting Condition.

    4. To add other conditions to the query, click Add Condition, then select one of the following conditions.

      • Attribute: Select the attribute for which you want to add a condition.
      • 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.

      If no conditions are specified, all records are retrieved.

      If you want to add multiple conditions to the query, click Add Condition again. If you want to remove any unwanted conditions, click Remove condition.

    5. Click OK. The table name is displayed in the Selected objects list.

  4. Click Next.


Results

You have selected the table you want to work with and configured it for the XML List you want to create.


What to do next

From the Specify Composite Properties window, you can optionally specify a namespace and directory to which the generated XML List will be stored.

Generate XML Lists using external service discovery


Next topic: Configure the selected objects