I'm writing a web app using ArcGIS API for Javascript and I need to query data from a standard Oracle (10g) database at the same time I'm querying my SDE. I probably don't need to add that I'm new to esri development.
Is there a way, using the javascript API, to combine the query tasks and/or mashup the returned data into a map and infoWindow?
Is there a way to edit the infoWindow data and have it write back to the two databases?
I found that I can publish a query layer in ArcMAP and interact with that using my javascript, but that isn't allowing my users the ability to dynamically craft queries on the fly.
Thank you for reading my post. Any help is appreciated.