Integrate

Post Data Using an SAP Data Services Job

A template defines how data is posted to a target system, including which target system screens and fields are processed. Every template has a template type. The SAP Data Services Job template type uses a Data Services Job (consisting of a Data Services Repository and a job name) when posting request data to a target system.

The Data Services Job associated with the template type is stored in a Data Services Repository, a set of tables that stores user-created and predefined system objects, source and target metadata, and transformation rules. Repositories are configured in SAP Data Services, and then registered in Common in the Stewardship Tier.

The connection ID configured at the template level on the Template page’s Horizontal View determines the Data Services Repository the template uses. Refer to Register a Data Source in Common for more information.

After a user has added the job name on the Template page’s Vertical View, this job is created and stored in the repository.

If Global Variables, an optional feature, are to be used as inputs for a Data Services Job used to post data to SAP, a view must be created in SQL Server. The view serves as the basis of Process Template Loop Field Mappings, which connect a column in a view with a field on a template.

A user can create this view using the Auto Generate Database Objects feature. Refer to Generate Database Objects Automatically for more information. Views can also be created manually. Refer to Create a View in SQL Server for more information.

NOTE: When a process based on a SAP Data Services Job template type is posted, Integrate applies the Where clause from the process post (entered on the Process Post page’s Vertical View), and runs the tx*Int view mapped at the Process – Template – Loop level. For each record found, Integrate calls the Data Services Job with the Global Variables values (if applicable) from the tx*Int view.

When posting request data using this template type, at a high level, a Template Administrator: