Skip to main content

Celonis Product Documentation

How do I copy a table from one Data Connection to another?

You need to create or use a Transformation in a global Data Job (a Data Job without a Data Connection). In such a Transformation you can copy a table from one Data Connection to another using SQL, e.g.

CREATE TABLE <%= DataConnectionNameTarget %>.TableName AS SELECT * FROM <%= DataConnectionNameSource %>.TableName

The parameters used for the Cata Connection are supplied in all Transformations of global Data Jobs.

Copying from/to the global scope

You can also copy a table from the global Data Pool scope to a Data Connection scope or the other way around by simply omitting the Data Connection parameter.