Getting Started with the ETL Task Tool in the Desktop Application

To work with the tool in Foresight Analytics Platform 10, use the new interface. ETL tasks created in the web application may be displayed incorrectly in the desktop application because there is no backward compatibility of visual objects.

To get started with the tool, create a new or open a ready task. A new ETL task can be created and built only in the desktop application.

To create a new ETL task in the 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 a ready ETL task for edit in the desktop application:

Select the Edit item in the ETL task's context menu.
Click the Edit button on the Home ribbon tab.
Press F4.

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

Select the Open item in the ETL task's context menu.
Double-click the ETL task.

The main window of ETL task contains the following elements:

Main menu. It contains a list of commands that are used to execute various operations with ETL task and its objects.
Toolbar. It contains commands combined 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:

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