ETL Designer User Interface

Upon starting the Visual Importer ETL software, the user will be presented with the main window. This is where the main tasks are controlled such as processing cycles, and other processing tasks taking place in the processor.

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”.

  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

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 Visual Importer ETL 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:

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
Lookups and Lookups GroupsProvides an easy access to user defined data entry screens
Imports and Imports GroupsDefines mapping between Data source and Data target
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.

The Visual Importer ETL 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 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.

  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.

To edit the object double click on the name

Also: Replace String Wizard

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

Confused? Ask question on our ETL Forum

  • vimpe/user_interface.txt
  • Last modified: 22/11/2020 14:43
  • by admin