WareValley

Orange Ade

Comprehensive Database Management Solution

Orange is a database development and management solution that simplifies database management tasks and accelerates development to enhance productivity.

Boosting Development Productivity

It offers a wide range of tools and practical convenience functions for database development. Shorten the overall work cycle – design, development, debugging, and tuning – to meet business requirements and create a more efficient work environment.

A single program that supports multiple DBMS simultaneously

Supports JDBC access as well as ODBC

Orange Ade 3.0

ODBC and JDBC Access Support

Supports access via JDBC as well as ODBC

Schema Browser

Organizes and represents object information from a database in a tree structure for each user

SQL Tool

Can perform batch or sequential executions of multiple SQL statements, selective executions of specific SQL, and includes a function to directly modify the execution results through edit mode execution

Various execution options of different SQLs
Workspace functions
Functions that save, load, and execute in SQL
Function that displays and sorts SQL outputs in GRID, Text, and Excel format files
SQL Formatter
Fetch as Need function
Autocomplete function (except for Hive)
Syntax Highlight function
A variety of convenient editing functions
Functions that convert SQL to Visual Basic, Power Builder, C/C++, Java Delphi, Perl, and PHP code, and vice versa
SQL History function. Provides cached SQL and named script

Table Editor

It provides editing (Insert, Update, Delete) of table data and conditional inquiry and storage of some data. The changed grid cells are color-coded according to their respective change types, making commit or rollback operations intuitive and convenient.

Description Tool

Provides detailed information about the database object (object creation script, default properties, column, index information, trigger information, etc.)

Database Information

Provides database preference information to check various operating information and parameter operating environment of the database

Query Builder

Creates and edits SQL statements by adding objects and setting relationships between objects using only mouse operations in the GUI environment

Load Tool / Unload Tool

Downloads data to a file in various formats such as TXT, CSV, XLS, XLSX, JSON, LDRD, etc. by selecting a table or writing a query, or stores data in a table from an external file

Operating Environment

Windows 7/8/8.1/10/11 Windows Server 2012/2016e

Supported Environments (DBMS)

Oracle 11.2 or above Tibero 5 or above Altibase 6 or above IBM DB2 10.5 or above SQL Server 2012 sp3 or above Cubrid 8.2 or above PostgreSQL 9.5 or above Greenplum 5 or above PPAS 9.5 or above Teradata 16 or above SAP HANA 2 or above SunDB 2 Apache hive