OCP database overview

The Optimizely Connect Platform (OCP) database is a relational database that stores object data from any source. It is designed to support flexible data imports and integrations with Optimizely products.

OCP database structure

The OCP database uses a familiar relational structure to organize and manage your data. Understanding how objects, fields, and relationships work together helps you define a schema that supports your data syncs and integrations.

• Objects – Collections of related data (also known as a database table).
• Fields – Attributes of each object (also known as database columns).
• Relationships – Connections between objects using shared fields

Each object has a primary key, such as product_id, to uniquely identify each record. This key is required when creating or updating records during data imports.

Manage your data schema

Before you import data into OCP, you must create the necessary data schema to support the data you want to import. Importing data through an app installation is the only method that does not require you to manage the data schema yourself (the app handles that for you).

You can manage your OCP database schema (objects, fields, and relationships) on the Objects & Fields page or through the OCP API.

The Objects & Fields page displays the OCP database schema, but does not show the data contained within those objects and fields.

Import data

After you create the necessary objects and fields to support your data import, you can import the corresponding data.

View the data in your OCP database

After you import data into OCP, you can view that data on the Objects Explorer page.

You can select the object for which you want to view database records, search for specific records, select which database columns you want to view, sort by specific columns in ascending or descending order, and view details for each record.