Oracle SQL Developer supports Oracle In-Memory Database Cache and Oracle TimesTen In-Memory Database. Using SQL Developer, users can connect to their TimesTen databases to browse, create, edit, and delete TimesTen database objects, run SQL statements and scripts, execute TimesTen built-in procedures and utilities, manipulate and export data, view and create reports. Oracle SQL Developer provides a graphical development tool that complements the TimesTen ttIsql command line tool. Product Datasheet

SQL Developer makes use of the TimesTen JDBC driver for connections to the TimesTen databases, supporting both direct-linked and client/server connections. Users can install Oracle SQL Developer on the same server where the TimesTen database resides or on a separate client machine.

SQL Developer provides a tree-based object browser. Navigation to database connections and supported objects are visually intuitive with tabbed display of details specific to each object type.  Users can create and test connections to multiple TimesTen databases and store frequently used connections.  From the connection navigator, users can browse, create, drop and modify the following TimesTen database objects: Tables, Views, Indexes, Sequences and Materialized Views.

Ability to view the properties and SQL definitions of TimesTen Replication schemes and Cache Groups are supported.

From the Data tab, users can view, sort, search and edit data in TimesTen tables, including tables that are replicated to another TimesTen node or tables that are cached from Oracle Database.  Data can also be exported to various formats, including INSERT statements, TimesTen ttBulkCp file format, CVS, text and XML.

SQL Worksheet is an editor that supports the execution of SQL statements for a given database connection. These statements can be run individually or consecutively.  Additionally, SQL scripts, TimesTen built-in procedures and selected ttIsql commands are also supported within the SQL Worksheet.  Commonly used SQL operations for Cache Group and Replication Schemes can be run within the SQL Worksheet, without having to launch a separate ttIsql session.

SQL Developer enables users to connect and view objects across multiple databases. TimesTen developers working on the cached tables from Oracle Database can manipulate data in both the TimesTen and Oracle databases.