Set up transformations

You can use transformations to define SQL statements. You can have these transformation SQL statements executed:

Name	Responsible	Description
Set up modeling transformation	DMS Administrator	On deploy of a data model, 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. A modeling transformation contains one or several SQL statements which define the transformation actions to be done. Usually, a transformation is created in SQL and then the file is uploaded to the Data templates and transformations. On upload, a new transformation is created or an existing transformation is overwritten. You can also manually create a transformation in DMS and create or copy the SQL statements to the Definition field.
Set up instrumentation transformation	DMS Administrator	On deploy of a data model, 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. An instrumentation transformation contains one or several SQL statements which define the transformation actions to be done. Usually, a transformation is created in SQL and then the file is uploaded to the Data templates and transformations. On upload, a new transformation is created or an existing transformation is overwritten. You can also manually create a transformation in DMS and create or copy the SQL statements to the Definition field.
Set up processing transformation	DMS Administrator	On data export for a data model, you can use processing transformations to do calculations in the target database. A processing transformation contains one or several SQL statements which define the transformation actions to be done. You can have processing transformations executed before or after exporting data: Pre-export transformations: Used to do calculations on the metadata in the target database. For example, on enumerations or labels. Post-export transformations: Used to do calculations based on the data that has just been exported to the target database. Usually, a transformation is created in SQL and then the file is uploaded to the Data templates and transformations. On upload, a new transformation is created or an existing transformation is overwritten. You can also manually create a transformation on the Data templates and transformations page, and create or copy the SQL statements to the Definition field.

Name

Responsible

Description

Set up modeling transformation

DMS Administrator

On deploy of a data model, 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. A modeling transformation contains one or several SQL statements which define the transformation actions to be done.

Usually, a transformation is created in SQL and then the file is uploaded to the Data templates and transformations. On upload, a new transformation is created or an existing transformation is overwritten. You can also manually create a transformation in DMS and create or copy the SQL statements to the Definition field.

Set up instrumentation transformation

DMS Administrator

On deploy of a data model, 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. An instrumentation transformation contains one or several SQL statements which define the transformation actions to be done.

Set up processing transformation

DMS Administrator

On data export for a data model, you can use processing transformations to do calculations in the target database. A processing transformation contains one or several SQL statements which define the transformation actions to be done.

You can have processing transformations executed before or after exporting data:

Pre-export transformations: Used to do calculations on the metadata in the target database. For example, on enumerations or labels.
Post-export transformations: Used to do calculations based on the data that has just been exported to the target database.

Usually, a transformation is created in SQL and then the file is uploaded to the Data templates and transformations. On upload, a new transformation is created or an existing transformation is overwritten. You can also manually create a transformation on the Data templates and transformations page, and create or copy the SQL statements to the Definition field.

Set up transformations

Activities