Differences between revisions 5 and 10 (spanning 5 versions)
Revision 5 as of 2005-10-10 06:14:20
Size: 228
Editor: 62
Comment:
Revision 10 as of 2008-12-08 13:09:57
Size: 2368
Comment:
Deletions are marked like this. Additions are marked like this.
Line 1: Line 1:
The Best monitor Directory on the Web #pragma section-numbers off
Line 3: Line 3:
http://www.monitordirectory.vip.su = SAP DB (MaxDB) =
Line 5: Line 5:
Monitor Directory has delivered to the market scores of standard and custom products and software solutions.   URL for 7.6 and later:: http://www.sdn.sap.com/irj/sdn/maxdb
  URL for 7.5:: (was http://www.mysql.org/products/maxdb/, but is no longer available)
  URL for 7.3 and 7.4:: http://www.sapdb.org/
  licence:: 7.3 and 7.4 (GPL + LGPL), 7.5 (GPL), 7.6 and later (Commercial and free community edition)
  platforms:: Linux/i386, Solaris, HP-UX, AIX, Dec, Windows
Line 7: Line 11:
http://www.monitordirectory.vip.su ----

== DB API 2.0 Drivers ==

=== sdb.dbapi ===

  URL:: http://maxdb.sap.com/doc/7_7/46/71b2a516ae0284e10000000a1553f6/frameset.htm
  licence:: (?) SAP now releases MaxDB for free, but no longer as open-source software
  platforms:: see SAP DB
  Python versions::

=== sapdbapi ===

  URL:: http://www.sapdb.org/sap_db_program.htm
  licence:: LGPL
  platforms:: see SAP DB
  Python versions:: 1.5.2 - 2.2

This is for the older SAP DB releases 7.3 and 7.4.

=== mxODBC ===

  URL:: http://www.egenix.com/products/python/mxODBC/
  Licence:: eGenix.com Commercial License
  Platforms:: Windows, Linux, MacOS X, FreeBSD, Solaris, AIX
  Python versions:: 2.1 - 2.6

SAP DB's native CLI is ODBC compatible and mxODBC can link directly against these libraries on Unix. It also supports the SAPDB ODBC driver on Windows.

Supports all SAP DB versions.

== Other Drivers ==

=== sdb.sql ===

  URL:: http://maxdb.sap.com/doc/7_7/46/71b2a516ae0284e10000000a1553f6/frameset.htm
  licence:: (?) SAP now releases MaxDB for free, but no longer as open-source software
  platforms:: see SAP DB
  Python versions::

=== sapdb ===

  URL:: http://www.sapdb.org/sap_db_program.htm
  licence:: LGPL
  platforms:: see SAP DB
  Python versions:: 1.5.2 - 2.2

This is for the older SAP DB releases 7.3 and 7.4.

==== Programming Model ====

{{{
cursor = session.sql ("select * from messages")
for msgno, lang, text in cursor:
    print msgno, text

insert = session.prepare ("insert into sometable values (?, ?)")
print insert.getDescription ()
insert.execute (["string", 1])

select = session.prepare ("select * from messages where msgno < :msgno")
cursor = select.execute ([200])
print cursor.next ()
print cursor.relative (100)
print cursor.absolute (4)
print cursor.absolute (-4)
}}}

----

== Supported Python Applications ==

 * a sapdb driver exists for [[PyDO]] (Python Data Objects)

SAP DB (MaxDB)

URL for 7.6 and later

http://www.sdn.sap.com/irj/sdn/maxdb

URL for 7.5

(was http://www.mysql.org/products/maxdb/, but is no longer available)

URL for 7.3 and 7.4

http://www.sapdb.org/

licence
7.3 and 7.4 (GPL + LGPL), 7.5 (GPL), 7.6 and later (Commercial and free community edition)
platforms
Linux/i386, Solaris, HP-UX, AIX, Dec, Windows


DB API 2.0 Drivers

sdb.dbapi

URL

http://maxdb.sap.com/doc/7_7/46/71b2a516ae0284e10000000a1553f6/frameset.htm

licence
(?) SAP now releases MaxDB for free, but no longer as open-source software
platforms
see SAP DB
Python versions

sapdbapi

URL

http://www.sapdb.org/sap_db_program.htm

licence
LGPL
platforms
see SAP DB
Python versions
1.5.2 - 2.2

This is for the older SAP DB releases 7.3 and 7.4.

mxODBC

URL

http://www.egenix.com/products/python/mxODBC/

Licence
eGenix.com Commercial License
Platforms
Windows, Linux, MacOS X, FreeBSD, Solaris, AIX
Python versions
2.1 - 2.6

SAP DB's native CLI is ODBC compatible and mxODBC can link directly against these libraries on Unix. It also supports the SAPDB ODBC driver on Windows.

Supports all SAP DB versions.

Other Drivers

sdb.sql

URL

http://maxdb.sap.com/doc/7_7/46/71b2a516ae0284e10000000a1553f6/frameset.htm

licence
(?) SAP now releases MaxDB for free, but no longer as open-source software
platforms
see SAP DB
Python versions

sapdb

URL

http://www.sapdb.org/sap_db_program.htm

licence
LGPL
platforms
see SAP DB
Python versions
1.5.2 - 2.2

This is for the older SAP DB releases 7.3 and 7.4.

Programming Model

cursor = session.sql ("select * from messages")
for msgno, lang, text in cursor:
    print msgno, text

insert = session.prepare ("insert into sometable values (?, ?)")
print insert.getDescription ()
insert.execute (["string", 1])

select = session.prepare ("select * from messages where msgno < :msgno")
cursor = select.execute ([200])
print cursor.next ()
print cursor.relative (100)
print cursor.absolute (4)
print cursor.absolute (-4)


Supported Python Applications

  • a sapdb driver exists for PyDO (Python Data Objects)

SAP DB (last edited 2013-08-11 12:31:35 by MarcAndreLemburg)

Unable to edit the page? See the FrontPage for instructions.