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 Classic, if your database does not exist, then TimesTen Classic creates the database with the specified connection attributes when the instance administrator connects to the database.

In TimesTen Scaleout, you create and open the database before applications can connect to the database. See Managing a Database in the Oracle TimesTen In-Memory Database Scaleout User's Guide.

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 Using ttIsql in Batch Mode or Interactive Mode.

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 Classic

• Defining Client and Server DSNs

• Resolution Path for a DSN

• DSN Examples for TimesTen Classic

• odbc.ini File Entry Descriptions

• Connecting to a Database Using a Connection String