Transact

⌘K
  1. Home
  2. Transact
  3. System Configuration
  4. Connection Manager

Connection Manager

This document describes how to configure a database connection in Ephesoft Transact using the Connection Manager. This information is intended for Transact administrators.

Overview

The Connection Manager is located under System Configuration and provides administrators with a way to connect their database to Transact. This is used to support 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 the 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

Add a New Connection

To add a new connection, perform the following steps.

  1. Go to System Configuration > Connection Manager.
Figure 1. Connection Manager
  1. Click Add to create a new connection.
Figure 2. Add New Connection
  1. Proceed to Configure the Connection Details.

Configure the Connection Details

By default, new connections will have the Connection Type set to MYSQL. To proceed, select your Connection Type from the dropdown and refer to the section below for configuration specific to your database:

MySQL

This section covers how to connect your MySQL database to Transact. Refer to the following table for information on each required configuration.

Configurable Field Description
Connection Name The name for your connection as it will appear in the Connection Manager in Transact.
Connection Description The description for your connection as it will appear in the Connection Manager in Transact.
Connection URL The connection URL for the MySQL database, this is generated automatically from other fields. For help understanding this URL, refer to the MySQL Documentation.
Database Name The name of the particular database on the server.
Port The port number where the MySQL server listens for requests. By default this is port 3306.
Host The host name of the database server.
User Name The username for connecting to the MySQL database.
Password The password for connecting to the MySQL database.

When you’re ready, proceed to Test and Save the Connection.

Microsoft SQL Server

This section covers how to connect your Microsoft SQL Server (MSSQL) database to Transact. Refer to the following table for information on each required configuration.

Configurable Field Description
Connection Name The name for your connection as it will appear in the Connection Manager in Transact.
Connection Description The description for your connection as it will appear in the Connection Manager in Transact.
Connection URL The connection URL for the Microsoft SQL Server database, this is generated automatically from other fields. For help understanding this URL, refer to the Microsoft SQL Documentation.
Database Schema Name The schema name for the SQL server database. By default this is dbo.
Database Name The name of the particular database on the server. To find the database name, refer to sample queries in the Microsoft SQL Documentation.
Port The port number where the SQL server database listens for requests. By default this is port 1433.
Host The host name of the database server.
User Name The username for connecting to the SQL server database.
Password The password for connecting to the SQL server database.

When you’re ready, proceed to Test and Save the Connection.

Microsoft SQL Server with Windows Authentication

This section covers how to connect your Microsoft SQL Server database to Transact when using Windows Authentication. This option allows Transact to use Windows user accounts to connect to the database, instead of using explicit database users.

Refer to the following table for information on each required configuration.

Configurable Field Description
Connection Name The name for your connection as it will appear in the Connection Manager in Transact.
Connection Description The description for your connection as it will appear in the Connection Manager in Transact.
Connection URL The connection URL for the Microsoft SQL Server database, this is generated automatically from other fields. For help understanding this URL, refer to the Microsoft SQL Documentation.
Database Schema Name The schema name for the database. By default this is dbo.
Domain The name of your Windows domain.

To get the domain name of a machine:

  1. Open the command prompt.
  2. Type “set” and hit enter. The current environment variable settings will display.
  3. Find the USERDOMAIN property.
Database Name The name of the particular database on the server. To find the database name, refer to sample queries in the Microsoft SQL Documentation.
Port The port number where the database server listens for requests. By default this is port 1433.
Host The host name of the database server.
User Name These fields are disabled.

Note: When using MSSQL Windows Authentication, Transact will attempt to use the name of the user running the EphesoftTransact service to connect to the database. You can view this account from the Services manager:

  1. Open Windows Services manager.
  2. Right-click EphesoftTransact.
  3. Click Properties > Log On.

If you try to test the database connection and receive an error that you suspect is related to authentication, you may need to grant access to the database table for the services account user inside SQL Server Management Studio.

Password

When you’re ready, proceed to Test and Save the Connection.

Oracle

This section covers how to connect your Oracle database to Transact. Refer to the following table for information on each required configuration.

Configurable Field Description
Connection Name The name for your connection as it will appear in the Connection Manager in Transact.
Connection Description The description for your connection as it will appear in the Connection Manager in Transact.
Connection URL The connection URL for the Oracle database, this is generated automatically from other fields. For help understanding this URL, refer to the Oracle Documentation.
Database Name The name of the particular database on the server. Also known as the SID in Oracle terminology.

Note: Due to Oracle restrictions, the Database Name must be in uppercase and match the User Name.

Port The port number where the Oracle server listens for requests. By default this is port 1521.
Host The host name of the database server.
User Name The username for connecting to the Oracle database.

Note: Due to Oracle restrictions, the User Name must be in uppercase and match the Database Name.

Password The password for connecting to the Oracle database.
SID / Service Name Select between SID (Service ID) or Service Name and add the string to the text field. This should match the case (uppercase or lowercase) as it was entered during Transact installation.

This will automatically concatenate the Connection URL with the SID or service name.

You can use the following query to find the service name:

select value from v$parameter where name=’service_names’;

Note: In versions prior to Transact 4.5.0.0, only the SID is available.

When you’re ready, proceed to Test and Save the Connection.

MariaDB

This section covers how to connect your MariaDB database to Transact. Refer to the following table for information on each required configuration.

For detailed information on these parameters, refer to Connecting to MariaDB.

Configurable Field Description
Connection Name The name for your connection as it will appear in the Connection Manager in Transact.
Connection Description The description for your connection as it will appear in the Connection Manager in Transact.
Connection URL The connection URL for the MariaDB database, this is generated automatically from other fields.
Database Name The name of the particular database on the server.
Port The port number where the MariaDB server listens for requests. By default this is port 3306.
Host The host name of the database server.
User Name The username for connecting to the MariaDB database.
Password The password for connecting to the MariaDB database.

When you’re ready, proceed to Test and Save the Connection.

Test and Save the Connection

  1. When you’re satisfied, click Test Connection. If you receive any errors, refer to the message provided to resolve the issue before proceeding.
  2. Click Save to add the connection.

Conclusion

This completes an overview of how to configure a database connection in Ephesoft Transact using the Connection Manager.