Connection Manager

Connection Manager, located under System Configuration, provides administrators with a way to connect their database to Transact. The Connection Manager supports the Fuzzy DB Lookup and DB Export options. The process of connecting a database follows these general steps:

1. Add a new connection.
2. Configure connection details.
3. Test and save the connection.

The following database connections are supported in the Connection Manager:

• MySQL

• Microsoft SQL Server

• Microsoft SQL Server with Windows Authentication

• Oracle

• MariaDB