Hi @rvgfox ,

I think you would run into those ‘table x is in use by another’ warnings if it works at all. You would run into metadata synch issues anyway. I think it is better to accept having a separate copy of data for Dev and Test.

@rvgfox  as Rory mentions this is not possible, as the ODX instances need separate storage containers. However it is possible to use the same ODX instance for several data warehouse instances. Please feel free to create a product idea for sharing storage containers across ODX instances

Thanks @rory.smith  and @Christian Hauggaard but I’m thinking in use the same data set stored in the storage container in the development and test environments, and only update the contents when I launch the DSA in production environment.

In this way I can setup the data sources in the ODX used in development and test with:

And in the ODX used in production environment:

Do you think that it’s possible?

Hi @rvgfox 

This is not possible. When you transfer the ODX Test instance to the ODX Prod instance the data source setting for the data on demand will also be transferred. So if you would like different settings for data on demand then this would have to be changed manually following the promote. 

I know @Christian Hauggaard  , since that is the idea, to keep the two ODX with the same data sources but with different settings in the "Enable data on demand" parameter. I only transfer the ODX from DEV to PROD the first time because I don't need to change the data sources after that.