Options

To access 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 ETL designer hard work is 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 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 Execution agent, Management console and Monitors repository connection name
  • aetle/options.txt
  • Last modified: 07/07/2021 10:33
  • by admin