Oracle SQL Developer is a graphical tool that enhances productivity and simplifies development tasks for database application developers.
Using SQL Developer, TimesTen database users can browse, create, and edit database objects and PL/SQL subprograms; perform cache group operations; manipulate and export data; execute SQL and PL/SQL statements and scripts; and view and create reports.
SQL Developer provides a tree-based object browser. Navigation to database connections and
objects are visually intuitive with tabbed display of details specific to each object type. SQL
Developer complements the TimesTen ttIsql command line utility, by simplifying the
development tasks using a graphical user interface.
SQL Developer simplifies the tasks required to configure and create TimesTen tables to cache Oracle database tables. Cache group creation is made easy by browsing the Oracle database schema and selecting the appropriate tables and columns to cache. The column definitions and the relationships between the cache tables are automatically inherited from the Oracle database. Working with cache tables, and setting data aging policies and cache refresh intervals are intuitive and customizable in SQL Developer.
SQL Developer makes use of the TimesTen JDBC driver for connections to the TimesTen databases, supporting both direct-linked (in-process) 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.
Download the latest SQL Developer here.
Flash Demo 1
This demo shows how to use SQL Developer to connect and access your TimesTen database
Flash Demo 2
This demo shows how to create cache groups to cache Oracle tables into a TimesTen database, and how to populate data from the Oracle tables into the cache tables.
Flash Demo 3
This demo shows how to access the cache data in a TimesTen cache group, and observe the automatic data synchronization between the Oracle database and the cache tables inside the TimesTen database.
For the latest update of TimesTen SQL Developer release and functionality, please visit the TimesTen SQL Developer site.