Sync mechanism for users between environments
Hello Data Citizens,
How are you dealing with user synchronization between different DGC Prod and DGC Dev/Test environments to make consistent number of Author license across environments?
The easiest option is Production backup and restore to Dev/Test but this affect whole content, and we are planning less frequent so number of users remain not in-sync for most of the time until the next backup/restore.
There is easy way to use REST API directly in Excel so this would give us easy way for accounts comparison between environments but we are phasing out Excel usage in our organization. Do you know if API can be used in google sheet?
We could write custom Mulesoft application based on Collibra API but single app deployed on Production that connect to non-production environments is always a challenge from security reason and platform setup.
Is it possible to build custom workflow that connects to other DGC instance for user synchronization? Do you have any other recommendation?
Kind Regards,
Paweł
Paweł Fronczak
OP5 years ago · EditedExactly, we want to retrieve results from prod and non-prod in a single file and after comparison sync non-prod environment with the missing license. Thank you for the guideline to Google App Script.
arthurburkhardt
·5 years ago · EditedNot sure exactly what you want to do: do you want to retrieve results from prod and non-prod in a single excel file to match and highlight differences, then sync manually?
If you’re worried about licenses, you can just wait until you go over and fix it when it does, it’s not a hard limit anyways.
Otherwise, Google Sheets is absolutely awesome and integrates a full-blown javascript engine (Google App Script). So you can write a script to fetch whatever data from wherever you want, and even push it back if needed. https://developers.google.com/apps-script/guides/sheets