Forum OpenACS Q&A: Response to SAP DB?

Collapse
4: Response to SAP DB? (response to 1)
Posted by Kapil Thangavelu on

i've been experimenting with sapdb recently and asking questions on the sapdb mailint list, here's a quick summary of my thoughts.

  • its designed for 24x7
  • it has around a thousand run time config options
  • its a pain to compile (uses old c++ compiler for bin compatiblity, custom make system build environment)
  • the exposed python/perl interfaces make writing admin scripts fairly easy.
  • triggers seem slightly non standard in execution behavior and somewhat limited (no before triggers)
  • the procedural language is nice, reminds me of a downsized pl/sql, there seem to be plans for java stored procs at a later date. the procedural language includes cursor support, exception handling, (in|out|in/out) var args, transaction control.
  • nice usage docs, skimy dev docs.

more importantly from an acs point of view, it doesn't currently (7.308) support stored procs calling other stored procs. so it looks like a non starter till this is done.