Create the Database#

SQL Server#

  1. Connect to your SQL Server

  2. Create a database named colectica_workflow

  3. Run the SQL commands in Datacolectica_workflow.sqlserver.sql of the Colectica Workflow Task runner package

  4. Give the LocalService account, or the user account that will run the workflow task runner, access to the colectica_workflow database.

  5. Give the LocalService account, or the user account that will run the workflow task runner, access to all colectica repository databases you wish to configure.

PostgreSQL#

  1. Connect to your PostgreSQL server

  2. Create a database named colectica_workflow

  3. Run the SQL commands in Data\colectica_workflow.postgresql.sql of the Colectica Colectica Workflow Task Runner package