Home > SQL Developer: TimesTen Tasks > Create a New TimesTen Conne...
To create a named connection to a TimesTen database, make sure you are on the main SQL Developer page.
Right-click the Connections node and select New Connection.
Select the TimesTen tab.
You are ready to enter information for the connection.
In the Connection Name field, enter the connection name.
In the Username field, enter the TimesTen user. If you use the TimesTen database to cache data from an Oracle database, enter the TimesTen cache manager user name. If you use the TimesTen database to load data from an Oracle database, enter the TimesTen user name that has SELECT
privileges on the Oracle database tables that you want to load.
In the Password field, enter the password for the TimesTen user.
To save the password, choose Save Password. If you save the password, you will not be prompted for the password on subsequent connections to the TimesTen database.
To allow TimesTen to issue an implicit commit after DML statements, select the Autocommit check box. By default, the Autocommit check box is selected.
Select a connection type from the Connection Type drop-down list. The following types of connections are available:
You are now ready to define your new connection.
The DSN connection type allows you to connect to databases by specifying a DSN. The DSN must exist in your .ODBC.INI
on UNIX and the ODBC Data Source Administrator on Windows.
Note: For more information about defining DSNs, see "Specifying Data Source Names to identify TimesTen databases" in the Oracle TimesTen In-Memory Database Operations Guide. |
Select a predefined DSN that references the TimesTen database from the DSN drop-down list. You can select either a Data Manager DSN to establish a direct connection or a client DSN to establish a client/server connection.
In the Connection Attributes field, enter the attributes for the DSN. The Connection Attributes field is not required. Each attribute setting must be separated by a semicolon. If you do not specify any connection attributes, TimesTen uses the connection attributes specified in the DSN.
For more information about connection attributes, see "Connection Attributes" in the Oracle TimesTen In-Memory Database Reference.
To cache data from an Oracle database or load data from an Oracle database into a TimesTen database, select the Enable Cache/Load tables from Oracle database check box.
In the Oracle Database Password field, enter the Oracle database password for the Oracle database user. The Oracle database user must be the same user as the TimesTen user you specified in the Username field. This text field is only available if you selected the Enable Cache/Load tables from Oracle database check box.
Click Save to save the connection name under the Connections node.
Your connection is saved. 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.
SQL Developer is connected to your TimesTen database.
For more information about creating and managing database connections in SQL Developer, see the Oracle SQL Developer User's Guide.
The easy client/server connection type allows you to connect to local and remote databases without having to define a DSN.
In the Server Host Name field, enter the name or the IP address of the TimesTen server host.
In the Server DSN field, enter the DSN of the TimesTen server.
In the Server Port field, enter the TCP port of the TimesTen server. You can use the ttStatus
utility to find the TCP port of your TimesTen server.
In the following example, the server port number is 53396. This example is part of a sample output from the ttStatus
utility.
TimesTen server pid 24379 started on port 53396
For more information about the ttStatus
utility, see "ttStatus" in the Oracle TimesTen In-Memory Database Reference.
To cache data from an Oracle database or load data from an Oracle database into a TimesTen database, select the Enable Cache/Load tables from Oracle database check box.
In the Oracle Database Password field, enter the Oracle database password for the Oracle database user. The Oracle database user must be the same user as the TimesTen user you specified in the Username field. This text field is only available if you selected the Enable Cache/Load tables from Oracle database check box.
In the Oracle Net Service Name field, enter the Oracle database net service name for the Oracle database. This text field is only available if you selected the Enable Cache/Load tables from Oracle database check box.
Click Save to save the connection name under the Connections node.
Your connection is saved. 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.
SQL Developer is connected to your TimesTen database.
For more information about creating and managing database connections in SQL Developer, see the Oracle SQL Developer User's Guide.
The advanced connection type allows you to define a connection string to connect to your TimesTen database.
Select a driver type for the TimesTen database from the Driver Type option. Select either Client/server to establish a client/server connection or Direct to establish a direct connection.
In the Connection string field, enter a connection string to define the DSN and set attributes for the DSN. If you choose Client/Server as the Driver Type specify the server host, server port, and 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.
To cache data from an Oracle database or load data from an Oracle database into a TimesTen database, select the Enable Cache/Load tables from Oracle database check box.
In the Oracle Database Password field, enter the Oracle database password for the Oracle database user. The Oracle database user must be the same user as the TimesTen user you specified in the Username field. This text field is only available if you selected the Enable Cache/Load tables from Oracle database check box.
Click Save to save the connection name under the Connections node.
Your connection is saved. 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.
SQL Developer is connected to your TimesTen database.
For more information about creating and managing database connections in SQL Developer, see the Oracle SQL Developer User's Guide.
Related Topics