C O N N E C T I V I T Y
OpenDB

User's Manual

Open D³ to any ODBC-compliant RDBMS.

OpenDB is part of the OSFI (Open System File Interface) family of products. It allows D³ to connect to ODBC-compliant databases. Once the connection is established between D³ and the remote database server, D³ is able to read, write and select data from the remote RDBMS as if it is a D³ file. All standard D³ methods of accessing data can be used (i.e.: TCL, BASIC). As far as the D³ user/developer is concerned, the remote RDBMS is just another D³ file with D³ items. The integration of the two systems is totally transparent.

The table below illustrates the integration with an ODBC-compliant RDBMS database:

How does it work?

The RDBMS must be ODBC-compliant and must support a Windows ODBC driver. This ODBC driver is used to create the link between the Microsoft ODBC Manager and the Remote RDBMS. The OpenDB Driver is installed on the server with the ODBC Manager. D³ talks to this ODBC client through Super Q-pointers.

The link is made through the Microsoft ODBC Manager. The diagram below illustrates the setup. Notice that the ODBC Bridge can be installed on the D³ server if it is a Windows environment (D³ NT) or on the remote database server if the latter is a Windows based RDBMS. If D³ and the remote RDBMS servers are both UNIX based, a Microsoft Windows server needs to be present somewhere on the network to serve as the ODBC Bridge.

If the remote RDBMS is Oracle, for improved performance it is recommended to use the D³ Oracle Gateway product instead.

For more information on OpenDB, please send an e-mail to connectivity@tigerlogic.com.