Process to setup new R3 Source System
Hi, there seems to be a lot of posts out there regarding this topic, but I can't seem to get a specific answer out of it all?
I am adding a new R3 Source System (R2) to my BI System in addition to the existing R3 Source System (R1). I would like all of my BI Objects to have the same connections (Transformations, etc.) to my new R3 Source System (R2) that I currently have for my R1.
What do I have to do to make this happen? Is there a defined process for this?
Do I have to manually copy the transformations for everything? (This would be sooo difficult due to volume)
Please add clarity to this situation if you can...