Configure a Database Publisher

A database publisher enables IMS Integration Hub to read messages from a database connection. An alternative publisher type for ActiveMQ connections is also available. See Configure an ActiveMQ Publisher. When you create a database publisher, a polling schedule for that publisher is created automatically.

Activity Steps

1. On the toolbar, click New Database Publisher.

   A publisher is added to the Integration » Publishers node in the Configuration Explorer.

2. Double-click the publisher node.

   The Database Publisher screen displays the connection details for the publisher.

3. Update the Name of the publisher.
4. Select whether to Log Successful Runs.
5. Complete the following connection details.
   • Connection Type—Select from SQLServerNative or OracleODP.
   • Data Source—For Oracle, this is the alias name. For SQL Server, this is the name of the server to which to connect.
   • Initial Catalog
   • Use Integrated Security—Only applicable if the Connection Type is SQLServerNative.
6. If Use Integrated Security is unchecked, complete the following fields.
   • Database User
   • Database Password
7. Update the following fields as required.
   • Connection Timeout—Measured in seconds.
   • Command Timeout—Measured in seconds.
   • Target Table—The database table containing the stored messages to be processed.
8. Click Test.
9. If the connection is not successful, determine the correct settings or contact your network administrator or Datamine representative.
10. If the connection is successful:
    1. Click OK.
    2. Click Save.
    3. Click Close.