Cora Orchestration supports multiple databases, at present Microsoft SQL and PostgreSQL. MS SQL is the default database supported with Cora Orchestration. However, you may choose to use open-source PostgreSQL.
Before you begin
Before you deploy the database, make sure that:
- The latest PowerShell modules are installed.
Setup a connection to PostgreSQL database
To connect Cora Orchestration to the PostgreSQL server you need to run a few PowerShell functions:
Run Set-CoraSeQuenceApplicationConfiguration function with
-ConfigurationNameparameter set to PostgresSettings. You can set other parameters as per need.
Run Set-CoraSequenceConnectionStringPostgres function to set connection string.
Run Set-CoraSeQuenceApplicationConfiguration function to set the
ServiceBrokerparameter. You may set the service broker as ActiveMQ or any other of your choice.