One Network Platform is tightly integrated with the Oracle database. Most data definition tasks are handled automatically based on the models you create within your module. Still other features, such as reports and SqlDefs leverage the power of SQL. Finally, there are easily foreseeable scenarios where you might want to tweak or even change the structure or configuration of the schema generated by the SDK tools. Studio supports tools to deal with all these scenarios.
Oracle is the only supported database platform. While under the hood, Platform uses database-agnostic technologies like JDBC and Hibernate, One Network Platform does leverage Oracle-specific SQL enhancements to manage performance and scalability.
- Browsing the Database with SQL Explorer
- Configuring the JDBC Driver
- Setting up a Connection to your Oracle Instance
- Connecting to the Database
- Browsing the Database Structure
- Browsing the Data
- Querying the Database
- Using Oracle's EXPLAIN Profiler
- Saving a Query
- Committing Your Work
- Modifying the Generated Database Structure
- Generating the DDL for your Instance's Database
- Generating Update _ Diff DDL
- Loading Test Data into the Database