Getting Started with the ETL Task Tool

To create a new ETL task in object navigator:

• Click the New Object > Other > ETL Task button in the Create group on the Home ribbon tab.

• Select the Create > Other > ETL Task item in the object navigator context menu.

To open ready ETL task for edit in desktop application:

• Select the Edit item in the ETL task context menu.

• Click the Edit button on the Home ribbon tab.

• Press F4.

To open ready ETL task for view (available in desktop and web application):

• Select the Open item in the ETL task context menu.

• Double-click the ETL task.

The main window of ETL task contains the following elements:

• Main menu. Contains a list of command used to execute various operations with ETL task and its objects.

• Toolbar. Contains commands located in logic groups. Commands are used to set up parameters and to manage objects in working area.

• Connectors and transformers toolbar. It is displayed only in ETL task edit mode. The objects toolbar is used to add objects of specific type to the working area. The panel contains four tabs:

• Providers.

• Consumers.

• Transformers.

• Others.

• Working Area. A container, in which an ETL task data export/import chain is built.