Getting Started

10.5.6
- 10.5.1
- 10.5
- 10.4.0

Back Next

Creating a Reusable Session

You can create reusable or non-reusable sessions in the Workflow Manager. Create reusable sessions in the Task Developer. When you create a reusable session, you can use it in multiple workflows. Create non-reusable sessions in the Workflow Designer. When you create a non-reusable session, you can use it only in that workflow.

In the following steps, you create a reusable session that uses the mapping m_PhoneList. Then, you create a workflow that uses the reusable session.

In the Workflow Manager Navigator, double-click the tutorial folder to open it.

Click

Tools

Task Developer

to open the Task Developer.

Click

Tasks

Create

Select Session as the task type to create.

Enter s_PhoneList as the session name and click Create.

The

Mappings

dialog box appears.

Select the mapping m_PhoneList and click

The Workflow Manager creates a reusable Session task in the Task Developer workspace.

Click

Done

in the

Create Task

dialog box.

In the workspace, double-click s_PhoneList to open the session properties.

On the

Mapping

tab, select Sources in the Transformations pane on the left.

The following image shows the

Mapping

tab for the session s_PhoneList:

Open button

In the Connections settings on the right, click the

Open

button in the Value column for the SQ_EMPLOYEES - DB Connection.

The Relational Connection Browser appears.

Select TUTORIAL_SOURCE and click

Select Targets in the Transformations pane.

In the Connections settings, click the

Open

button in the Value column for the T_EMPLOYEES - DB Connection.

The Relational Connection Browser appears.

Select TUTORIAL_TARGET and click

In the Properties settings, change the Target Load Type to Normal.

On the

Properties

tab, select a session sort order associated with the Integration Service code page.

For English data, use the Binary sort order.

The following figure shows the Properties tab where you can configure the Binary sort order:

Click

to save and close the session properties.

In this step, you use most of the default settings.

Click

Repository

Save

to save the session to the repository.

You have created a reusable session. The next step is to create a workflow that runs the session.

Rename Saved Search

Table of Contents

Getting Started

Getting Started

Creating a Reusable Session

Creating a Reusable Session