SQL Power Business Intelligence Productivity Tools
Company OverviewBusiness Intelligence Productivity ToolsQuick-Start Implementation ServicesDemos & TurotialsFrequently Asked Questions (FAQ)Open Source Community ResourcesSQL Power ForumImplementation & Technology PartnersGet SQL Power SoftwareContact Us

SQL Power Software Forum
SQL Power Software Forum
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [Groups] Back to home page  [Register] Register /  [Login] Login 
Don't over cache database schema objects  XML
Forum Index » SQL Power DQguru Suggestions
Author Message
[Post New]2009-02-06 09:10:28
    Subject: Don't over cache database schema objects
[Up]
donn


Joined: 2009-02-04 13:44:43
Messages: 13
Offline
After adding a new table to my database schema, I found that I could not see it in the Project Build dialog without EXITing MatchMaker, restarting and recreating my project.

Consider including a REFRESH button to refresh the meta data cache or not caching at all.

Best wishes.

Donn
[Post New]2009-02-06 12:24:13
    Subject: Re:Don't over cache database schema objects
[Up]
donn


Joined: 2009-02-04 13:44:43
Messages: 13
Offline
This sounds like lilihammer's 'database refresh option', and may be the example that Jonathan is looking for.

Donn
[Post New]2009-02-27 10:04:52
    Subject: Re:Don't over cache database schema objects
[Up]
Jonathan
SQL Power Developer

Joined: 2007-01-08 15:10:32
Messages: 873
Offline
Hi Donn,

I am in the final stages of implementing this refresh feature. I'll follow up here when it's working and available in the nightly builds. Naturally, it will be included in the next official release.

-Jonathan
[Post New]2009-04-22 17:57:16
    Subject: Re:Don't over cache database schema objects
[Up]
Jonathan
SQL Power Developer

Joined: 2007-01-08 15:10:32
Messages: 873
Offline
Late Followup:

This did go in a few days after my previous post, but I forgot to respond here and introduce you to the feature.

The refresh feature "just works:" every time you visit a munge process (now called a transformation in DQguru), it will double-check the physical database for you and adjust your input and output steps as necessary. This check-and-adjust also takes place when you start an engine.

-Jonathan
 
Forum Index » SQL Power DQguru Suggestions
Go to:   
Powered by JForum 2.1.8 © JForum Team