topic Re: How would I use query and queryTask with an Oracle database (non-geodatabase) in ArcGIS JavaScript Maps SDK Questions

How would I use query and queryTask with an Oracle database (non-geodatabase)

AndrewTamberino — Thu, 07 Jul 2011 00:31:08 GMT

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.

Re: How would I use query and queryTask with an Oracle database (non-geodatabase)

derekswingley1 — Thu, 07 Jul 2011 19:33:25 GMT

Any data you access via the JS API needs to be exposed via a web service. This can be a map service, feature service, etc. The tools provided by the API (queryTask, feature layers) make this easy. If you just need to hit a REST endpoint, you can use esri.request().

For editing, you can use feature layers.

Re: How would I use query and queryTask with an Oracle database (non-geodatabase)

AndrewTamberino — Thu, 07 Jul 2011 19:48:33 GMT

Derek,
If I understand you correctly there's not really a way to do what I want in the Javascript API. I was coming to that conclusion myself, but I was hoping that I'd missed something.
Thank you for responding.
Regards,
Andrew

Re: How would I use query and queryTask with an Oracle database (non-geodatabase)

derekswingley1 — Thu, 07 Jul 2011 23:47:25 GMT

Right, the JS API (and the other Web APIs, Flex and Silverlight) cannot talk directly to an Oracle database.