Using MS SQL Server for Activi

[Jeffrey Spencer]

I am new to Activiti and have just downloaded and installed the grails 5.12.1 plugin. Looks very promising so far. How would I go about configuring Activiti to connect to the existing Grails 1) datasource or 2) specify connection details to MS SQL Server or even an Oracle db.

The following properties were injected into my config file after running  >> grails activiti-quickstart command line.

Also, does anyone know of any documentation that explains the properties below? Some are obvious but not all.

Thanks.

Jeff

// Added by the Grails Activiti plugin:
activiti {
    processEngineName = "activiti-engine-default"
      databaseType = "h2"
      deploymentName = appName
      deploymentResources = ["file:./grails-app/conf/**/*.bpmn*.xml",
                             "file:./grails-app/conf/**/*.png",
                             "file:./src/taskforms/**/*.form"]
      jobExecutorActivate = false
      mailServerHost = "smtp.yourserver.com"
      mailServerPort = "25"
      mailServerUsername = ""
      mailServerPassword = ""
      mailServerDefaultFrom = "user...@yourserver.com"
      history = "audit" // "none", "activity", "audit" or "full"
      sessionUsernameKey = "username"
      useFormKey = true
}

environments {
    development {
        activiti {
              processEngineName = "activiti-engine-dev"
              databaseSchemaUpdate = true // true, false or "create-drop"
        }
    }
    test {
        activiti {
              processEngineName = "activiti-engine-test"
              databaseSchemaUpdate = true
          mailServerPort = "5025"
        }
    }
    production {
        activiti {
              processEngineName = "activiti-engine-prod"
              databaseSchemaUpdate = false
              jobExecutorActivate = true
        }
    }