Experiences with "Existing External" database query & updates?

tford

Hi All,

Tipping my toe back into the forum waters.

I'm interesting in learning about any and all experiences you have with "existing external" persistence DBs.

What positive or negative experiences have you had? Limitations you experienced? Cool things you've done?

We have a Postgres DB that I'm considering leveraging Aware IM if it turns out to be the best tool for the job.

I'm particularly interested in your experiences with filtering in queries & being able to update records in the "existing external" DB.

Thanks!

BLOMASKY

It just works. Now the limitations, you can NOT add any fields in the aware connection to the DB EXCEPT for shortcuts and that assumes that a foreign key was defined in the External file. Also, if you change the external file, you have to "Discover" the fields again, but thats not a problem. I have an app where I use the external files for both queries and updates.

Bruce

tford

Thanks much, Bruce!

Years ago when I used Aware on an external DB, my vague recollection is when re-discovering attributes when changes in the DB happened, then queries would break and have to be redefined.

Can you confirm that nothing breaks when re-discovering?

Great to hear about shortcuts when foreign keys are defined. Again, I don't think that was the case years ago, but I could be wrong.

Also, do filters work?

tford

Bruce,

Have you attached Aware to views? If so, standard views or materialized views?

BLOMASKY

I have used Aware External DBs with Views, but only standard views.

Bruce

tford

Thanks Bruce,

Can you confirm that nothing breaks when re-discovering? Years ago when I used Aware on an external DB, my vague recollection is when re-discovering attributes when changes in the DB happened, then queries would break and have to be redefined.

Do AwareIM filters work?

BLOMASKY

I have had to "rediscover" often. Esp. when new columns are added to underlying database. (Which happens too often!)
Shortcuts have to be re-created but otherwise all is good.

Bruce

tford

Hey Bruce,

Doesn't the need to recreate shortcuts break queries where the shortcuts were used?

Thanks!

BLOMASKY

my bad memory says as long as the same name it worked. But, I have NO memory!

Bruce

gernotlg

I connect to external. Doesn't seem to be a problem with rediscovering aside from a lesson I learned early.. which is to just do your formatting in the query, not the BO attributes because they'll all go back to whatever the default is.