How Can I Create Multiple Connectors That Sync Data to the Same Destination Schema?

Question

How can I create multiple connectors that sync data to the same destination schema?

Environment

Connector: Workday RaaS

Answer

To uniquely identify Workday RaaS connectors, we use a naming format that combines the destination schema and table names as schema_name.table_name. This means that as long as the table name is unique, multiple connectors can utilize the same destination schema name.

While creating a new connector, you can specify an existing destination schema's name in the Destination schema field.

IMPORTANT: Once you create a connector, you can't change its destination schema.