Flash Remoting - To use or Not - Retrieving data - Options?

[baden]

I need to retrieve DB2 data stored on an iSeries/AS400 and display it in Flash.

Options:

iSeries -> FTP to Flash Server -> Flash reads file and updates display
· XML - 3 types: Tag Form; Attribute Form; WebSphere Imort
· CSV


iSeries <-> JDBC <-> Java -> Flash
· JDBC connection made to the iSeries; ERP data pulled through SQL/JDBC
· Retrieved data formatted to a Flash readable data format (XML, CSV, comma-delimited, project-specific)
· Flash retrieves and displays data

iSeries <-> JDBC <-> Java <->Flash Remoting
· JDBC connection made to the iSeries; ERP data pulled through SQL/JDBC
· J2EE server hosting a Java Servlet (gateway) for Flash Remoting


iSeries: Java gateway <-> Flash Remoting
· Java Servlet gateway (J2EE Server) running on iSeries Java J2EE server
· Flash MX Player handles serializing and deserializing ActionScript objects to and from Action Message Format (AMF) (proprietary binary data)


Installing remoting would isn't exactly optiomal for the time-frame we have for this. Can anyone share any recommendations?

 

[baden]

The 1st method (Flash reading CSV's) seems most simplest. Can Flash detect file changes?

 

[pixl8r]

I would personally use option 2 I think. XML is probably best, the only thing is if you need it to constantly update you are going to have to code a timer of some sort so it updates every so often (with XML, CSV, or others). Otherwise it will cache after the first load.

Hope it helps.



Wow JT that almost looked like you knew what you were doing!