Database operations occur within a database session. The lifetime of the session varies depending on the component connection to the database. Use the Database results processing plug-in to log execution results to a database. Use the Property Loader step type to import property and variable values from a file or database during an execution. Use a code module or the built-in Database step types to communicate with a database.

A simple database operation includes the following steps:

  1. Use the Open Database step type to connect to a database.
  2. Use the Open SQL Statement step type to perform an SQL query on tables in the database.
  3. Use Data Operation step types to create new records and to retrieve and update existing records.
  4. Use the Close SQL Statement step type to close the SQL query.
  5. Use the Close Database step type to disconnect from a database.

Right-click the Database step and select Edit <step type> from the context menu to configure the step type and to set the custom step properties. You can also click the Edit <step type> button on the edit tab of the Step Settings pane.