1. could work, because you can use Flex to get the data via SharePoint's HTTP APIs. May make it difficult to query; not sure what options are available in the SharePoint API.
2. You would need some kind of service in between to mediate, i.e. to provide a HTTP API to SQL Server. Either something custom written in ASP.NET (or whatever other web server tech you have on site), or maybe ADO.NET Data Services (the HTTP API for SQL Server hinted at by Tracy)? There may be an advantage in terms of performance if you use AMF through things like WebORB, or if Java is an option, BlazeDS or LiveCycle. 2009/4/5 Mic <[email protected]>: > Just got introduced to the wonderful world of SharePoint recently, and am > contemplating coding the client's BI application in Flex and then embedding > into SharePoint. Are people doing this? All the data must come from > SQLServer2005. Done some googling and understand that I could > > 1. Load data into SharePoint lists and then send to Flex > 2. Talk to 2005 directly from Flex. > > Is this correct and which is the better approach? > > Are there any examples of this kind of architecture? I did not really find > much after a couple of hours of googling. > > I have looked at ASP.NET and VisualStudio etc and just feel I could do a > better job with Flex. Don't want to infer Flex is superior, but I do know > that I can write the app they need in Flex. Is this a sensible approach? > Thanks in advance for any pointers, > > Mic. > > > > > > ------------------------------------ > > -- > Flexcoders Mailing List > FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt > Alternative FAQ location: > https://share.acrobat.com/adc/document.do?docid=942dbdc8-e469-446f-b4cf-1e62079f6847 > Search Archives: > http://www.mail-archive.com/flexcoders%40yahoogroups.comYahoo! Groups Links > > > >
