Specifying a database

Specify a database for your Watson OpenScale instance to use.

Connecting to your database

Watson OpenScale uses a database to store payload, feedback, and measurement data. In addition to selecting a database, you can also select a schema for your database - a schema is a named collection of tables in the database.

  1. Choose a database. You have two options: the free database, or an existing or new database.

    Select your database screen displays with two options to use the free lite plan or use an existing database

    If you have a paid IBM Cloud account, you can provision a Databases for PostgreSQL or Db2 Warehouse service to take full advantage of integration with Watson Studio and continuous learning services. If you choose not to provision a paid service, you can use the free internal PostgreSQL storage with Watson OpenScale, but you are not able to configure continuous learning for your model.

Free Lite plan database

The free database has some important limitations:

  • The free database is hosted, and is not directly accessible to you.
  • IBM Watson OpenScale has full access to your database, and thus has full access to your data.
  • The free database is not GDPR-compliant. If your model processes personally identifiable information (PII), you cannot use the free database. You must purchase a new database, or use an existing database that conforms to GDPR rules. See Information security to learn more.

To proceed with using the free database, click Use the free Lite plan database tile, and then click Save.

You can upgrade to another database from the free database. It is not possible to reconfigure a Compose for Postgres, database for Postgres, or Db2 instance to the free database. After you upgrade, it is impossible to return to using the free database. All the current data, such as the configuration, the scoring results, and explanations cannot be reused. By selecting another schema or database, the Watson OpenScale environment is reset.

Existing or new database

  1. After you select the Use existing or purchase new database option, Watson OpenScale checks your IBM Cloud account to locate any existing databases.

  2. Select your existing database type (Compose for Postgres, database for Postgres, or Db2), then a database from the database list, and then a schema:

    Watson OpenScale uses a PostgreSQL or Db2 database to store model-related data (feedback data, scoring payload) and calculated metrics. Lite Db2 plans are not currently supported. For more information, see Why does Watson OpenScale need access to my training data?

    Select your database screen displays with fields for you to enter database type, database name and schema.

  3. You can also click Select a different location to specify a database location outside of your IBM Cloud account.

    Watson OpenScale uses a PostgreSQL or Db2 database to store model-related data (feedback data, scoring payload) and calculated metrics. Lite Db2 plans are not currently supported.

    • Select the Database Type (Compose for PostgreSQL, Database for PostgreSQL, or Db2), then provide connection information:

      • For a Compose for PostgreSQL database, complete the following fields:

        • Hostname or IP address
        • Port
        • Database (name)
        • Username
        • Password
      • For a Database for PostgreSQL database, complete the following fields:

        • Hostname or IP address
        • SSL Port
        • Base-64 encoded certificate
        • Database (name)
        • Username
        • Password
      • For a Db2 database, complete the following fields:

        • Hostname or IP address
        • SSL Port
        • Database (name)
        • Username
        • Password
    • After you successfully connect, you can select a schema and save your work.

      The schema name needs to be provided explicitly if you provide a Db2 instance with limited access, which does not allow the schema name to be automatically generated. This requirement applies to the Entry Db2 Warehouse plan.

Next steps

Watson OpenScale is now ready for you to send a scoring payload and configure monitors for your deployments.