Purpose and Main Features: Log

Log

Log is used to store the information on ETL tasks execution. In fact, a log is a table with predefined list of fields. The number of fields is fixed, but there is also a possibility to add new fields.

Information on the following operations is saved to log:

Recording the start of ETL task execution.

ETL task execution error.

Skip records.

Add records.

Recording the completion of ETL task execution.

To create a log:

In the object navigator:

In the web application click the Create button in the main menu and select the object type on the New Object side panel.
In the desktop application:

Select the Create > Other > Log context menu item.
Select the New Object > Other > Log item in the Create group on the Home ribbon tab.

In the opened ETL task in the desktop application:

Select the Task > Properties main menu item.
In the opened wizard go to the Task Options page.
Click the Create button.

After executing the operations the log creation wizard opens.

Web application Desktop application

Determine settings on the pages:

Basic Settings/Basic Properties. It is used to set object name, identifier and comment

Properties. Specifies the database where the log must be created as well as physical name of the table, which must correspond to the repository log.

Fields. Forms the list of additional log fields.

The created log table include the fields:

Date (STAMP). Date and time of a certain operation execution.

User (USER_ID). Username.

Operation (OP). Names of executed operations.

Success (OP_SUCC). Operation result (0 if the operation failed or 1 if the operation is successfully completed).

Object Identifier (OBJ_ID). ETL task object identifier.

Object Name (OBJ_NAME). ETL task object name.

Description (DESCR). Description of executed operation.

All user fields determined on the Fields page of the wizard.

Working with a Log

To edit the log selected in the object navigator:

In the web application:

Select the Edit item in the object's context menu.
Select the Edit in a New Tab item in the object's context menu.
Select the Edit in a New Window item in the object's context menu.
Press F4.

Then click the Settings button.

In the desktop application:

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

The log wizard opens. Determine settings on corresponding pages of the wizard.

To view data, select the corresponding object in the object navigator and execute one of the operations:

In the web application:

Select the Open item in the object's context menu.
Select the Open in a New Tab item in the object's context menu.
Select the Open in a New Window item in the object's context menu.
Double-click the object.
Press the ENTER key.

In the desktop application:

Click the Open button on the Home ribbon tab.
Click the Open > In Default Tool button on the Home ribbon tab.
Select the Open item in the object's context menu.
Double-click the object.

After executing one of the operations the corresponding data object opens. For details about principles of work with a data set see the Working with Data Set section.

To view report data in the desktop application:

Click the Open > Regular Reports button on the Home ribbon tab.
Select the Open With > Regular Reports item in the object's context menu.

To import data in the desktop application:

Click the Open > Data Import Wizard button on the Home ribbon tab.
Select the Open With > Data Import Wizard item in the object's context menu.

Linking the Log to the ETL Task

To link a log to an ETL task, execute the following operations:

Use the log creation wizard to create a new log.

Open the ETL tasks object to which the log is linked.

Select the Task > Properties item in the ETL task's main menu, after which the ETL task editing wizard will be displayed.

Select the created log on the Task Options wizard page.