In order to edit the data, Active Table Editor must be able to connect to the database.

Supported Databases/Connections

  • Oracle
  • MS SQL Server
  • Microsoft SQL Server CE
  • Interbase or Firebird
  • MySQL
  • PostgreSQL
  • SQLite
  • Ole DB
  • ODBC


Connections toolbar
  1. Properties
  2. Refresh list
  3. Add connection
  4. Delete connection
  5. Clone connection
  6. Print
  7. Print preview
  8. Find
  9. Enable Incremental search
  10. Show grouping panel
  11. Export grid
  12. Export data to excel
  13. Customize columns
  14. Auto format grid

Creating New Connections

To create a New Connection, Click Outlook Bar-> Management-> Connections->Plus Icon

New connection

  1. Dialog box will appear.
  2. Select the appropriate connection type
  3. In the Name Text Box type in a new name for the connection you are about to create
  4. Fill in server name/database name/port number and all other relevant information
  5. Fill in Username/Password
  6. Click Test to ensure the details you have provided are correct
ODBC Connection Properties

ODBC Connection Strings

It also possible to use ODBC connection strings for both Reader and Writer connections.

For example for MS SQL Server connection string is: Driver={SQL Native Client}; Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

One of the major benefits of using connection strings that it makes it no longer necessary to create ODBC Dsn’s manually on every single computer where Advanced ETL Processor is installed. It also gives a greater control over the connection parameters.

More information about connection strings can be found at:

The simplest way to create ODBC connection string is to use ODBC Connection builder dialogue. Double click on ODBC driver name to create a connection string.

ODBC connection builder

Table Browser

Allows editing data in tables, run scripts or create/drop database objects.

Table Browser
Confused? Ask question on our ETL Forum
Last updated: July 4, 2023