Configuring Business Automation Studio

If you select IBM Business Automation Application Designer as an optional component, before you complete the installation configure the custom resource YAML file for your IBM Business Automation Studio deployment.

Procedure

  1. Open the custom resource (CR) file that you created in Generating the custom resource.
  2. Update the bastudio_configuration sections of the custom resource YAML file. For more information, see Custom resource pattern templates For database configuration, set the configuration parameters according to the database type:
    • For Db2®:
      1. Business Automation Studio:
        1. Set bastudio_configuration.database.type to DB2.
        2. Enter your DB2® server hostname or IP into bastudio_configuration.database.host.
        3. Enter your DB2 server port into bastudio_configuration.database.port.
        4. Enter your Business Automation Studio database into bastudio_configuration.database.name.
        5. If you want to connect your database by SSL, set bastudio_configuration.database.ssl_enabled to true and enter your database secret into bastudio_configuration.database.certificate_secret_name.
        6. If you want to use your own JDBC driver, set bastudio_configuration.database.use_custom_jdbc_drivers to true and enter your PVC for JDBC driver into bastudio_configuration.database.custom_jdbc_pvc and JDBC driver files into bastudio_configuration.database.jdbc_driver_files. For more information, see Implementing storage.
      2. Application Engine playback server:
        1. Set bastudio_configuration.playback_server.database.type to DB2.
        2. Enter your DB2 server hostname or IP into bastudio_configuration.playback_server.database.host.
        3. Enter your DB2 server port into bastudio_configuration.playback_server.database.port.
        4. Enter your Application Engine playback server database into bastudio_configuration.playback_server.database.name.
        5. If you want to connect your database by SSL, set bastudio_configuration.playback_server.database.enable_ssl to true and enter your database secret into bastudio_configuration.playback_server.database.db_cert_secret_name.
        6. If you want to use your own JDBC driver, set bastudio_configuration.playback_server.use_custom_jdbc_drivers to true and enter your PVC for JDBC driver into bastudio_configuration.playback_server.database.custom_jdbc_pvc. For more information, see Implementing storage.
    • For Oracle:
      1. Business Automation Studio:
        1. Set bastudio_configuration.database.type to Oracle.
        2. Enter the Oracle connection URL (URL format: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<your-oracle-database-hostname>)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=<your-oralce-database-service-name>)))) into bastudio_configuration.database.oracle_url.
        3. Set bastudio_configuration.database.use_custom_jdbc_drivers to true.
        4. Enter your PVC for Oracle JDBC driver into bastudio_configuration.database.custom_jdbc_pvc and the Oracle JDBC drive files into bastudio_configuration.database.jdbc_driver_files, like ojdbc8.jar. For more information, see Implementing storage.
        5. If you want to connect your database by SSL, set bastudio_configuration.database.ssl_enabled to true.
          • Update bastudio_configuration.database.oracle_url (set in step ii) to use Oracle SSL URL (URL format: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCPS)(HOST=<your-oralce-database-hostname>)(PORT=2484))(CONNECT_DATA=(SERVICE_NAME=<your-oralce-database-service-name>)))).
          • Enter your Database Server Wallet Secret into bastudio_configuration.database.certificate_secret_name. For more information, see Creating secrets to protect sensitive configuration data.
      2. Application Engine playback server:
        1. Set bastudio_configuration.playback_server.use_custom_jdbc_drivers to true.
        2. Set bastudio_configuration.playback_server.database.type to Oracle.
        3. Enter the Oracle connection URL (URL format: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<your-oracle-database-hostname>)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=<your-oracle-database-service-name>)))) into bastudio_configuration.playback_server.database.oracle_url_without_wallet_directory.
        4. Enter your PVC for Oracle JDBC driver into bastudio_configuration.playback_server.database.custom_jdbc_pvc. For more information, see Implementing storage.
        5. If you want to connect your database by SSL, set bastudio_configuration.playback_server.database.enable_ssl to true.
          • Update bastudio_configuration.playback_server.database.oracle_url_without_wallet_directory (set in step iii) to use Oracle SSL URL (URL format: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCPS)(HOST=<your-oracle-database-hostname>)(PORT=2484))(CONNECT_DATA=(SERVICE_NAME=<your-oracle-database-service-name>)))).
          • Enter the Oracle SSL URL with the wallet path (URL format: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=<your-oracle-database-hostname>)(PORT=2484))(CONNECT_DATA=(SERVICE_NAME=<your-oracle-database-service-name>))(SECURITY=(SSL_SERVER_DN_MATCH=FALSE)(MY_WALLET_DIRECTORY=/shared/resources/oracle/wallet)))) into bastudio_configuration.playback_server.database.oracle_url_with_wallet_directory.
            Note: Do not change the path MY_WALLET_DIRECTORY=/shared/resources/oracle/wallet.
          • Enter your Database Server Wallet Secret into bastudio_configuration.playback_server.database.db_cert_secret_name, and your Database Server Wallet SSO Secret into bastudio_configuration.playback_server.database.oracle_sso_wallet_secret_name. For more information, see Creating secrets to protect sensitive configuration data.
    • For PostgreSQL:
      1. Business Automation Studio:
        1. Set bastudio_configuration.database.use_custom_jdbc_drivers to true.
        2. Set bastudio_configuration.database.type to PostgreSQL.
        3. Enter your PostgreSQL server hostname or IP into bastudio_configuration.database.host.
        4. Enter your PostgreSQL server port into bastudio_configuration.database.port.
        5. Enter your Business Automation Studio database into bastudio_configuration.database.name.
        6. Enter your PVC for PostgreSQL JDBC driver into bastudio_configuration.database.custom_jdbc_pvc. For more information, see Implementing storage.
        7. Enter the PostgreSQL JDBC driver files into bastudio_configuration.database.jdbc_driver_files, such as postgresql-42.2.16.jar.
        8. If you want to connect your database by SSL, set bastudio_configuration.database.enable_ssl to true and enter your database secret into bastudio_configuration.database.db_cert_secret_name.
      2. Application Engine playback server:
        1. Set bastudio_configuration.playback_server.use_custom_jdbc_drivers to true.
        2. Set bastudio_configuration.playback_server.database.type to PostgreSQL.
        3. Enter your PostgreSQL server hostname or IP into bastudio_configuration.playback_server.database.host.
        4. Enter your PostgreSQL server port into bastudio_configuration.playback_server.database.port.
        5. Enter your Application Engine database into bastudio_configuration.playback_server.database.name.
        6. Enter your PVC for PostgreSQL JDBC driver into bastudio_configuration.playback_server.database.custom_jdbc_pvc. For more information, see Implementing storage.
        7. If you want to connect your database by SSL, set bastudio_configuration.playback_server.database.enable_ssl to true and enter your database secret into bastudio_configuration.playback_server.database.db_cert_secret_name.
          Note: CN verification of Application Engine is enabled by default when PostgreSQL SSL is enabled. Therefore, you must prepare the database SSL certificate with the proper CN or SAN, and make sure that the database server host name or IP address input matches the CN or the list of the SAN in the certificate.
          For a full list of parameters, see IBM Business Automation Studio configuration parameters.
    For a full list of parameters, see IBM Business Automation Studio configuration parameters.