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 data 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.