User Interface

Upon starting the Advanced ETL Processor software, the user is presented with the main window. This is where users design data transformations and workflows.

System Menu

The system menu allows the user to access the essential setting and tools.

Main window

Main window

Quick Access Tabs

The “Quick Access Tabs” gives the user easy access to various functions of the application:

The titles of the tabs are self-explanatory, the default tab is “design”.

Objects Tree Toolbar

Objects Tree Toolbar
  1. Selected object properties
  2. Refresh object tree
  3. Create a new object
  4. Delete selected object
  5. Cut
  6. Copy
  7. Paste
  8. Incremental Search
  9. Expand selected tree node
  10. Collapse selected tree node

Objects Tree Description

The “Objects” tree lists the main categories for the provision of objects. For instance, the “Directories” category contains icons representing the location of files and related information belonging to an individual item. For example, by clicking on the “Excel Files” icon you will access the directory area where all the Excel files are stored for processing.

You may also find icons representing individual database connection services. For instance, you can see connections available for both MS SQL Server and Oracle.

Other object types include ODBC connections. You can see from the illustration that the DEMO system has been configured, and as a result, the ODBC connections created are listed in the objects tree. The Advanced ETL Processor provides the Objects tree so the users have easy access to the main objects.

Objects Tree List

Below is a list of possible objects with the short descriptions:

ProjectsProvides a way to group objects together
DirectoriesDefines path to flat files, Excel files, MS Access databases or DBF files
JDBC ConnectionDefines JDBC connection properties
SQL Server CE ConnectionDefines MS SQL Server CE connection properties
SQL Server ConnectionDefines MS SQL Server connection properties
ODBC ConnectionDefines ODBC connection properties
Oracle ConnectionDefines Oracle connection properties
Ole DBDefines Ole DB connection properties
MySQLDefines MySql connection properties
PostgreSQLDefines PostgreSQL connection properties
SQLiteDefines SQLite connection properties
Interbase/FirebirdDefines Interbase/Firebird connection properties
MongoDbDefines MongoDb connection properties
FTP ConnectionDefines FTP Server connection properties
SMTP ConnectionDefines SMTP connection properties
POP3 ConnectionDefines POP3 server connection properties
IMAP4 ConnectionDefines IMAP4 server connection properties
SalesForceConnection Defines SalesForce connection properties
BrightPearlConnection Defines BrightPearl connection properties
Google Spreadsheet ConnectionDefines Google Spreadsheet connection properties
IP Socket ConnectionDefines IP Socket connection properties
Tableau ConnectionDefines Tableau connection properties
Lookups and Lookups GroupsProvides an easy access to user defined data entry screens
Transformations and Transformations GroupsProvides a way of transferring data from one database/file into another together with complex transformation, validation, sorting and grouping operations
Reports and Reports GroupsReports design
SQL Scripts and Scripts GroupsDefines SQL statements to perform against target Databases
Email templates and groupsCreates general email templates.
Packages and packages groupsCombines complex Actions together like Ftp downloads File operations, emails, Check files, SQL scripts and Transformations.

Objects Groups

The Advanced ETL Processor also has the ability to group objects together into “groups”. The purpose of doing this is so that objects of a specific type can be viewed as a branch of the object tree. Whenever a new object is added it will be placed under the appropriate branch for its type.

Objects Groups

To create a new object group select the appropriate object type for example transformation and click “new”.

Create new object group

Depending on the object type, the appropriate dialogue will be presented. In this example, the Transformation Group has been selected. The dialogue, in this case, requests a description and comment about the object to be created. Some of the fields in a dialogue of this type will be mandatory and will, therefore, have to be entered. However, comments will be optional, and just provide the user with the ability to specify more detail about an object and what it does.

Transformation Group Properties

Transformation Group Comments

Transformation Group User Fields

Status Bar

  1. Number of records
  2. Number of errors
  3. Records per second
  4. Start Date time
  5. Time Left
  6. Progress bar

For large implementations, the incremental search is a very useful option.

Incremental Search

Incremental Search

Replace String Wizard

Video Tutorials

For more technologies supported by our ETL Software see Advanced ETL Processor Versions

Confused? Ask question on our ETL Forum
Last updated: July 6, 2023