topic Re: Advice on linking to data from Flex Viewer to SQL Server? in ArcGIS Viewer for Flex Questions

Advice on linking to data from Flex Viewer to SQL Server?

MelissaJohnson — Wed, 29 Sep 2010 12:39:19 GMT

I know using just Flex there is no way to link to SQL Server but I was hoping to get some dialog going from the experts out there on the best and easiest way to do this.
I have my Flex Viewer 2.1 and want to pass my parcel ID to SQL Server to return additional records.

Questions (Opinions):
Which is the easiest to learn for beginners?
Which method returns data fastest and taxes the server the least?

I am looking to take a class to learn how to do this (I wish ESRI had a class that explained connecting databases when building web mapping apps). I am not sure which service type I should use. In Flex you can use Blaze, Cold Fusion, HTTP, LCDS, PHP, Web Service or XML to connect to data services. Maybe there are others out there as well.

If anyone has experience with any of these good or bad some advice would be greatly appreciated.
Thanks in advance!
Melissa

Re: Advice on linking to data from Flex Viewer to SQL Server?

RobertScheitlin__GISP — Wed, 29 Sep 2010 13:09:18 GMT

Melissa,

I am not sure about the other ways out there but I use ASP.Net Webservice to do that on my site. I can't really talk about the ease of creating this service as I have been a .Net Developer for many years, so it came naturally to me. I do know there are many examples that you can Google of how to create a web service in dot net. My querying of my SQL Server 2005 is very responsive and the data is just returned as XML so Flex has not issue traversing it. You will want to keep your queried data to exactly what you need and try to limit the amount returned. I pass a Parcel ID Number to my web service and that will ensure I only get one record returned.

Re: Advice on linking to data from Flex Viewer to SQL Server?

MelissaJohnson — Thu, 30 Sep 2010 17:34:41 GMT

Thanks Robert! I have Googled the asp.net webservices for tutorials and had problems with them. I am using the Visual Studio express 10 and haven't been successful following the instructions in them without getting errors. I will keep looking.
thanks again.
Melissa

Re: Advice on linking to data from Flex Viewer to SQL Server?

NadeemShaukat — Mon, 29 Nov 2010 20:01:57 GMT

Melissa,

I am not sure about the other ways out there but I use ASP.Net Webservice to do that on my site. I can't really talk about the ease of creating this service as I have been a .Net Developer for many years, so it came naturally to me. I do know there are many examples that you can Google of how to create a web service in dot net. My querying of my SQL Server 2005 is very responsive and the data is just returned as XML so Flex has not issue traversing it. You will want to keep your queried data to exactly what you need and try to limit the amount returned. I pass a Parcel ID Number to my web service and that will ensure I only get one record returned.

Robert,

I am also in a situation where I have to pass user input and access data from SQL Server database to be presented in a data grid. Could you elaborate on the steps that you have taken in your project to facilitate this.

Thanks

Nshaukat

Re: Advice on linking to data from Flex Viewer to SQL Server?

MelissaJohnson — Mon, 29 Nov 2010 20:05:45 GMT

I am taking an ASP.net class next week so I can learn more about coding a webservice to access my SQL server data. I searched through the web and found some helpful links, but they just didn't quite take me where I need to be in the details of coding the webservice for my purposes. Hopefully things will be clearer for me after the class!

Re: Advice on linking to data from Flex Viewer to SQL Server?

RobertScheitlin__GISP — Mon, 29 Nov 2010 20:23:58 GMT

Nadeem,

Not much more I can elaborate on the development of a .Net webservice is completely specific to your data and as I said there are many examples out there, but you will have to have a fairly decent .Net programming ability to get started. Once you have the web service returning your data as xml than parsing it in flex is pretty easy. I don't think I can dumb this down with a generic example.

Re: Advice on linking to data from Flex Viewer to SQL Server?

RobertScheitlin__GISP — Mon, 29 Nov 2010 20:25:07 GMT

Melissa,

Good luck in the class. Let us know how it goes.

Re: Advice on linking to data from Flex Viewer to SQL Server?

CarmenDurham — Tue, 30 Nov 2010 13:31:09 GMT

Melissa,

About a year ago, we got a "Web handler/service" from ESRI called "GeoRSSSite" that we used to access data from a SQL table (Fire Truck locations updated every minute).

We were able to alter their code to connect to our data. It was a bit of trial and error (as we had no clue what we were doing either), but we got it to work. We really just edited the files directly in a text editor vs having to use VStudio.

I have used it over an over for various things - some for creating the XML to generate auto-complete lists.

Maybe you can ask someone at ESRI if that is still available and if there are instructions???

Robert is the expert at this, but I can tell you that we got it to work without being an expert by any means. 😄

Carmen

Re: Advice on linking to data from Flex Viewer to SQL Server?

RickBaker — Wed, 01 Dec 2010 21:16:02 GMT

Nadeem,

Not much more I can elaborate on the development of a .Net webservice is completely specific to your data and as I said there are many examples out there, but you will have to have a fairly decent .Net programming ability to get started. Once you have the web service returning your data as xml than parsing it in flex is pretty easy. I don't think I can dumb this down with a generic example.

I have a .net webservice where some of the functions return a single table (which works fine in FB4) but there are some that return an array of tables. This is causing me some grief in drilling in to the individual tables to get the data. Do you have any experience with this. Any suggestion is appreciated.

Re: Advice on linking to data from Flex Viewer to SQL Server?

EmilyLaMunyon — Mon, 20 Dec 2010 15:27:55 GMT

Hello,
Can the Flex Viewer connect to the webservice of your choice, such as a ColdFusion webservice?

Thanks!

Re: Advice on linking to data from Flex Viewer to SQL Server?

MelissaJohnson — Mon, 20 Dec 2010 17:06:08 GMT

One of the options under Connect to Data/Service is Connect to Cold Fusion.

Re: Advice on linking to data from Flex Viewer to SQL Server?

EmilyLaMunyon — Mon, 20 Dec 2010 17:11:00 GMT

Thanks Melissa!

I have been successful connecting to a CF webservice in Flash. Maybe this is not possible, but I was wondering if I could connect/use a coldfusion webservice in the Flex Viewer 2.1 without Flash.

Emily

Re: Advice on linking to data from Flex Viewer to SQL Server?

MelissaJohnson — Mon, 20 Dec 2010 17:13:09 GMT

Maybe someone else can answer your question. I am really new to Flex. I just knew that Cold Fusion was one of the options.

Re: Advice on linking to data from Flex Viewer to SQL Server?

RobertScheitlin__GISP — Mon, 20 Dec 2010 17:20:10 GMT

Emily,

There is no widget or anything built into FlexViewer 2.1 to allow connecting to a CF Web Service. Connecting to a CF Web service is definitely very custom and have to be coded by a developer that know what the web service is providing and what to do with it once it has it.

Re: Advice on linking to data from Flex Viewer to SQL Server?

LizDaRos — Tue, 10 May 2011 19:20:23 GMT

I've gone through a few tutorials of setting up a webservice and returning my sql data as xml and parsing into a flex application... and got it to work.
Now I'd like to show the data in my Sample Flex Viewer using the webservice. I've tried adding a few lines to my searchwidget to display the data but I'm not having much luck. Can anyone give me some help? Or is this NOT the way I should be doing this... should I be trying to �??Pass Search Parameters via URL in Sample Viewer�?�?
Ultimately I'd like to either search for a streetlight and get the sql data or possibly click on the streetlight and have this info appear.
Any help will greatly be appreciated.

Re: Advice on linking to data from Flex Viewer to SQL Server?

NasifAlshaier — Wed, 22 Jun 2011 12:58:13 GMT

Melissa,

About a year ago, we got a "Web handler/service" from ESRI called "GeoRSSSite" that we used to access data from a SQL table (Fire Truck locations updated every minute).

We were able to alter their code to connect to our data. It was a bit of trial and error (as we had no clue what we were doing either), but we got it to work. We really just edited the files directly in a text editor vs having to use VStudio.

I have used it over an over for various things - some for creating the XML to generate auto-complete lists.

Maybe you can ask someone at ESRI if that is still available and if there are instructions???

Robert is the expert at this, but I can tell you that we got it to work without being an expert by any means. 😄

Carmen

Hi Carmen..

can you share the Web handler/service" from ESRI called "GeoRSSSite"?

Thanks
Nasif

Re: Advice on linking to data from Flex Viewer to SQL Server?

MeghanMcGaffin — Mon, 27 Jun 2011 13:20:18 GMT

Melissa,

About a year ago, we got a "Web handler/service" from ESRI called "GeoRSSSite" that we used to access data from a SQL table (Fire Truck locations updated every minute).

We were able to alter their code to connect to our data. It was a bit of trial and error (as we had no clue what we were doing either), but we got it to work. We really just edited the files directly in a text editor vs having to use VStudio.

I have used it over an over for various things - some for creating the XML to generate auto-complete lists.

Maybe you can ask someone at ESRI if that is still available and if there are instructions???

Robert is the expert at this, but I can tell you that we got it to work without being an expert by any means. 😄

Carmen

I am definitely interested in learning more about how you did this.

Re: Advice on linking to data from Flex Viewer to SQL Server?

grahamcooke — Wed, 29 Jun 2011 08:31:11 GMT

Here is a link to a thread tha might help where I was trying to ascertain how to get the results back from a .net webservice.
http://forums.arcgis.com/threads/23798-calling-webservices-from-action-script-order-of-events?p=78120#post78120

Hope this helps.

Re: Advice on linking to data from Flex Viewer to SQL Server?

MichaelVolz — Fri, 31 Aug 2012 13:10:58 GMT

Carmen:

Can you provide the sample and details of the sample that you received from ESRI on the GeoRSSSite?

Re: Advice on linking to data from Flex Viewer to SQL Server?

CarmenDurham — Thu, 18 Oct 2012 17:04:37 GMT

Sorry - I have just stumbled on these requests. I don't think I received an email notification. Attached is a .zip file of the contents of the "GeoRSSSite" that we received from Jonathan Fisk when he was with ESRI-Charlotte. Also, there is a document that we made with notes on what had to be done. The notes are far from complete but maybe will get you started. It has been so long that I couldn't provide any more details - I just remember floundering around until it worked.

Let me know how it goes.

Carmen