Options

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

Repository Tab

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
OLEDB

Use the Repository creation wizard to create a new repository.

More information about repository database

Execution Tab

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

Interface Tab

Email Tab

The Email tab defines default Emails settings.

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)

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 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

Predefined variables

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

Notes

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