Highlighted

What technology to use????

Avatar

15-09-2008

I am looking to replace crystal reports in a large application. The back end is an Oracle 11g Database. I have been playing around with LifeCycle ES and got a oledb based form/report to work, but it required that a dataconnection with account/password be set up on the client machine, and a fair amount of javascript to fetch

and display the rows of data (opening connection, fetching through each row, moving data items from record

into local variables, moving from local variables into subform fields, etc., etc.).

I figure there has to be a better approach given all the tools and products adobe has. I have spent several days examining lots of manuals from various adobe products, but I haven't found a clear answer. What technology is best at Having a repository of pre-formed reports that can be called-up via a web browser, connecting to an

Oracle database back-end. The data for the reports will vary based upon the users application login_id, and

report requested, but the only direct connection to the database needs to remain behind the data center's firewall. (ie. link between database server and webserver and/or report server).

Replies

Highlighted

Avatar

17-09-2008

Chuck,

Your best bet is Adobe LiveCycle ES. It is an entire set of J2EE server-based products for PDF generation and manipulation. As you have noticed, the DB connection from the form is not really an "Enterprise-worthy" solution. In your case, I would envision the following solution:



- Design a form to display all of the data (sounds like you have already done this)

- Design an XML schema to store the data. This schema should be bound to your form

- Implement one or more "workflows" or "process orchestrations" in LiveCycle ES. You would most likely have one for each separate report. The process orchestration would have some "inputs" (the user's login_id) and "outputs" (the generated report). LiveCycle ES could take the login_id, perform the necessary query against the Oracle database, repackage the data as XML, and merge this data into the PDF form. The PDF form would then be returned from this process as an output.

- The process orchestration could then be initiated in a couple of ways from your web application. If it is implemented in .NET, you could invoke it as a SOAP web service call. If your application is written in Java, it could be invoked as a Java or SOAP web service.



I know this is a brief synopsis, but hopefully it gives you a good idea of what LiveCycle can do.



Justin Klei

Cardinal Solutions Group
Highlighted

Avatar

18-09-2008

Hi Justin,

Thanks for the response. When you refer to using LiveCycle ES to do the dbms query/repackaging etc. which LiveCycle product are you

referring to? LiveCycle Dataservices? LiveCycle Process Management? LiveCycle Output ES? LiveCycle PDF Generator? This is where I got lost trying to wade through all the various products.



thanks for your help!



chuck
Highlighted

Avatar

19-09-2008

Chuck,

The LiveCycle component that connects to a database is available as part of the foundation layer of LiveCycle. This means you get that functionality if you purchase any one of the LiveCycle Solution Components (Forms, Output, PDF Generator, Process Management, Reader Extensions, Rights Management). You get quite a bit of functionality with the foundation layer, including "connectors" for LDAP, Email, FTP, EJB, JMS, and Web Services.





Justin

Cardinal Solutions Group

www.cardinalsolutions.com