D3 Oracle Gateway is a member of the Open System File Interface (OSFI) family of products. It allows D3 to read, write and select Oracle databases as if they were part of the D3 file system. D3 sees Oracle databases as D3 accounts, files and items. This driver creates a transparent transport mechanism between D3 and Oracle. Accessing Oracle data becomes as easy as accessing D3 data.
The D3 Oracle Gateway uses the standard Oracle Data Access API called Oracle Connectivity Interface (OCI). For this reason, performance is optimal; there is no need for any extra communication layers such as ODBC. The D3 Oracle Gateway also supports row level locking. This allows developers to write BASIC code against any Oracle database as if it were D3 files. Oracle databases and tables are defined through super Q-Pointers. This allows the use of any D3 methods of accessing data to get to Oracle. Run Access Query Language (AQL) against Oracle tables or open, read and write Oracle tables and items from BASIC using standard Pick/BASIC instructions.
The D3 Oracle Gateway is compatible with Oracle versions 7.3, 8.0, 8i, 9i, 10g and 11.