Using the Database application

Know how to use the Database application.

About this task

Understand how to use the Database application.

You have a Flow service and want to run it. The Flow service selects a record from the customer database.

Procedure

  1. When creating a Flow service, select Database.
  2. Select Add custom action. The Connect account page appears.
  3. Provide a suitable name and description for the action you want to create, select an existing Database account, if any, and click Next. Select the + option if you want to add a Database account.
  4. If you select the + option to add a Database account, on the Add account page, provide the following details.
    • Name - Provide a suitable name for the account you want to add.
    • Description - Provide a suitable description for the account you want to add.
    • Database - Select the supported database to connect.
    • Driver group - Select an existing driver group or click the + option to add a driver group.

      Provide the following details on the Add driver page.

      • Database - Select the supported database to connect.
      • Driver Group - Provide a name for the driver group.
      • Select the driver - Select the JDBC driver jar to upload.
    • Transaction Type - Select the transaction type.
    • Data source Class - Select the data source class.
    • Server Name - Enter the server that hosts the database, for example sample.adapter.db.com.
    • User - Enter the username associated with the account on the database server.
    • Password - Enter the password for the specified username.
    • Database Name - Enter the database name to which the connection connects.
    • Port Number - Enter the port number.
    • Truststore Alias - Select the alias name of the webMethods Integration truststore configuration.
    • Keystore Alias - Select or add a keystore alias.
    • Network Protocol - Enter the network protocol that the connection uses when connecting to the database.
    • Property name - Enter the property name.
    • Property value - Enter the property value.
  5. Save the details.
  6. Now, on the Add custom action page, if you click Connect to account Database, the account is added. You can use this account to run any Database custom action created under the same project.
  7. Select an account from the Connect to account Database and click Next.
  8. Select the action and click Next.
  9. Select the Tables. Here, you see all the available tables, views or synonyms.
  10. Add a table from the existing tables and click Next.
  11. You see all the selected tables, views, or synonyms. Add a Join and click Next.
  12. Select the Data fields. You can also change the Output field Type and the Sort order for a data field.
  13. Click Next and select the Condition. Add a single or multiple conditions and click Next.
  14. Select the Parameters and edit the execution parameters.
  15. Verify the summary and click Done. The flow service window appears.
  16. Click the run icon to run the flow service. The output data for the configured custom action appears.