Creating a database connection profile

To enable an integration server to be connected to a database, add the database driver file for the database.

1. Start the Toolkit.
2. From the Data Source Explorer view, right-click Database Connections folder and click New.

   The New Connection window opens.

3. Set the database manager to a supported database type; DB2 for Linux, UNIX, and Windows, MySQL, Oracle, or SQL Server.
4. Select the Driver properties according to your database requirement from the Driver's list.
   The following table lists the supported database driver for each of the database type.

   Database type	Database driver
   DB2 for Linux, UNIX, and Windows	IBM Data Server Driver for JDBC and SQLJ (JDBC 4.0) Default
   MySQL	MYSQL 5.1 - MySQL JDBC Driver Default
   Oracle	Oracle11 - Oracle Thin Driver Default
   SQL Server	SQL Server 2014 - Microsoft SQL Server 2014 JDBC Driver Default

5. Click Edit the location of the JDBC driver JAR files.

   The Edit JAR list window opens.

   1. Click Add JAR/Zip.
   2. Browse and select the JAR file that is required by your database.
   3. Click OK.

      The Edit JAR window closes.

6. To set up the connection to the database, specify the required connection parameters according to your database type. For example, specify the Database name, Host, Port number, User name, Password, Connection URL, and more.

   You need to specify the database properties according to your environment setup. The database properties differ between the supported database types.

   For example:

   • Database: Specify a database name.
   • Host: The host name of your database host server.
   • Port Number: The port number of your database server.
   • User name: The user name to connect to your database.
   • Password: The password for the specified user name.
   • Connection URL: The URL of your database host server
   • Select Save password
7. Set the Connection Name.
   By default, the connection name is retrieved from Database name.

   Note: Use this database connection profile to develop the message flow from the toolkit.

   Attention: You have two approaches to create a database connection.

   1. Creating a connection that does not start with ACMFG. You need to set the environment variable.
   2. Creating a connection, which starts with ACMFG. You do not need to set the environment variable.
8. Click Test Connection.

   Make sure that your connection is successful.

9. Click Finish.

   You are now connected to your database and you can view your database tables.