Massimo, the connection between Peoplesoft and SAP is not obvious to me, probably because I'm ignorant. Would it be possible to develop a DAL interface to SAP's database in the future? How difficult would it be to do that? Would it be easier if web2py drives a subset of SAP but still a complete web2py SQL functionality?
I'm groping a bit, here, but maybe you and DenesL can help me to understand how to look at the picture of how web2py works or could work with SAP? Denes, I believe even SAP B1 is expensive for a lot of startups, especially in manufacturing where you want many people in the company licensed to run modules. I'm thinking the RESTful APIs to SAP apps may be the way to go for system integration. Denes, can you shed light on which SAP modules have RESTful APIs? A quick search turned up Polestar, but I don't really know what it does as I didn't run across it in my skim of their ERP docs. Reading/writing SAP db directly and doing a "Vulcan-mindmeld=True" with an existing DB using web2py's migrate=False could be useful for deep integrations with custom SAP apps. As for doing a migrate=False with a standard SAP app, that would probably depend on whether SAP would legally let you do that or not, I suppose. Anyway, assuming SAP and web2py coexist, is budget the balance point between doing things light, reliably, and on the cheap in web2py vs. paying more money for "heavily and expensively" supported SAP? I mean, what's to say you couldn't have an open-sourced web2py app for invoicing? Or inventory and shipping? Or sales? Or purchasing? Or even payroll? Not that I'm volunteering or anything ;^) Richard On Oct 6, 11:20 pm, mdipierro <[email protected]> wrote: > On the specific issue of SAP. I do know SAP but I have been working > recently with some peoplesoft tables. The problem for me was not > reading them (they had an ID). The problem was that I could not find a > good description of what the tables are, how they are linked and what > the field mean. > > Peoplesoft is like a wiki (like the one in my example). It never > deletes a record but each record as an expiration date. When you edit > a record, it expires and the a new one (copy of the former) is created > with expiration in the future (2999-1-1). For this reason it does not > use the record ID for reference but some other unique field. > > I'd be curious is peoplesoft has a similar mechanism. > > Massimo > > On Oct 6, 10:10 pm, DenesL <[email protected]> wrote: > > > > > SAP products range from the small business oriented Business One (B1) > > with a few users to the corporate Business Suite (ex R/3) with > > hundreds of them. B1 could be an appropriate solution for this > > company. > > > My RFC proposal for legacy tables (in the developers forum) is geared > > towards interfacing with such ERP systems (SAP being one of them), > > since their tables do not have an autoincrement ID field as required > > by web2py, but so far it has not had any comments.- Hide quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
