---
title: Data Foundation
slug: ajo-oc-lab-april26/data-foundation
docTags: 
createdAt: 2026-01-16T18:05:55.489Z
---

![](https://experienceleague.adobe.com/en/docs/journey-optimizer/using/campaigns/orchestrated-campaigns/data-configuration/schemas-datasets/media_1ac0bceb690e93404e27f371fe3ea1060cc2e662f.png?width=2000\&format=webply\&optimize=medium)

A **Relational-based schema** is the formal definition of the model-based data model.

It specifies:

- The set of tables
- The columns in each table
- The constraints
- The relationships across tables

Organizing schemas or tables in a model-based data model is about structuring your data into multiple tables. Ensure each table stores one type of entity/schemas.

There are 2 ways to create a **Relational-based schema. **We will only cover the fastest way which is using a DDL file. If you are interested on how to create manually, then visit this [page](https://experienceleague.adobe.com/en/docs/journey-optimizer/using/campaigns/orchestrated-campaigns/data-configuration/schemas-datasets/manual-schema).  Otherwise, check the steps below to see how straight forward it is from a Data Management perspective. 

![](https://api.archbee.com/api/optimize/1Jp0iolWv35Z_mkI7oUiT/DW1m7zskI0oXtHNcGXpQY-20251205-161239.png)

Data Ingestion for the most part remains the same for AJOCO. The following Sources are supported for use with Orchestrated campaigns:



| **Type**              | **Source**                                                                                                                                                    |
| --------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Cloud Storage         | [Amazon S3](https://experienceleague.adobe.com/en/docs/experience-platform/sources/ui-tutorials/create/cloud-storage/s3?lang=en)                              |
|                       | [Google Cloud Storage](https://experienceleague.adobe.com/en/docs/experience-platform/sources/ui-tutorials/create/cloud-storage/google-cloud-storage?lang=en) |
|                       | [SFTP](https://experienceleague.adobe.com/en/docs/experience-platform/sources/ui-tutorials/create/cloud-storage/sftp?lang=en)                                 |
|                       |                                                                                                                                                               |
| Cloud Data Warehouses | [Snowflake](https://experienceleague.adobe.com/en/docs/experience-platform/sources/ui-tutorials/create/databases/snowflake?lang=en)                           |
|                       | [Google BigQuery](https://experienceleague.adobe.com/en/docs/experience-platform/sources/ui-tutorials/create/databases/bigquery?lang=en)                      |
|                       | [Data Landing Zone](https://experienceleague.adobe.com/en/docs/experience-platform/sources/ui-tutorials/create/cloud-storage/data-landing-zone?lang=en)       |
|                       | [Azure Databricks](https://experienceleague.adobe.com/en/docs/experience-platform/sources/ui-tutorials/create/databases/databricks?lang=en)                   |
|                       |                                                                                                                                                               |
| File-Based Uploads    | [Local File Upload](https://experienceleague.adobe.com/en/docs/experience-platform/sources/ui-tutorials/create/local-system/local-file-upload?lang=en)        |