3 Connecting to a TimesTen Database
You can connect to a TimesTen database after you install and start SQL Developer.
This chapter focuses on the steps necessary to connect to a TimesTen database in SQL Developer. Topics include:
Defining a TimesTen database named connection
Ensure that you are on the main SQL Developer page.
DSN
The DSN connection type allows you to connect to databases by specifying a DSN. The DSN must exist in your .odbc.ini
on Linux or UNIX and the ODBC Data Source Administrator on Windows. Before defining a DSN connection in SQL Developer, ensure that you have completed the steps up to step 7 from Defining a TimesTen database named connection.
Note:
For a TimesTen Scaleout database, use the ttGridAdmin gridClientExport
command to export every client DSN available for the grid into a flat file. Then, import the client DSNs into the TimesTen client system where SQL Developer is installed. For more information, see "Establishing client connections from a TimesTen Client" in the Oracle TimesTen In-Memory Database Scaleout User's
Guide.
Note:
For more information about defining DSNs for TimesTen databases, see "Specifying Data Source Names to identify TimesTen databases" in the Oracle TimesTen In-Memory Database Operations Guide.
Easy Client/Server
The easy client/server connection type allows you to connect to local and remote TimesTen databases without having to define a client DSN. Before defining an easy client/server connection in SQL Developer, ensure that you have completed the steps up to step 7 from Defining a TimesTen database named connection.
Note:
For a TimesTen Scaleout database, the Easy Client/Server connection enables you to connect to a single data instance. If the data instance is unreachable the connection fails, which makes the Easy/Client connection type suitable only for testing purposes.
Advanced
The advanced connection type allows you to define a connection string to connect to your TimesTen database. Before defining an advanced connection in SQL Developer, ensure that you have completed the steps up to step 7 from Defining a TimesTen database named connection.
Using an existing TimesTen database named connection
- Right-click the node of the connection name and select Connect, or click the + to the left of the connection name's node.
- If the Connection Information dialog appears, in the Username field, enter the TimesTen user name. In the Password field, enter the password for the user.
- Click OK.
After you connect to a TimesTen database, you can browse existing objects or create new objects such as tables, indexes, views, sequences, synonyms, PL/SQL packages, procedures and functions and so on. For information about creating database objects, see the Oracle SQL Developer User's Guide.