Home > SQL Developer: TimesTen Tasks > Create a New TimesTen Conne...
To create a named connection to a TimesTen database, right-click the Connections node and select New Connection.
The New/Select Database Connection dialog appears. Choose the TimesTen tab. You are ready to enter information for the connection.
In the Connection Name field, type the connection name.
In the Username field, type the TimesTen user. If you use the TimesTen database to cache data from an Oracle database, type the TimesTen cache manager user name.
In the Password field, type the password for the TimesTen user.
To save the password, choose Save Password. If you save the password, the Connection Information dialog does not appear on subsequent connections to the TimesTen database.
If you use the TimesTen database to cache data from an Oracle database, in the Oracle Password (for Cache) field, type the Oracle password for the Oracle user. The Oracle user must be the same name as the TimesTen user you specified in the Username field.
Otherwise, leave this field blank.
For DSN, select a predefined DSN that references the TimesTen database. You can select either a Data Manager DSN to establish a direct connection or a client DSN to establish a client/server connection.
If you select User specified, then choose either Client/server to establish a client/server connection or Direct driver to establish a direct connection.
For information about configuring a client/server connection to a TimesTen database, see "Configuring TimesTen Client and Server" in the Oracle TimesTen In-Memory Database Operations Guide.
In the Connection string field, if you selected User specified for the DSN, specify a connection string to define the DSN and set attributes for the DSN. Each attribute setting must be separated by a semicolon. Do not delimit the connection string with a pair of double quotation marks.
For information about the format and contents of a connection string, see "Connecting to a database using a connection string" in the Oracle TimesTen In-Memory Database Operations Guide.
Click Save to save the connection name under the Connections node so that you can establish connections to the database using the settings in the named connection without having to specify the values in the fields of the New/Select Database Connection dialog box again.
Click Connect.
Related Topics