Connecting to the database from Toolkit

Databases contain business data that is written and accessed by deployed message flows.

A database connection is a configuration file where you specify a database's physical details such as database type and version, and parameters to enable a JDBC connection from the Toolkit to the database.

Note: If you have created a database name other than ACMFG, make sure that you set the environment variable ‘ACMFG_SCHEMA_NAME’ to the specified database name and restart the Toolkit.
You can create a connection between the Toolkit and the database by using the following methods:
  • Configure the database connection using an environment variable.
  • Configure the database connection from the Toolkit.

Configure the database connection using an environment variable

Perform the following steps to create a database connection by using an environmental variable:
  1. From the Toolkit, configure the database connection. See, Creating a database connection profile.
  2. Configure the database connection within an environmental variable. See, Setting the environment variable to support access to the database.
  3. Restart the Toolkit.

Configure the database connection from the Toolkit

Perform the following steps to create a database connection from the Toolkit.
Note:
  • Make sure that there is no any environment variable added with the name of ACMFG_BUILDTIME_CONFIGURATION.
  • The database Connection name should start with ACMFG. There should be only one connection name that starts with ACMFG.

From the Toolkit, configure the database connection. See, Creating a database connection profile.