Set up a manual model-based schema manual-schema
Model-based schemas can be created directly through the user interface, enabling detailed configuration of attributes, primary keys, versioning fields, and relationships.
The following example manually defines the Loyalty Memberships schema to illustrate the required structure for Orchestrated campaigns.
-
Create a model-based schema manually using the Adobe Experience Platform interface.
-
Add attributes such as customer ID, membership level, and status fields.
-
Link your schema to built-in schemas such as Recipients for campaign targeting.
-
Create a dataset based on your schema and enable it for use in Orchestrated campaigns.
-
Ingest data into your dataset from supported sources.
➡️ Learn more about manual model-based schemas in Adobe Experience Platform documentation
Create your schema schema
Start by creating a new model-based schema manually in Adobe Experience Platform. This process allows you to define the schema structure from scratch, including its name and behavior.
-
Log in to Adobe Experience Platform.
-
Navigate to the Data Management > Schema menu.
-
Click Create Schema.
-
Select Model-based as your Schema type.
-
Choose Create manually to build schema by manually adding fields.
-
Enter your Schema display name.
-
Click Finish to proceed to your schema creation.
You can now start adding attributes to your schema to define its structure.
Add attributes to your schema schema-attributes
Next, add attributes to define the structure of your schema. These fields represent the key data points used in Orchestrated campaigns, such as customer identifiers, membership details, and activity dates. Defining them accurately ensures reliable personalization, segmentation, and tracking.
Any schema used for targeting must include at least one identity field of type String
with an associated identity namespace. This ensures compatibility with Adobe Journey Optimizer’s targeting and identity resolution capabilities.
-
ENUM
ENUM fields are supported in both DDL-based and manual schema creation, allowing you to define attributes with a fixed set of allowed values. -
Schema Label for Data Governance
Labeling is supported at the schema field level to enforce data governance policies such as access control and usage restrictions. For more details, refer to Adobe Experience Platform documentation. -
Composite Key
Composite primary keys are supported in model-based schema definitions, enabling the use of multiple fields together to uniquely identify records.
-
In the canvas, click
-
Enter your attribute Field name, Display name and Type.
In this example, we added the attributes detailed in the table below to the Loyalty memberships schema.
accordion Attributes examples table 0-row-3 1-row-3 2-row-3 3-row-3 4-row-3 5-row-3 6-row-3 7-row-3 8-row-3 Attribute Name Data Type Additional Attributes customer STRING Primary Key membership_level STRING Required points_balance INTEGER Required enrollment_date DATE Required last_status_change DATE Required expiration_date DATE - is_active BOOLEAN Required lastmodified DATETIME Required -
Assign the appropriate fields as the Primary Key and Version Descriptor.
When creating a manual schema, ensure the following essential fields are included:
- At least one primary key
- A version identifier, such as a
lastmodified
field of typedatetime
ornumber
. - For Change Data Capture (CDC) ingestion, a special column named
_change_request_type
of typeString
, which indicates the type of data change (e.g., insert, update, delete) and enables incremental processing. Note that_change_request_type
should not be part of the table schema, it should only be added to the data file during ingestion.
-
Click Save.
After creating and saving attributes, you can link the schema with other relational schemas by defining relationships.
Link schemas link-schema
Creating a relationship between two schemas lets you enhance Orchestrated Campaigns with data beyond the primary profile schema.
-
From your newly created schema, select the attribute you want to use as the link and click Add relationship.
-
Choose the Reference schema and Reference field to establish the relationship with.
In this example, the
customer
attribute is linked to therecipients
schema. -
Enter a Relationship name from current schema and from reference schema.
-
Click Apply once configured.
Create a dataset for the schema dataset
After defining your schema, you can now create a dataset based on it. The dataset stores your ingested data and must be enabled for Orchestrated Campaigns to be accessible.
-
Navigate to the Data Management > Datasets menu and click Create dataset.
-
Select Create dataset from schema.
-
Choose your previously created schema, here Loyalty memberships, and click Next.
-
Enter a Name for your Dataset and click Finish.
You now need to enable your Dataset for Orchestrated Campaigns.
Enable Dataset for Orchestrated Campaigns enable
After creating your dataset, you need to explicitly enable it for Orchestrated Campaigns. This step ensures your dataset is available for real-time orchestration and personalization within Adobe Journey Optimizer.
Refer to Adobe Developer documentation to validate or enable Orchestrated Campaign Extension on Dataset.
-
Locate your dataset in the Datasets list.
-
From the Datasets settings, enable the Orchestrated Campaigns option to mark the dataset available for use in your Orchestrated Campaigns.
-
Wait a few minutes for the enablement process to complete. Note that data ingestion and campaign use will only be possible once this setting is fully activated.
You can now start ingesting data into your schema using the source of your choice.