OpenInsight's complete tool set (including a Form Designer, Editor/Debugger, UI Workspace, XML Workspace and more), advanced BASIC+ scripting language and powerful client/server development combine to deliver a complete environment for deploying and evolving network applications. 

OpenInsight is delivered with a flexible MultiValued, variable length filing system,  It also has the ability to use SQL Server, Oracle, Lotus Notes, Universe/UniData, D3, or any ODBC compliant data back-end. Delivered with both XML and Web-enabled tools, OpenInsight is a tremendously powerful development tool for Windows and Linux-based applications.

Repository Based Environment

The OpenInsight repository provides a common area in which development teams can store and reuse application components, such as bitmaps, icons, menus, source code modules and the like. In addition, it protects the integrity and eases the maintenance of the application by providing version control, automatic documentation of components, impact/net change analysis and other management capabilities. In addition to providing these tight security features, the OpenInsight repository gives development team's freedom and flexibility. Some examples include:

		Check-in/check-out - enables developers to work on a project at remote locations and with no risk to overall application integrity. Long-term check-out lets users temporarily move components to other drives, devices or workstations. Short-term check-out automatically locks an entity while it is being viewed or modified.
		Extensible architecture - enables project managers to combine third-party development tools and libraries.
		Intuitive design - permits non-developers, such as icon designers and documentation writers, to use the repository.
		Automatic documentation - if a member leaves the project, the rest of the team will know the status of his, or her work.

[top]

OpenInsight Native Tables

OpenInsight is delivered with the option of using its own native table format. OpenInsight's unique table format is fully compatible with Advanced Revelation and many variable length multi-value data management products. The OpenInsight native table environment is a dictionary-driven text-oriented database that delivers the ultimate in flexibility for prototyping, designing and even deploying applications. For the developer, it provides dynamic schema evolution and rapid database modelling with recompilation, as well as unparalleled flexibility in maintaining deployed applications. For the application user, it is ideal for text-intensive applications and integration of text and structured information.

[top]

Client/Server Workspace

OpenInsight's DataSet Object is the key to unlocking client/server connectivity. The DataSet Object is implemented within the product's new visual Client/Server Workspace - an environment in which developers create and manage database components using a collection of visual tools. These tools include a query window, a SQL script building assistant, database connection builder and a DataSet Object definition tool. The database access and manipulation components are separated from other application components, thus they are reusable across multiple applications. The components built with these tools can be integrated with the core set of OpenInsight development tools, yielding a single application development environment for combining high performance access to relational, Notes and OpenInsight's native tables.

[top]

HTML Publishing

OpenInsight enables developers to publish data in native tables to HTML. The tools enable both static and dynamic HTML publishing capabilities. Static publishing means that data is simply published in HTML to the web, any updates require the user to make changes and then republish that data. Dynamic publishing means that OpenInsight creates HTML "on the fly" in response to a CGI request. In other words, the end-user provides the final content in static publishing; in dynamic publishing, on the other hand, the user simply provides parameters, and the application server, working with the web server, builds and provides the final content.

WebOI (version 9 and later) includes a Web 2.0 compliant solution based on AJAX.  This tool enables any OpenInsight desktop form to be converted to run over the web using a framework of user configurable templates in just a few mouse clicks - including much of your event code.

In addition, OpenInsight for Web (OI4Web) is a .NET control that allows developers to communicate with OpenInsight's OpenEngine via the EngineServer.  The OI4Web control can be used from within Active Server Pages (ASP) to connect with an OpenInsight database, run an INET stored procedure and then retrieve the results for display to the user in a standard web browser.

[top]

Data Warehousing

OpenInsight enables developers to warehouse native tables data in an ODBC, SQL Server, or Oracle database. This offers developers complete flexibility in managing native tables data, including running a favourite reporting tool or writing VB, amongst others. Initial warehousing is performed in a two-step process. In the first step, the developer uses the OpenInsight SQL Warehouse Wizard to build the table definitions and the warehousing procedures. In the second step, the OpenInsight SQL Warehouse Manager is used to schedule the warehousing process. The warehousing procedures are registered to the Warehousing Manager when they are created. Subsequent warehousing can be performed on an updates-only basis.

[top]

OpenInsight 's Scripting Language

OpenInsight 's scripting language, BASIC+, is an event-driven language which is compatible with BASIC dialects.  It is explicitly designed for database management and application definition. It provides statements for assignment, flow of control, branching, looping and case selection. A powerful system editor and debugger are included to edit and test BASIC+ programs. Additionally, BASIC+ delivers:

•  Runtime manipulation of user interface components.

•  Powerful string handling.

•  Dynamic and multi-dimensional array handling.

•  Database and OS file I/O.

•  DDE conversation management.

•  DLL calling capabilities.

[top]

For Advanced Revelation Developers

If you are an Advanced Revelation developer, OpenInsight enables you to:

•  Build applications using Advanced Revelation dictionaries, indexes and data files.

•  Create applications using the familiar Basic+ (R/Basic) programming language.

•  Enable team development of applications using OpenInsight's repository, including features such
    as check-in/check-out, version control, impact analysis, object browsing and more.

•  Reuse familiar concepts such as multi-value and variable-length fields.

•  Add SQL Server, ODBC and Notes data to your application.

•  Deploy royalty-free single user runtimes!

[top]

For Lotus Notes Users

OpenInsight specifically addresses development issues in messaging environments. In addition to native Notes data access, OpenInsight allows developers to build Notes databases and supports key Notes R4 features, such as folders and scripts, as well as other key messaging features.

[top]

OpenInsight Tool Set

OpenInsight provides a powerful, easy-to-use set of tools to instantly build forms, reports, menus and database:

		Revelation Reporter - The first tool that lets users generate reports populated by native data from a variety of sources. It is a fast and easy tool for creating presentation-quality reports.
		Form Designer - A point-and-click WYSIWYG screen painter provides rapid development of windows, forms, and menus that require no programming to access data, regardless of data location.
		Create Wizard - A wizard that lets developers design other wizards. It creates a multi-part OpenInsight form which, when executed, can prompt the user for input in order to perform a task or operation. The new wizard can then be modified in the Form Designer.
		BASIC+ Programming Language - This high-level 4GL is compatible with most BASIC dialects and was created solely for database management and application definition. It was made for the event-driven architecture of OpenInsight.
		System Editor and Debugger - Using a powerful MDI programmer's editor, developers can create, modify, compile, and test BASIC+ programs. The online context-sensitive help facility enables developers to copy and paste syntax examples directly into your program. The Debugger uses separate MDI windows for source, local and global variables and the call stack. It also supports single-stepping, trace-around, and unconditional breakpoints that can be triggered by pass counts and modification of variables.
		Popup Designer - Developers can use this feature to create Pick lists for easy data selection by end users.
		Message Builder - With this feature, developers can visually create and design informational and error messages. Custom message styling, data validation and full text formatting are included.
		QuickHelp Builder - Use these tools to visually create context-sensitive help for application users. It includes customizable location and size of help box, full font, colour and justification selections and a scrolling text option.
		Notes R4 Capabilities - Support for Notes R4 folders, agents, MAPI and native API functions.
		Notes Registration Facility - This graphical tool enables users to register a complete Notes database, including all views and forms, in one easy step. Forms, fields, and views are registered in the OpenInsight repository in a hierarchical outline organized by data source and location.

[top]

Get the WORKS

OpenInsight is available through an annual subscription service that gives developers an unprecedented combination of development tools, upgrades, sample applications, tools, utilities, knowledge bases and much more through the "For WORKS Subscribers" web site. We're "opening the OpenInsight Vault" at Revelation and we're providing all of the numerous OpenInsight development resources to our customers.

What You Get

OpenInsight WORKS delivers the following software, support, services and resources on an ongoing basis throughout the term of your annual contract:

• OpenInsight application development environment.

• OpenInsight maintenance and upgrades.

• OpenInsight technical support - telephone and web-based.

• OpenInsight technical content and resources (white papers, samples, and other resources).

All of the above is delivered through the OpenInsight WORKS web site, a private area of Revelation Software's web site dedicated to providing support and service to the OpenInsight WORKS subscribers

[top]

Development Product Minimum Requirements