User's Guide

Do you need full integration of D³ and Oracle?
D³ Oracle Gateway is the solution.

D³ Oracle Gateway is a member of the Open System File Interface (OSFI) family of products. It allows D³ to read, write and select Oracle databases as if they were part of the D³ file system. D³ sees the Oracle database as D³ accounts, files and items. This driver creates a transparent transport mechanism between D³ and Oracle. Accessing Oracle data becomes as easy as accessing D³ data.

The D³ 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 D³ Oracle Gateway also supports row level locking. This allows Pick programmers to write BASIC code against any Oracle database as if it were D³ files. Oracle databases and tables are defined through super Q-Pointers. This allows the use of any D³ technologies to get to Oracle. Run Access Query Language (AQL) against Oracle tables instead of Standard Query Language (SQL) or Open, Read and Write Oracle tables and items from BASIC using standard Pick/BASIC instructions.

The D³ Oracle Gateway is compatible with Oracle versions 7.3, 8.0, 8i and 9i.

For more information on D³ Oracle Gateway, please send an e-mail to connectivity@rainingdata.com.