| Orbit Markup Language |
| · | The Orbit Markup Language (OML) is a scripting language designed for developing web applications. OML handles common programming tasks adding programmatic power to your web application without the complexity. It provides a powerful set of Token Modifiers and Token Functions for token manipulation, logic, assignment and formatting. |
|
| Token Replacement |
| · | Tokens are placeholders for the actual values that are replaced at run time. Generate dynamic pages using Tokens as replacement variables
(i.e. #token=RAW[#token#]#). |
|
| IDE |
100% browser interface, built-in development framework. Integrates seamlessly with Oracle Databases. |
| Easy Menu Navigation |
Hierarchical menu organization for easy navigation. Developer Tasks are categorized in folders that reveal subtopics related to that task. |
| Page Drilldown Navigation |
Navigate multiple, related Orbit Pages, Sections, Queries, and Tokens using the Orbit Drilldown Navigator. View the logical relationships between Orbit Pages, Sections and Queries organized into a tree menu structure. New and improved search filters allow you to narrow your results. |
| Frames vs. Non-Frames |
Switch between frames mode to non-frames mode giving users the flexibility to choose their work environment. |
| Perform Data Manipulation Tasks |
View, insert, update and delete single and multiple records. View summary information about many records at once, select specific criteria to narrow down your results. |
| Multiple Record Handling |
View, insert, update and delete multiple records at once. Mass Change maintenance screens use advanced search criteria to narrow results. Displays results in a friendly, easy to read format. |
| Text Search and Replace |
Improved Search and Replace features include highlighted text results and advanced searching capabilities using And / Or / Not logic. Search and replace source text, OML syntax, JavaScript, HTML, SQL code, including pages, sections, queries, and tokens. |
| Web API Package Generator |
| · | Supports Single/Multiple records, and Master Detail transactions |
| · | Transaction Management prevents multiple inserts |
| · | Integrated Security and User Session management |
| · | Seamless Error Handling |
| · | Implements: Save, New, Copy, Delete, Refresh |
| · | Automatic Foreign Key lookup |
| · | HTML Checkbox support |
| · | Date and Number format support |
| · | BLOB and CLOB support for File upload and large text |
|
| Table API Package Generator |
| · | Supports Single/Multiple records, and Master Detail transactions |
| · | Provides all insert/update/delete functionality for a table |
| · | Smart Updates: only update when changes are made |
| · | Enforces optimistic record level locking; Ensures record was not updated by another user |
| · | User Exit Hooks for customized business rules |
| · | Supports multiple procedure call formats; Individual Columns, PL/SQL Record, PL/SQL Table parameters |
| · | Uses unique Denormalized record layout; Unique keys in foreign key tables can be specified instead of primary keys (which are usually numeric) |
| · | BLOB and CLOB support for File upload and large text |
|
| User Exit Packages |
| · | Enforce Business Rules |
| · | Provide a centralized package for all
customized user code |
| · | Enhance the generated Table and Web API
packages from Orbit |
| · | Provide Before and After callouts for each
event such as Select / Insert / Update / Delete ( i.e.: Pre_Insert(), Post_Insert() ) |
|
| Public Package Generator |
| · | Public Packages contain Utility Functions for tables |
| · | Read only functions |
| · | Returns column values based on Primary or Unique Key |
| · | Returns Primary Key based on Unique Key |
| · | Functions are PRAGMA’ed for use in SQL Queries |
|
| Master-Detail package generation |
| · | Easily generate Master-Detail Forms and Reports support using the Package Generator utility |
|
| Source Code Control |
The Orbit Suite provides you with powerful tools for managing source code such as development snapshots, migration, archiving, code comparison reports, version control, and audit information. |
| Source Code Repository |
Source Code Repository for version control of all web content. All source code is stored in the Oracle database. |
| Engine Interpreter |
Enjoy Multi-language support and platform portability. Orbit runs on any operating system supported by Oracle (Windows/Unix/Linux). |
| Flexible Application Migration |
Supports the application development life cycle:
Development -> Test -> Production |
| Archive Tables |
Archive application versions into the archive tables. Restore archived versions from the archive tables to the live tables. |
| Impact Analysis |
Easily identify logical relationship between all web objects in your application for accurate impact analysis. |
| Manage Roles and User Access |
Easy granting of roles and access. Users can easily be granted Access Groups or user-specific access to pages and versions using wildcards. |
| Web Based Administration Controls |
Convenient and easy access to all administrative tasks. Perform database administrative tasks and more right on the browser. |
| Transaction Integrity |
Prevent user double-clicks, browser refreshes, and back button resubmits to avoid duplicate transaction processing. |
| Record Contention |
Prevent concurrent users from overwriting each other's changes. |
| User Access Groups |
Access Groups are fully supported for controlling front end and back end user access. |
| Package Access Control |
Manage PL/SQL package level access through either Access Groups or specific users. |
| Compare and Synchronize Applications |
Easily compare and synchronize Orbit applications between two databases right in the browser. Specify where and what criteria to synchronize and submit your request. Results follow hierarchical rules minimizing synchronization errors. |
| Compare and Synchronize Admin Tables |
Compare and synchronize user's access roles and permissions between 2 databases just by a simple click of a mouse. |
| View DBMS Jobs |
Display a list of current running DBMS jobs using Orbit's friendly report format. |
| Email Page functionality |
Email entire Orbit pages seamlessly. Orbit enables you to incorporate custom single or mass email funcionality to your application. |
| SQL Queries |
SQL queries are conveniently attached to sections and stored in the database. |
| Transaction Management |
User session management is stored in the database within Orbit's application framework. Stateless session management is seamless to end-users. |
| Concurrency Handling |
Prevent user double-clicks, browser refreshes, and back button resubmits to avoid duplicate transaction processing. |
| Auto Populate Query Generation |
Auto generate queries by simply specifying the query populate criteria such as table owner, name, and prefix. |
| Bind Variables support for Queries |
Build scalable Oracle applications and improve query performance by using query bind variables to cache frequent queries in the SGA. |
| Page Caching |
Built-in page caching functionality improves performance of generated pages. Pages are re-cached automatically when a developer makes a change and upon next execution. Results follow hierarchical rules minimizing synchronization errors. |
| Cache Maintenance |
A cache maintenance utility is provided for viewing and deleting the contents of the Orbit cache. |
| Export Files |
Export static pages within Orbit to flat HTML files. Generate flat files from pages in the Orbit repository for faster page rendering of static content. (e.g. JavaScript, Style Sheets, static HTML) |
| Dynamic Package Generation |
Dynamically read the Oracle data dictionary to generate PL/SQL packages for queries, inserts, updates, and deletes customized for your application tables. |
| Web Based Interface |
Easy to use GUI interface for package and page generation. |
| Page Generation |
Easy to use page generation wizards allow you to create and customize search report and maintenance pages in less time. |
| Template Application |
The supplied template application provides the building blocks and architectural foundation to get your application up and running fast, so your development team can concentrate on business rules and user requirements. |
| Standard Functionality |
Based on shared best practices among developers, Orbit provides you with a collection of Images / JavaScript / Style Sheets / Templates (Open Source Code) for the most demanding applications. |
| Friendly Reporting Format |
New standard reports and layouts. "Best of Class" date widgets for flexible reporting. |
| Report Generation |
Parameter Driven Input sections such as range searching, wildcards, and validation for reporting customization. |
| Master-Detail Reports |
View a logical representation of your data objects using the Master-Detail report layout. |
| Export to Excel |
Seamlessly export your reports and web pages to Excel. |
| Log Statistics |
Support for Page Statistics and Query Statistics logging. Drill down by session level for a Click-Stream analysis. |
| Purge Utility |
Control the size of Orbit log tables, deleting records as it becomes necessary. |
| Export to Excel |
Export Orbit reports to Excel at a click of a button, and manage your reporting data more effectively. |
| Next/Previous Pagination |
Orbit offers built-in pagination for long reports, dividing a large list into several sequential pages. |
| Date Widgets |
Query reports using Orbit date Widgets such as "days back", "from/to dates", and our handy "calendar popup". |
| Sort Order |
Customize multiple sort order columns easily in your report listings. |
| Linking Data from Reports |
Hyperlink transactional data right from report lists with Orbit in a very flexible and easy way. |
| Parameterized Reports |
Reports in Orbit are parameter-driver. You choose how to filter your queries, narrow as much as needed and get the information that's relevant to you. |
| Output Formats |
Multiple output report formats summarizes data in various different ways. |
| Output Formats |
Multiple output report formats summarizes data in various different ways, such as "Summary" reports with drill down functionality into a "Detail" report output formats. |
| Dynamic SQL where clauses |
Enhance dynamic Where clauses and deliver more flexibility to your reports by incorporating conditional OML. |
| QBE - Query By Example |
Build queries for your reports from an extensive set of templates provided. |
| NetCharts |
Graphical Charting Option |
