To create a named connection to a TimesTen database, right-click the Connections node and select New Connection.
In the New/Select Database Connection dialog box, click the TimesTen tab and fill in the fields by specifying:
A connection name in the Connection Name field
A TimesTen user name in the Username field. If the TimesTen database will be used to cache data from an Oracle database, specify the TimesTen cache manager user name (or the internal TimesTen user whose ID is identical to the Oracle schema user for TimesTen 7.0) in the Username field.
The password for the user specified within the Username field in the Password field
If the TimesTen database will be used to cache data from an Oracle database, specify the password of the Oracle user in the Oracle Password (for Cache) field. The Oracle user has the same name as the TimesTen user that was specified in the Username field.
Otherwise, leave this field blank.
In the DSN pull-down menu, select a predefined DSN that references the TimesTen database that you want to connect to. 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 selected User specified in the DSN pull-down menu, select either the Client/server button to establish a client/server connection or the Direct driver
In the Connection string field, specify a connection string to set DSN attributes if you selected User specified in the DSN pull-down menu. If you selected a predefined DSN in the DSN pull-down menu, you can specify a connection string in the Connection string field to override any attribute settings in the DSN.
Click the Save button to save the connection name under the Connections node so that you can establish a connection 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 the Connect button to connect to the TimesTen database.
Related Topics