1 Connecting to a TimesTen Database

A TimesTen database is a collection of objects such as tables, views, and sequences. You can access and manipulate the TimesTen database through SQL statements after connecting to the database.

In TimesTen, if your database does not exist, then TimesTen creates the database with the specified connection attributes when the instance administrator connects to the database.

Once you have created a database, you can perform the following:

• Run an application that uses the database.

• Use the ttIsql utility to connect to the database and run a SQL file or start an interactive SQL session. See About Using ttIsql in Interactive or Batch Mode in the Oracle TimesTen In-Memory Database ttIsql User's and Reference Guide.

This chapter describes how to configure to connect to the TimesTen database. The connection attributes include management configuration details for your TimesTen database.

• Connecting to TimesTen with ODBC and JDBC Drivers

• Specifying Data Source Names to Identify TimesTen Databases

• Creating a DSN on Linux and UNIX for TimesTen

• Defining Client and Server DSNs

• Resolution Path for a DSN

• DSN Examples for TimesTen

• odbc.ini File Entry Descriptions

• Connecting to a Database Using a Connection String