Accessing ArcGIS Online data for reporting

[GordonSumerling]

I am putting together an ArcGIS Online project. I have a requirement to capture data in the field on Smart Devices. This is acheived in ArcGIS online OK with ArcGIS online hosting my feature services.
Then using the data captured I then need to
1) perform some calculations on the captured data to produce costings
2) prerform reporting based on the data captured and who captured it.

In the ArcGIS Server environment I would capture this data direct to a SQL Server database and then perform SQL server reporting to do my calculations.

From what I can see this is not possible in ArcGIS Online and I cannot get the data back easily to my corporate environment. Perhaps the only methods I can see that will work is either;
1) Open a port inside the office and have ArcGIS online read the GIS Services directly, or
2) Create an Amazon cloud and have ArcGIS online consume the services from there and then perform my reporting on the Amazon cloud.

Any thoughts on this will be appreciated.

Regards
Gordon

[MikeMinami]

You can export a shapefile of the data from the item. Click the arrow next to the layer name on the item details page.

Thanks,

Mike

[DominicRoberge]

Hey Gordon

I found your post from 2012... I was wondering if you ever found a solution to your problem. I am trying to achieve the same type of project (Using ArcGIS Online (hosting the data), mobile devices to capture/maintain the data, then using MS Report Services to generate reports).

Any information you could provide would be much appreciated.

Thanks!

D

[PaulRoss]

Hi, boy that's an old post ... couple things that might help you:

Collector - to collect the data

Collector for ArcGIS | ArcGIS

GeoForm template - to collect data that's more data centric than map centric

http://www.arcgis.com/home/item.html?id=931653256fd24301a84fc77955914a82

and to do the calculations how about the new feature we added a few weeks ago to calculate a field:

Work with fields—Help | ArcGIS

Hope this helps,

-Paul-

[GordonSumerling]

Hello D,

The solution we came up with was to host the web services on an Amazon Cloud Server, then consume the services on ArcGIS Online. This allowed us the freedom to synchronise between the corporate gdb and the cloud gdb and then have field collection managed by ArcGIS online. We could then do all the reporting and calculations we needed.

regards

Gordon

[DominicRoberge]

Thanks Gordon for your input

yeah we have the ArcGIS Online and data collecting going no problem... I am just trying to get some dynamic reports (using MS Report Services) from some feature layers out of ArcGIS Online

Amazon Cloud will not be an option for us...

Have a great day!

D