---
title: "Select deploy transformations"
slug: "select-deploy-transformations"
tags: ["Task", "Data Modeling Studio", "DMS"]
updated: 2026-03-20T08:18:01Z
published: 2026-03-20T17:44:45Z
canonical: "docs.staedean.com/select-deploy-transformations"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.staedean.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Select deploy transformations

For each data model you can define transformations to be executed automatically after the data model is deployed.

You can define transformations of these categories:

- **Modeling**: You can use modeling transformations to create views in the target database. These views are created based on the business entities that are created in the target database on deploy.
- **Instrumentation**: You can use instrumentation transformations to create objects, stored procedures, and schemas in the target database. You can also use these transformations to do calculations on the metadata that is exported on deploy.

A transformation contains one or several SQL statements which define the transformation actions to be done.

### Steps

1. Go to **Data modeling studio** > **Data modeling studio** > **Data models**.
2. In the list, find and select the desired data model.
3. Click **Transform**.
4. Sub-task: Add several transformations at once.
  1. You can add several transformations at once.

Click **Add multiple...**.
  2. In the list, find and select the desired transformations.

> [!NOTE]
> **Note**
> 
> Only the transformations of category '**Modeling**' and '**Instrumentation**' are shown in the list.
  3. Click **Ok**.
5. Sub-task: Add one transformation.
  1. You can add one transformation.

Click **Add**.
  2. In the **Template** field, enter or select a value.

> [!NOTE]
> **Note**
> 
> Only the transformations of category '**Modeling**' and '**Instrumentation**' are shown in the lookup.
6. Sub-task: Define transformation sequence.
  1. Define the sequence in which the transformations are applied.

To move a transformation one position up, click **Up**.

> [!NOTE]
> **Note**
> 
> You can also manually set the sequence in the **Order** field.
  2. To move a transformation one position down, click **Down**.

> [!NOTE]
> **Note**
> 
> You can also manually set the sequence in the **Order** field.
7. Click **OK**.
8. Close the page.

## Related

- [Deploy data model](/deploy-data-model.md)