To access the options dialogue, click System Menu→ File→ 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


Use the Repository creation wizard to create a new repository.

More information about repository database

The Email tab defines default Emails settings.

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
  • Database: REPOSITORY
  • User: sa

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


 Select * from Customers where  CustomerId =<CustomerId>

Is changed to

 Select * from Customers where  CustomerId =1

Predefined variables:

<username> OS user name

More Information:

  • 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

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: 15/01/2023 04:51
  • by admin