Configuring a Service Task to Call a Database

Procedure

  1. Select the service task that you want to use to call the database.
  2. On the General tab of the Properties view, set Service Type to Database.
  3. If you have already defined the system participant that you want to use, drag it from Project Explorer and drop it in the Participants field. See Using a System Participant to Identify the Target Database.
  4. Select the Operation that you want to execute on the database, either:
    • SQL, to execute a SQL query.
    • Stored Procedure, to execute a stored procedure.
  5. Define your SQL query or select the stored procedure that you want to execute on the database. See Creating a SQL Query or Selecting a Stored Procedure.
  6. Define the input and/or output parameters required for the query or stored procedure. See Mapping Data Between the Process and the Database.