Integrate

Post Data to Multiple Target Systems with One Process Template

A Process Designer can reuse a process template by adding connections to load programs for multiple target systems to a single process template. Data can then be posted to these target systems sequentially.

At a high level, the user:

  1. Sets available connections at the process template level.
  2. Edits the connections to target systems at the process post level (if needed).

After a user adds a process, the system creates one process template for that process automatically. The process template connection was added on the Template page when the template was created. This process template may need further configuration depending on the template type.

A user adds an additional process template for each target system connection. These process templates must be configured identically to the first, except for the connection to the target system. When the process is posted, the data is reused. The identical data is sent to each target system.

For example, a user creates a BDC Script template with a connection to SAP Application Server 1 and adds it to a process. The system creates a process template automatically with a connection to SAP Application Server 1. The user further configures this process template by setting the primary key column name and adding fixed values and mapping values to the process template loops.

The user then adds a second process template to the process, and configures it identically to the first process template. The user sets the connection to this process template to SAP Application Server 2. After activating the process, the user posts the data, which updates each of the target systems (SAP Application 1 and SAP Application 2) with the same data.

Detailed information about the posting process is available in the sections corresponding to the template type.

NOTE: Connections can be added to a process template based on any template type. However, the types of connections allowed are restricted based on the template type. For example, a BODS Execution template only allows a connection to a Data Services Repository. BDC Script and GUI Script template connections are restricted to SAP Application Server data source types. Refer to the Data Source Registry page’s Vertical View for more information about these connections.

NOTE: There is no limit to the number of process templates that can be created with different target system connections.

NOTE: When a process is copied, the allowed connections are also copied.

Begin by setting available connections at the process template level.

Set Available Connections at the Process Template Level

A Process Designer can reuse a process template by adding connections to load programs for multiple target systems to a single process template. Data can then be posted to these target systems sequentially.

Refer to Post Data to Multiple Target Systems with One Process Template for general information.

Before performing this task, add a template and add a process.

The steps to add a template and process are different for each template type. Refer to the sections specific to the template type for more information:

NOTE: The process must be inactive to add a connection.

To set available connections at the process template level in Integrate:

  1. Click Categories in the Navigation pane.
  2. Click the Processes icon for a category.
  3. Click the Templates icon for a process.
  4. Click the Allowed Connections icon for the automatically created process template.

  5. Note the connection in the CONNECTION ID field.

    NOTE: One record, the connection that was added to the template on the Template page, displays as the default connection. Additional connections can be added to this process template, however, the default connection is used when posting. The connection can be edited at the process post level.

  6. Navigate back to the Process Templates page.

  7. Click Add.

    View the field descriptions for the Process Templates page.

  8. Enter a number in the PRIORITY field.
  9. Select the same template as the one in the first process template from the TEMPLATE ID list box.
  10. Click Save.
  11. Click the Allowed Connections icon for the second process template.
  12. Select the connection to the second target system from the CONNECTION ID list box.
  13. Click Save.

  14. Click the Set Default icon in the Page toolbar.

    NOTE: Additional connections can be added, but only one default connection is allowed.

  15. Navigate back to the Process Templates page.
  16. Click the ACTIVATE/DEACTIVATE icon for the process on the Process page.

Continue with editing connections to target systems at the process post level (if needed).

 

Edit Connections to Target Systems at the Process Post Level

A Process Designer can reuse a process template by adding connections to load programs for multiple target systems to a single process template. Data can then be posted to these target systems sequentially.

Before performing this task, Set Available Connections at the Process Template Level.

Refer to Post Data to Multiple Target Systems with One Process Template for general information.

After the available connections are set for a process template, the process post uses the default connection. If a connection other than the default connection must be used, a user can update the connection at the process post level.

To edit target system connections at the process post level in Integrate:

  1. Click Categories in the Navigation pane.
  2. Click the Processes icon for a category.

  3. Click the Postings icon for the process.

    NOTE: This icon is disabled if the process is not active.

  4. Click the Connections icon for the process post to view the target system connections to which the data will be posted.

  5. Click Edit.

    View the field descriptions for the Process Post Connections page

  6. Select the connection from the CONNECTION ID list box.

    NOTE: The connections available were added at the process template level.

  7. Navigate back to the Process Post page.
  8. Click the Post icon.

Data is posted to each target system for which there is a connection.

Refer to the posting topics for each template type for more information.