Skip to content

Oracle DB

This section describes how to use OracleDB as the metadata database. Using Oracle DB utilizes your existing enterprise Database setup and allows you to scale as per your needs. Oracle DB can help stabilize the metadata storage - which is a key component of the platform - by using the market leading solution with premium technical support.

Supported versions: Oracle DB 19+

We use sqlalchemy's oracle dialect to connect to the Oracle Database - this can be setup using the methods that are described in https://docs.sqlalchemy.org/en/13/dialects/oracle.html.

We recommend using oracledb. This is installed by default with the following components:

  • API
  • Celery - API worker

Configurations

In the API configurations, the following configurations need to be set:

  • SQLALCHEMY_DATABASE_URI = 'oracle://<username>:<password>@<hostname>/<dbname>'
    This needs to be set to be able to connect to the Database
  • SQLALCHEMY_ENGINE_OPTIONS = {'max_identifier_length': 128, 'optimize_limits': True}
    Needs to be set to ensure the maximum size for identifiers is 128 and also to use the more optimal methods to LIMIT queries in oracle 12.2+
  • Also, check the other configurations that may be required as described in API - Configurations > SQLAlchemy section