Options

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

Note:

Use the Repository creation wizard to create a new repository.

More information about repository database

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

• Log directory
• Create rejected records file
• Write Log
• Write Variables
• Do not Execute any Actions
• Execute Actions in separate thread
• Execute One Action at the time

• Save all scripts and packages on exit
• Ask Before Delete
• Arrange objects on save
• Check Version
• Full tree expand
• Open tabs
• Snap to Grid
• Hide Template Tab
• Disable Package Action Variables by Default
• Disable Status Bar Notifications

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
• Server: COMPUTER\SQLEXPRESS2008
• 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

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