To access the options dialogue, click System Menu-> File-> Options.

Repository Tab

Repository Options

Connection Options

The Repository tab defines the repository connection. The repository database stores all the information about connections, transformations, packages, SQL scripts, reports and execution logging. This is where the results of the ETL designer’s hard work are stored.

The Repository type can be:

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

Execution Tab

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

Execution Tab

Interface Tab

Interface Tab

Email Tab

The Email tab defines default Emails settings.

Email Tab

Notifications Tab

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)
Notifications Tab

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
User: sa

Global Variables Tab

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


Select * from Customers where CustomerId =<CustomerId>

Is changed to

Select * from Customers where CustomerId =1
Global Variables

Predefined variables

<username> OS user name


  • All settings are stored in C:\ProgramData\ETL-Tools.com folder, which 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 the ETL Designer repository connection name
  • ServerConnection.ini this file holds the Execution agent, Management console and Monitors repository connection name

Options List

Detailed options list

Video Tutorials

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

Confused? Ask question on our ETL Forum
Last updated: January 15, 2023