Connecting to TimesTen with ODBC and JDBC Drivers

An application can use different interfaces and drivers to access the TimesTen database.

Figure 1-1 Application Access to TimesTen Database Diagram

Description of Figure 1-1 follows
Description of "Figure 1-1 Application Access to TimesTen Database Diagram"

  • Open source languages interact with TimesTen through the Oracle Database Programming Interface for C (ODPI-C). The languages currently supported are Python and Node.js. See Getting Started in the Oracle TimesTen In-Memory Database Open Source Languages Support Guide.

  • C applications interact with TimesTen by linking with a TimesTen direct or client/server driver, by linking with the TimesTen driver manager, by linking with a generic driver manager, or by using the OCI or Pro*C/C++ APIs that indirectly access the TimesTen ODBC driver.

  • Java applications interact with TimesTen by using the TimesTen JDBC driver.

  • C++ applications can interact with TimesTen directly through ODBC, through a TimesTen-provided set of classes called TTClasses or by using the OCI or Pro*C/C++ interfaces that indirectly access the TimesTen ODBC drivers.

  • C# applications interact with TimesTen through Oracle Data Provider for .NET support for the TimesTen database.

All of these interfaces ultimately use the TimesTen ODBC driver to access a TimesTen database. These interfaces can use the TimesTen ODBC direct driver, the TimesTen ODBC client driver, the TimesTen driver manager, or a generic ODBC driver manager. See TimesTen Connection Options in the Oracle TimesTen In-Memory Database Introduction.

The following sections describe how to define TimesTen databases: