Configuring a Database Connector

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

1. Create and name the connector service request as described in Creating Service Requests.

2. On the Connector design page, click the Connection field and select a connection under the Database category.

   The Orchestrator Studio displays an edit area that contains a Groovy script template. Use the Find and "Go to Line" fields and Undo and Redo buttons to work with the script.

3. In the Input grid, enter the inputs that you want to pass to the database. You can enter hard coded values or include variable using the ${} notation, entering the variable name within the brackets.

4. 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.

5. Click Save.