Updating Workflow Process Service Authoring with other capabilities

If you want to install a pattern that does not include Business Automation Studio, there are no database limitations for this pattern.

If you want to install a pattern that includes Business Automation Studio, you need to consider the database that you want to use. For example, these patterns include but are not limited to the IBM Automation Document Processing development environment, IBM Workflow Authoring, an IBM Business Automation Application with Application Designer, or IBM Automation Decision Services.

• If you already use an external PostgreSQL database for Workflow Process Service Authoring, you can use the same database for the Business Automation Studio in the other pattern.
• If you already use an embedded PostgreSQL database for Workflow Process Service Authoring and you want to continue to use this database for Business Automation Studio in the other pattern, you need to add the embedded database configuration to the bastudio_configuration database section.
  1. Find the secret icp4adeploy-wps-db-app to get the PostgreSQL service value, the port and the database name.
  2. Update your Workflow Process Service Authoring custom resource (CR) to include the EDBPostgreSQL configuration under the Business Automation Studio database configuration section. For example, the configuration section might look similar to:

  database:
        type: postgresql
        ## Provide the database server hostname for BAStudio
        host: "icp4adeploy-wps-db-rw"
        ## Provide the database name for BAStudio. For example, wfpsdb. This parameter is case sensitive.
        ## The database provided should be created by the BAStudio SQL script template.
        name: "wpsdb"
        ## Provide the database server port for BAStudio
        port: "5432"
      #   ## If you want to enable PostgreSQL connection fail-over, you must configure alternative_host and alternative_port. Otherwise, leave them blank.
      #   alternative_host:
      #   alternative_port:
     

• If you want to use another type of database for the Business Automation Studio in the other pattern, you will have to find your own method to migrate your data from PostgreSQL.