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!
Experiences with "Existing External" database query & updates?
Experiences with "Existing External" database query & updates?
Tom - V8.8 build 3137 - MySql / PostGres
Re: Experiences with "Existing External" database query & updates?
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
Bruce
Re: Experiences with "Existing External" database query & updates?
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?
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?
Tom - V8.8 build 3137 - MySql / PostGres
Re: Experiences with "Existing External" database query & updates?
Bruce,
Have you attached Aware to views? If so, standard views or materialized views?
Have you attached Aware to views? If so, standard views or materialized views?
Tom - V8.8 build 3137 - MySql / PostGres
Re: Experiences with "Existing External" database query & updates?
I have used Aware External DBs with Views, but only standard views.
Bruce
Bruce
Re: Experiences with "Existing External" database query & updates?
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?
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?
Tom - V8.8 build 3137 - MySql / PostGres
Re: Experiences with "Existing External" database query & updates?
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
Shortcuts have to be re-created but otherwise all is good.
Bruce
Re: Experiences with "Existing External" database query & updates?
Hey Bruce,
Doesn't the need to recreate shortcuts break queries where the shortcuts were used?
Thanks!
Doesn't the need to recreate shortcuts break queries where the shortcuts were used?
Thanks!
Tom - V8.8 build 3137 - MySql / PostGres
Re: Experiences with "Existing External" database query & updates?
my bad memory says as long as the same name it worked. But, I have NO memory!
Bruce
Bruce
Re: Experiences with "Existing External" database query & updates?
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.
V8.8 / Windows / MySQL