Hello,
Our team has recently started shifting from using Business Units as our data ingestion approach towards ODX server.
Our project contains 3 environments (Dev, Test, Prod). All of our data providers give us 2 tables per dimension/fact (e.g. dim.user and dim.user_qa etc.) and we store them in 2 separate databases (Datastore and Datastore_qa respectively) with exactly same names (dim.user).
We have a following setup in place implemented using “Environment properties”:
| Environment | Source database |
|---|---|
| Dev | Datastore_QA |
| Test | Datastore_QA |
| Production | Datastore |
This way contents of dim.user table are loaded from Datastore_QA database on Dev and Test environments, and from Datastore database on Production environment.
Is there any way to achieve the same result utilizing ODX server as data ingestion approach?
Hopefully this makes sense, thank you!
