> For the complete documentation index, see [llms.txt](https://help.daasity.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.daasity.com/core-concepts/data-integrations/setup-guides/digital-integrations/ometria/transformation-configuration-setup.md).

# Transformation Configuration Setup

## Overview

The Ometria extractor provides data on email campaigns, contacts, subscribe / unsubscribe, and sends / bounces / open / clicks. The Daasity transformation code maps data from the Ometria schema into the Unified Notifications Schema (UNS)

## Feature Dependencies

You must have enabled our [Code Repository](/technical-docs/transform-code/code-repository.md) feature in order to both access the Daasity transformation code as well as modify a Script Manifest File enabling this code to execute

We recommend you review the [Transformation Configuration](/technical-docs/workflows-and-scheduling/script-manifest-yaml-files.md) section of our Help documentation to familiarize yourself with our workflow engine and script manifest files.

## Script Manifest File (YML)

### Upstream Transformation Dependencies

{% hint style="danger" %}
This code is dependent on the following integration being installed:

* Ometria

This code block is dependent on the following upstream code blocks being implemented:

* [Initialization](/technical-docs/transform-code/transform-code/initialization-code.md)
  {% endhint %}

### Transformation Code Requirements

To enable the data transformation from the Ometria schema into UNS, the following code must be run in a workflow:

```
  uns_ometria:
    integrations:
      - ometria
    scripts:
      - "github://platform-sql-shared/scripts/base/1000_uns/ometria/1320_UNS_BAS_OMETRIA_campaigns.sql"
      - "github://platform-sql-shared/scripts/base/1000_uns/ometria/1330_UNS_BAS_OMETRIA_contacts.sql"
      - "github://platform-sql-shared/scripts/base/1000_uns/ometria/1340_UNS_BAS_OMETRIA_lists.sql"
      - "github://platform-sql-shared/scripts/base/1000_uns/ometria/1360_UNS_BAS_OMETRIA_contact_lists.sql"
      - "github://platform-sql-shared/scripts/base/1000_uns/ometria/1380_UNS_BAS_OMETRIA_sends.sql"
      - "github://platform-sql-shared/scripts/base/1000_uns/ometria/1381_UNS_BAS_OMETRIA_opens.sql"
      - "github://platform-sql-shared/scripts/base/1000_uns/ometria/1382_UNS_BAS_OMETRIA_clicks.sql"
      - "github://platform-sql-shared/scripts/base/1000_uns/ometria/1383_UNS_BAS_OMETRIA_unsubscribes.sql"
      - "github://platform-sql-shared/scripts/base/1000_uns/ometria/1384_UNS_BAS_OMETRIA_bounces.sql"
```

### Unified Notification Schema

Code to populate the UNS tables:

* <https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/1000_uns/ometria/1320_UNS_BAS_OMETRIA_campaigns.sql>
* <https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/1000_uns/ometria/1330_UNS_BAS_OMETRIA_contacts.sql>
* <https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/1000_uns/ometria/1340_UNS_BAS_OMETRIA_lists.sql>
* <https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/1000_uns/ometria/1360_UNS_BAS_OMETRIA_contact_lists.sql>
* <https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/1000_uns/ometria/1380_UNS_BAS_OMETRIA_sends.sql>
* <https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/1000_uns/ometria/1381_UNS_BAS_OMETRIA_opens.sql>
* <https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/1000_uns/ometria/1382_UNS_BAS_OMETRIA_clicks.sql>
* <https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/1000_uns/ometria/1383_UNS_BAS_OMETRIA_unsubscribes.sql>
* <https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/1000_uns/ometria/1384_UNS_BAS_OMETRIA_bounces.sql>