Use the Workflow Generation Wizard to generate sessions and workflows from a mapping. The mapping can use relational or flat file sources and targets.
Launch the Workflow Generation Wizard from one of the following locations, based on what you want to generate:
Use the Workflow Generation Wizard to create one workflow and session for one mapping.
Import Mapping Template Wizard.
Use the Workflow Generation Wizard to create workflows and sessions for multiple mappings.
Before you use the Workflow Generation Wizard, verify that the mapping is valid, and that the Integration Service and connection objects have been created. Verify that the mapping uses relational or flat file sources and targets.
The Workflow Generation Wizard allows you to complete the following steps:
Specify the type of session or workflow you want to generate.
Specify the Integration Service, connection settings, and workflow and session name prefixes. The values you specify in the second step apply to all sessions and workflows you configure.
Change the workflow name, session name, and Integration Service. You can also configure connection settings. The values you specify in the third step apply to the workflow and session you configure
The last page of the wizard displays a list of workflows or sessions that were generated and the status of the workflows and sessions.
Use connection variables in a session that the Workflow Generation Wizard creates, edit the session properties in the Workflow Manager after the Workflow Generation Wizard creates the session in the repository.