asp/sql server stored procedures/j.d.edwards linking

Hi,

I have been given an assignment of pulling data from j.d.edwards tables to display through asp pages. The problem is that you can only pretty much do SELECT statements directly from jde...i need to do some calculations and formatting, hence the need for the sql server/stored procedures. Has anyone done any work this type transactions.

Im thinking
1)call stored procedure from asp page with search parameters
2)procedure pulls from jde and puts in temp table?

how does it get back to the asp page/table for display?

Any ideas/suggestions would be helpful.

It all depends what this [ entails. If it means that you need to do rollups, slice and dice it a different way and such, then a intemediate step of dumping the data into SQL server makes sence, afterwhich you run stored procedures which manipulate the data, and then pull it into a web display.
In this case, you could think about using DTS and schedule the import into SQL, if your data does not need to be 100% real time.

If the records you pull from JD are pretty much set, but you need to calculate little things without doing much with the recordset, ADO/ASP will suffice.

So it depends on your requirements.

If you post a little bit more of your requirements, we could better assist you.