Options

The Advanced ETL Processor allows you to tweak key settings. Using this provision you can change the repository type, control the execution of packages and where the results will be logged, set interface actions such as the prevention of accidental deletion and set email options to report the outcome of the automation to individuals or groups of people.

To change Advanced ETL Processor Settings, click System Menu→ File→ Options.

The Dialog box will appear.

The Repository tab defines the repository connection. Once the login parameters have been verified via the “Test Connection” dialogue this information is saved so it is not necessary to provide this information again.

The Repository type can be:

  • MS Access
  • MS SQL Server
  • Oracle
  • Interbase (Firebird)
  • MySql
  • PostgreSQL
  • ODBC Connection
  • OLEDB

Note:

Use Repository creation wizard to create a new repository.

Execution tab defines settings related to the logging and Packages execution.

The Interface tab defines key settings. These operate globally during the activities of the Advanced ETL Processor. For instance, in order to save time when creating packages to automate tasks, the editor can be set so that it automatically opens. In order to ensure that any changes made to scripts and packages upon exit, you can safeguard this by checking the “Save all scripts and packages on exit” box. Accidental deletion is prevented by requesting that the user is asked before deleting any objects. Another aspect of the interface actions is the updating of the log. This can be set so that once a package has completed its actions the log is updated with all the actions which took place during execution. Finally, if you wish to automatically refresh table list when creating/opening transformation you simply check the “Update Tables List” to ensure that you this is accurate, and up to date.

The Email tab defines default Emails settings. As the Advanced ETL Processor is designed to work automatically and in batch mode, it will be necessary to specify where emails will be sent from. Emails messages are used to convey when processes and activities have been completed. It is also possible to specify the default recipient. The default recipient can be set to a group email address, or it can be left blank.

The Notifications tab defines Email connection settings for Agent failures and Package notifications.

If enabled

  • The agent will send notifications on repository connection failures
  • Notifications about execution failures will be sent as well (Packages, Transformations, Imports and SQL scripts)

Email Message Example:

  • Error Message: Reconnected!
  • Computer Name: COMPUTER
  • User Name: dbsl
  • Os Version: Windows 8.1 (Version 6.3, Build 9600, 64-bit Edition)
  • Number Of Threads: 11
  • Repository: MS Sql Server Repository
  • Type: MS Sql Server
  • Server: COMPUTER\SQLEXPRESS2008
  • Database: REPOSITORY
  • User: sa

Global Variables

Global Variables are used to replace Variable with Value, for example before SQL is executed <CustomerId> is be replaced with 1

EG

 Select * from Customers where  CustomerId =<CustomerId>

Is changed to

 Select * from Customers where  CustomerId =1

Predefined variables:

<username> OS user name
<computername> 
<datetime>  

More Information:

  • All settings are stored in C:\ProgramData\ETL-Tools.com folder, that makes moving software to a different computer much easier.
  • Options.ini holds designer user interface settings plus global variables values
  • Note: List of variables is shared between all applications
  • Connections.ini holds the list of all available repository connections
  • Note: This list is shared between all applications
  • DesktopConnection.ini this file holds ETL Designer repository connection name
  • ServerConnection.ini this file holds Execution agent, Management console and Monitors repository connection name

Video Tutorials

For more technologies supported by our ETL Software see Advanced ETL Processor Versions and Visual Importer ETL Versions

Confused? Ask question on our ETL Forum

  • aetle/options.txt
  • Last modified: 17/09/2018 10:34
  • by admin