Configuring a Database Connector

You must have knowledge of Groovy, JRuby, or Jython scripting language to create a database connector to route data to a database. The database must support JDBC. The Connector design page provides a template for the selected scripting language that you can use as a basis for creating a Groovy script for a database connector.

1. Click the Connectors icon on the Orchestrator Studio Home page.

2. On the Connectors side panel, click the New drop-down menu and select Database.

3. Create and name the connector service request as described in Creating a Component.

4. On the Connectors design page, click the Database field and select a connection.

   The Orchestrator Studio displays an edit area that contains a script template corresponding to the selected scripting language (Groovy, JRuby, or Jython). Click the Show Shortcut Command icon (?) to view the commands to work with the script.

5. In the Input grid, enter the inputs that you want to pass to the database connector.

6. In the Output column, list the fields added to the returnMap in the Groovy script to make those outputs available to the orchestration. Optionally, enter a variable name in the Variable column if you want to make the values available for mapping to a subsequent step in an orchestration.

7. If you intend to return a set of records, enter a name for the data set in the Data Set Variable Name field.

   You have to then define the column names (fields) for the records you want to return (such as name, location, and so on).

   Member Names - Variable Name grid is applicable only used if you enter a value in the Data Set Variable Name field.

8. The Member Name column correspond to the field in the table in the database. The Variable Name column is the name that you would use to refer to the corresponding field when passing it to the other orchestration steps.

9. Click Save.