Connections

In order to edit data, Active Table Editor must be able to connect to one or more Data sources.

Active Table Editor can work with following databases:

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

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

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

Note:

 To refresh the list of databases double click on it

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.

Note:

 Leave username and password blank and provide it within the connection string

More information about connection strings can be found at: https://www.connectionstrings.com

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.