Hard-coding value in Replication

  • 8Views
  • Last Post 2 weeks ago
0
votes
Woody Chin posted this 2 weeks ago

I am syncing multiple tenants in Pipedrive into a single set of tables in my SQL database.

I am not sure that the primary keys are unique across tenants.

As such, I would like to append a hard-coded field to the target database table to know which company tenant it was from.

E.g., in Actitivity, hard-code a "TenantID = 1" and put that into the SQL DB with each record synced.

 

Is there anyway to do that?

 

0
votes
Mariia Zaharova posted this 2 weeks ago

Hello Woody,

 

Unfortunately not, there is no possibility to add any additional field via the Replication package. Skyvia replication package creates target tables according to the source objects definition. 

You can create target objects manually and consider the Import package or Data Flow package for your scenario. 

 

Best regards,

Mariia

Close