Database connections.

The Integration Service uses database connections to connect to the source and target databases.

Sessions.

Sessions are workflow tasks that contain information about how the Integration Service moves data through mappings. You create a session for each mapping you want to run. To run the session, place it in a workflow. Use the Workflow Designer to create sessions.

Workflows.

A workflow is a set of instructions, divided into tasks, the Integration Service uses to extract, transform, and load data.

Workflow tasks.

Workflow tasks are instructions the Integration Service executes when running a workflow. Workflow tasks perform functions supplementary to extracting, transforming, and loading data. Workflow tasks include commands, decisions, timers, and email notification.

Worklets.

Worklets are objects that represent a set of workflow tasks that allow you to reuse a set of workflow logic in several workflows. You can run worklets in workflows and nest worklets in other worklets.