ODBC allows communication between an external application and the DBMS of the database.
ODBC is a standard created by Microsoft within WOSA (Windows Open Services Architecture) which allows applications to access data in any database that supports ODBC.
Standard SQL is used in this case, so that portable applications can be written. The conversion of the ODBC calls into the query language of the database is done by the ODBC Database Driver.
Preconditions for use of ODBC:
Application must be ODBC-capable, for example MS Word 8, MS Word 6 with additional kit.
all databases delivered with R/3 support ODBC. Contact your database producer for the ODBC driver reference.
* ODBC communication is carried out on R/3. *
You should take the following points into consideration to do this:
- Integrity of the database
All the processing logic of R/3 is by-passed, for example, input check, number range concept (consistency) and also the R/3 transaction concept (integrity). We would strongly recommend therefore, that you only perform read and *not write* accesses to tables.
We cannot provide support for a database/system destroyed by write accesses.
- R/3 authorization concept
The logon is effected directly to the database, with a database user. Likewise, when accessing tables, no R/3 authorization checks are carried out.
- Table buffering
Tables are partly buffered for performance reasons. You cannot read from these buffers with read accesses via ODBC, that is, you may not be working on the most current data.
- Pool/cluster tables
cannot be read with ODBC, only transparent tables.
Documentation on Windows platforms:
+ Application help files
You can also read more about SAP BASIS