Re: [flexcoders] Flex, SharePoint and SQLServer
- Original Message - From: Tracy Spratt To: flexcoders@yahoogroups.com Sent: Sunday, April 05, 2009 5:01 AM Subject: RE: [flexcoders] Flex, SharePoint and SQLServer snip Flex can't really talk directly to a database. Supposedly, the later SQL Server versions support native http access. If that really works, scalably and securely, then you could use HTTPService in Flex to communicate with the db. I have not tried this, nor have I heard any success stories about that approach. You'd really have to handle that with care on anything but (perhaps) an intranet - a swf decompiler could expose your DB innards and security.. snip Tracy Spratt, Lariat Services, development services available -- From: flexcoders@yahoogroups.com [mailto:flexcod...@yahoogroups.com] On Behalf Of Mic Sent: Saturday, April 04, 2009 11:39 PM To: flexcoders@yahoogroups.com Subject: [flexcoders] Flex, SharePoint and SQLServer 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.
Re: [flexcoders] Flex, SharePoint and SQLServer
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 : > 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 > > > >
RE: [flexcoders] Flex, SharePoint and SQLServer
After using Flex for client UIs for a few years, the old submit, postback, hidden fields, javascript, dhtml, and even that data object thing you can use in .net, seems hideous. I use .net for all my back-end business logic database an integration tier work, and like it just fine for that. Now, Flex can't really talk directly to a database. Supposedly, the later SQL Server versions support native http access. If that really works, scalably and securely, then you could use HTTPService in Flex to communicate with the db. I have not tried this, nor have I heard any success stories about that approach. Flex's main lines of communication are HTTPService(XML over http), SOAP-based WebService, and RemoteObject(AMF). Then there are the server-side services like LCDS, BlazeDS, WebOrb, and others. What communication options does Sharepoint provide? Tracy Spratt, Lariat Services, development services available _ From: flexcoders@yahoogroups.com [mailto:flexcod...@yahoogroups.com] On Behalf Of Mic Sent: Saturday, April 04, 2009 11:39 PM To: flexcoders@yahoogroups.com Subject: [flexcoders] Flex, SharePoint and SQLServer 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.