Configure the Metadata Database Connection

The values of the metadata elements can be directly entered, imported as a CSV file, or obtained from a database table. To enable the user to select the values of the metadata elements obtained from a database table on the metadata tab when creating a workflow, configure the Metadata Database Connection.

Add a database connection

  1. Click [Workflow] → [General] → [Metadata Database Connection].

  1. Click (Add) in the connector list.

To create a new connector based on an existing connector, select the connector to copy, click (Copy), and select the connector to edit.

  1. On the [General] tab, specify the connection name, the database server's address, etc., for the Metadata Database Connection.

    Item

    Description

    Connection Name

    Enter the connection name.

    Description

    Enter the description of the replacement table.

    Database Server Address

    Enter the host name or IP address of the server with the connected database.

    Database Instance Name

    The instance with the connected database can contain up to 127 characters.

    Database Port Number

    Specify the port number used when connecting to the database.

    Database Name

    Enter the connected database name.

    User Name

    Enter the user name with access privileges to the database.

    Password

    Enter the password of the user with access privileges to the database.

    [Test] button

    Test the connection to the database.

  1. Click [Test].

  2. On the [Select Server] window, select the Delegation Server to use to test the connector.

  3. Click [Run].

  4. When a message is displayed indicating that the connector test was successful, click [OK].

If an error message is displayed, click [OK], check the settings, and test the connector again.

  1. Click (Save) on the connector list.

Change a database connection

  1. Click [Workflow] → [General] → [Metadata Database Connection].

  1. From the connector list, select the connector to modify, and then change the settings.

    Refer to Add a database connection for the list of settings

  1. Click (Save) on the connector list.

Delete a database connection

  1. Click [Workflow] → [General] → [Metadata Database Connection].

  1. From the connector list, select the connector to delete, and then click (Delete).

  1. When the confirmation message is displayed, click [Yes].

A connector being used in a workflow cannot be deleted. Use the [Workflow] tab to view the workflows that are using the connector.