We require to consolidate 3 Alteryx servers to one large Alteryx box. Out of 3 source servers 2 are located in same data center and 1 is located in different data center. The final destination server is in completely different data center. Each sever has their own work flow, macros and app and own database.
Can someone tell what will be the best way to achieve this goal?
There's no official way that is supported to merge mongo databases. I was looking around on community for anyone who had posted steps on doing it themselves but wasn't able to come up with anything. Ultimately there's no really good way of doing it that's not going to cause problems. Your best bet is to just manually rebuild it all, unfortunately.
