Edit Data Modules Database reference

[Rosanero4Ever]

Hi all,

I created a data module based on some tables of a test database (snapshot mode is disables)
Now I would refer production database tables.
So, I  edited data server updating connection informations and schema metadata and  I see, in dashboard which use this data module, are still test data.
How can i update my dashboard data using the production database?
Thanks a lot in advance.

[MFGF]

Hi all,

I created a data module based on some tables of a test database (snapshot mode is disables)
Now I would refer production database tables.
So, I  edited data server updating connection informations and schema metadata and  I see, in dashboard which use this data module, are still test data.
How can i update my dashboard data using the production database?
Thanks a lot in advance.

You probably have the data in the query service cache. You could try clearing this:

Go to Manage > Administration Console.
Go to the Configuration tab
Select Query Service Caching on the left
Use the Clear Cache link on the right hand side of the page.

MF.

[Rosanero4Ever]

Nothing...After cleaning cache as you seggested, the result is always the same: test data are dispayed  :(
Have you any other advice, please?

[Rosanero4Ever]

Explaining better my target,  for a data module (for which snapshot option is disabled) I need to change the data server reference in order to use same tables but different data....I'm looking for a solution in google, ath the moment, without success...

[MFGF]

Nothing...After cleaning cache as you seggested, the result is always the same: test data are dispayed  :(
Have you any other advice, please?

Assuming you are using this data module in a dashboard, the other option is to come at this from the opposite angle. Create a new Data Module based on your production database tables. You can then edit your dashboard and relink it to the new data module:



MF.

[Rosanero4Ever]

uhm...thanks MFGF for your post..but some considerations (I hope IBM listen to this forum  ::) ) :
- if i create 10 data modules that use a test db and if I need to switch to a production db, I need to create 10 new data modules
- If I have 20 dashboard (2 dashboard for each data module) I have to edit 20 dashboard to perform relink action

What do you think about these considerations? How do you think to solve this scenario? Luckly I always work with test and production environment...perhaps does IBM advice us to consider only a production environment?  :D

[MFGF]

uhm...thanks MFGF for your post..but some considerations (I hope IBM listen to this forum  ::) ) :
- if i create 10 data modules that use a test db and if I need to switch to a production db, I need to create 10 new data modules
- If I have 20 dashboard (2 dashboard for each data module) I have to edit 20 dashboard to perform relink action

What do you think about these considerations? How do you think to solve this scenario? Luckly I always work with test and production environment...perhaps does IBM advice us to consider only a production environment?  :D

Sorry, you seem annoyed. I'm just trying to help you find a way through this problem. If you want changes to the product, it's worth going to the RFE site and logging an enhancement request (then getting all your friends and family to vote for it) :)

https://www.ibm.com/developerworks/rfe/

MF.

[Rosanero4Ever]

MFGF, you're wrong...I'm not annoyed and I thank you for your time!!  ;)
I wrote only some considerations in order to share some aspects that I hope IBM will improve in the future.
That's all...