# \#data-transformation

**URL:** https://community.cdata.com/tag/data-transformation/552.md

[Latest](https://community.cdata.com/latest.md) · [Categories](https://community.cdata.com/categories.md) · [Tags](https://community.cdata.com/tags.md)

---

## [dbt Transformations with CData Sync](https://community.cdata.com/t/dbt-transformations-with-cdata-sync/1054)

<div class="topic-metadata">

**Author:** [@Cameron\_L](https://community.cdata.com/u/Cameron_L)\
**Replies:** 0\
**Last updated:** [March 14, 2025, 2:53pm UTC](https://community.cdata.com/t/dbt-transformations-with-cdata-sync/1054 "2025-03-14T14:53:53Z")

</div>

CData Sync supports the execution of ELT processes flexibly using dbt Core or dbt Cloud. This integration gives users complete control over defining and executing complex data transformation workflows in dbt, while CData…

---

## [CDATA Sync: add semicolons in a transformations SQL script with SQL server as target?](https://community.cdata.com/t/cdata-sync-add-semicolons-in-a-transformations-sql-script-with-sql-server-as-target/932)

<div class="topic-metadata">

**Author:** [@Jackolas](https://community.cdata.com/u/Jackolas)\
**Replies:** 2\
**Last updated:** [November 6, 2024, 6:57am UTC](https://community.cdata.com/t/cdata-sync-add-semicolons-in-a-transformations-sql-script-with-sql-server-as-target/932 "2024-11-06T06:57:29Z")

</div>

I’m trying to do a transformation after a dataload to a SQL server. The query used is: (the query is tested and works on the SQL server) MERGE INTO \[S\_Material\_Data\] AS tgtUSING ( SELECT HASHBYTES('SHA2\_256', mat.MatNr…