Options

The Visual Importer ETL allows user to tweak key settings. Using this provision user can change the repository type, control the execution of packages and where the results will be logged, set interface actions such as the prevention of accidental deletion and set email options to report the outcome of the automation to individuals or groups of people.

To change Visual Importer ETL settings click System menu→ File→ Options.

The Dialog box will appear.

The Repository tab defines the repository connection. Once the login parameters have been verified via the “Test Connection” dialogue this information is saved so it is not necessary to provide this information again.

The Repository type can be:

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

Use Repository creation wizard to create new repository.

To enable parallel execution select following options

1. Execute Actions in separate thread
2. Use Agent to execute Actions

Defines key interface settings, these operate globally during the activities of the Visual Importer ETL. For instance, in order to save time when creating packages to automate tasks, the editor can be set so that it automatically opens. In order to ensure that any changes made to scripts and packages upon exit, user can safeguard this by checking the “Save all scripts and packages on exit” box. Accidental deletion is prevented by requesting that the user is asked before deleting any objects. Another aspect of the interface actions is the updating of the log. This can be set so that once a package has completed its actions the log is updated with all the actions which took place during execution. Finally, if user wishes to automatically refresh table list when creating/opening transformation you simply check the “Update Tables List” to ensure that user this is accurate, and up to date.

Defines default Emails settings. As the Visual Importer ETL is designed to work automatically and in batch mode, it will be necessary to specify where emails will be sent from. Emails messages are used to convey when processes and activities have been completed. It is also possible to specify the default recipient. The default recipient can be set to a group email address, or it can be left blank.

Defines email connection settings for agent notifications. The server may run out of disc space or repository database can become corrupted. In case of repository connection failure agent will send two emails one after the failure another after the connection was restored. In most of the cases the agent will work as expected once reconnected however it is recommended to restart it.

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 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, that makes moving software to 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 list of all available repository connections
• Note: This list is shared between all applications
• DesktopConnection.ini this file holds ETL Designer repository connection name
• ServerConnection.ini this file holds Execution agent, Management console and Monitors repository connection name