Skip to main content

Currently I’m using one ODX instance with this setup:

 

 

All the mapped data sources connections has selected the option “Enabled data on demand”:

 

 

I am using three instances of Data Warehouse: Development → Testing → Production.

My question is:

Can I create a new ODX instance connected to the same Storage container?

The idea is that the same data sources in the DW instances for development and test use the "Enable data on demand" OFF option. In this way the storage container only will be refreshed one time (when we refresh the DWH production instance) because the data source is the same.

 

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.


Reply