Upon starting the Advanced ETL Processor software, the user is presented with the main window. This is where users design data transformations and workflows.
The system menu allows the user to access the essential setting and tools.
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”.
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.
Below is a list of possible objects with the short descriptions:
|Projects||Provides a way to group objects together|
|Directories||Defines path to flat files, Excel files, MS Access databases or DBF files|
|JDBC Connection||Defines JDBC connection properties|
|SQL Server CE Connection||Defines MS SQL Server CE connection properties|
|SQL Server Connection||Defines MS SQL Server connection properties|
|ODBC Connection||Defines ODBC connection properties|
|Oracle Connection||Defines Oracle connection properties|
|Ole DB||Defines Ole DB connection properties|
|MySQL||Defines MySql connection properties|
|PostgreSQL||Defines PostgreSQL connection properties|
|SQLite||Defines SQLite connection properties|
|Interbase/Firebird||Defines Interbase/Firebird connection properties|
|MongoDb||Defines MongoDb connection properties|
|FTP Connection||Defines FTP Server connection properties|
|SMTP Connection||Defines SMTP connection properties|
|POP3 Connection||Defines POP3 server connection properties|
|IMAP4 Connection||Defines IMAP4 server connection properties|
|SalesForce||Connection Defines SalesForce connection properties|
|BrightPearl||Connection Defines BrightPearl connection properties|
|Google Spreadsheet Connection||Defines Google Spreadsheet connection properties|
|IP Socket Connection||Defines IP Socket connection properties|
|Tableau Connection||Defines Tableau connection properties|
|Lookups and Lookups Groups||Provides an easy access to user defined data entry screens|
|Transformations and Transformations Groups||Provides a way of transferring data from one database/file into another together with complex transformation, validation, sorting and grouping operations|
|Reports and Reports Groups||Reports design|
|SQL Scripts and Scripts Groups||Defines SQL statements to perform against target Databases|
|Email templates and groups||Creates general email templates.|
|Packages and packages groups||Combines complex Actions together like Ftp downloads File operations, emails, Check files, SQL scripts and Transformations.|
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.
To create a new object group select the appropriate object type for example transformation and click “new”.
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.
For large implementations, the incremental search is a very useful option.