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