- Details
For each major current network and client system version that becomes generally available Revelation Software will conduct intensive benchmark testing with our OpenInsight, Advanced Revelation and Network products for functionality, data integrity and performance. The configurations listed within this matrix are supported environments. Revelation Software is no longer conducting benchmark tests for product versions below OpenInsight 9.x and Advanced Revelation 3.12.
OpenInsight 10
Universal Driver NUL 5.2 for OpenInsight 10 - This is a 64-bit server side installation for use with OpenInsight 10. The Universal Driver NUL 5.2 allows files from OpenInsight 10 and OpenInsight 9.4 to share the same Universal Driver. This version has been updated with the latest ACE libraries. Management of the Universal Driver is done via the OI Console. When paired with OpenInsight 10.0.4 and above "child" processes launched from OpenInsight can be configured so that they do not consume additional license seats.
The Universal Driver NUL v5.2 for OpenInsight 10 will be included at no additional cost with the purchase of OpenInsight 10 licensing.
Universal Driver NUL 5.1 for OpenInsight 10 - This is a 64-bit server side installation for use with OpenInsight 10. The Universal Driver NUL 5.1 allows files from OpenInsight 10 and OpenInsight 9.4 to share the same Universal Driver. This version has been updated with the latest ACE libraries. Management of the Universal Driver is done via the OI Console.
The Universal Driver NUL v5.1 for OpenInsight 10 will be included at no additional cost with the purchase of OpenInsight 10 licensing.
OpenInsight 9.4
OpenInsight 9.4 users who have the Universal Driver 4.7 or Universal Driver 4.7 NUL may upgrade to the Universal Driver NUL v5.2 for OpenInsight 9.4 for a fee of $1,075.00. The Universal Driver 5.2 is a 64-bit product and is only supported on Windows 2008, 2012 and 2016 server platforms.
Universal Driver NUL 5.2 for OpenInsight 9.4 - This is a 64-bit server side installation for use with OpenInsight 9.4 and a 32-bit client side installation for use with OpenInsight 9.4. The Universal Driver NUL 5.2 allows files from OpenInsight 10 and OpenInsight 9.4 to share the same Universal Driver. This version has been updated with the latest ACE libraries. Management of the Universal Driver is done via the UD Manager.
Universal Driver NUL 5.1 for OpenInsight 9.4 - This is a 64-bit server side installation for use with OpenInsight 9.4 and a 32-bit client side installation for use with OpenInsight 9.4. The Universal Driver NUL 5.1 allows files from OpenInsight 10 and OpenInsight 9.4 to share the same Universal Driver. This version has been updated with the latest ACE libraries. Management of the Universal Driver is done via the UD Manager.
The UD 5.0.0.5 contains bug fixes, an improved UD manager, and a client installer which exposes more UD5 features. A bug which caused a client to hang upon repeated toggling of the resize service is fixed. Version 5.0.0.5 supports passing REVPARAM information via a volume pointer or call to ATTACH_TABLE. Some core system routines including RTP57, RTP49, FIX_LH and RTI_LH_INFO are updated. The UD client installer replaces the REVBOOT file and installs the UD_MANAGER and supporting components into your OpenInsight. With these changes, the UD manager displays lock and session details in a format of MACHINE*USER*PROCESSID. This format lets you determine lock holders in a terminal server or O4W environment. The UD manager window ( MANAGE_REVLH_SERVER ) provides access to sub windows displaying statistics, statistics history, size lock and remake table information. It also resolves a long-standing issue with corrupted table header counts and sizes, and includes new options to disable or re-enable automatic resizing of tables.
The UD 4.7.2 is a minor upgrade from UD 4.7. It resolves a significant issue with corrupted table header counts and sizes, a potential memory leak/overrun issue when running in 'debug output' or logging mode, and eliminates "hanging" when shutting down the service. This should allow sites to terminate and restart the UD without requiring a server reboot.
OpenInsight Version 9.x
All OpenInsight 9.1 (and above) licenses ship with the Universal Driver NUL (Network User License) to provide complete networking support for small, medium, and large networks. To obtain your free copy of the Universal Driver NUL please contact your VAR or Revelation Software. Older versions of the All Networks driver are not recommended for use with this version of OpenInsight.
OpenInsight Version 8.0.x
By default OpenInsight 8.x includes the All Networks Driver 1.5 and 2.1 drivers. Both drivers can be utilized with or without the LinearHash service. For performance and reliability reasons we recommend all multi-user systems run the Universal Driver 3.0+ which includes the LinearHash service. All other multi-user configurations are unsupported and no longer tested.
Advanced Revelation version 3.12
While Advanced Revelation 3.12 is past the end of life product support it is still supported as a client to the Universal Driver on several common server configurations.
Chart Notes
Unless otherwise noted, Home versions are not recommended or supported.
Windows XP is no longer supported by Microsoft after April 8th 2014.
Windows 2000 reached end of life in July of 2010 and is no longer listed as a supported client and server platform.
Windows 2003 reached end of life in July of 2015 and is no longer listed as a supported client and server platform.
Windows 2008 reached end of life in January of 2020 and is no longer listed as a supported client and server platform.
Windows Server 2012 and Windows Server 2012 R2 will end on October 10, 2023
For OpenInsight version 10.x and Universal Driver 5.2
Network |
Client |
Minimum Requirement |
Recommended Version |
Windows 2022 |
Windows 10, 11 (64-bit) |
Universal Driver 5.1 NUL |
Universal Driver 5.2 NUL |
Windows 2019 (non-core)1 |
Windows 10, 11 (64-bit) |
Universal Driver 5.1 NUL |
Universal Driver 5.2 NUL |
Windows 2016 (non-core)1 |
Windows 10, 11 (64-bit) |
Universal Driver 5.1 NUL |
Universal Driver 5.2 NUL |
Windows 2012 (non-core)1 |
Windows 10, 11 (64-bit) |
Universal Driver 5.1 NUL |
Universal Driver 5.2 NUL |
OpenInsight 10.0.6 / Universal Driver 5.2 Notes
When paired with OpenInsight 10.0.4 and above "child" processes launched from OpenInsight can be configured so that they do not consume additional license seats.
For OpenInsight version 9.4.4 and Universal Driver 5.1/5.2
Network |
Client |
Minimum Requirement |
Recommended Version |
Windows 2022 |
Windows 10, 11 |
Universal Driver 5.2 NUL |
Universal Driver 5.2 NUL |
Windows 2019 (non-core)1 |
Windows 10, 11 |
Universal Driver 5.2 NUL |
Universal Driver 5.2 NUL |
Windows 2016 (non-core)1 |
Windows 10, 11 |
Universal Driver 4.7.2 |
Universal Driver 5.2 NUL |
Windows 2012 (non-core)1 |
Windows 10, 11 |
Universal Driver 4.7.2 |
Universal Driver 5.2 NUL |
OpenInsight 9.4.4 / Universal Driver 5.1/5.2 Notes
This version of OpenInsight is the only version compatible with both the Universal Driver 4.7.2, Universal Driver 4.7.2 NUL and Universal Driver 5.1/5.2 NUL. All other versions of OpenInsight are NOT compatible with the Universal Driver 5.1/5.2 NUL.
Note 1 - All versions of Windows Server 2012 can be installed in core or non-core types. A core installation is a type of Windows installation with minimal GUI interface and is designed for administration through the command line. While the Universal Driver will run in this type of installation we strongly recommend the non-core installation for full utilization of the Universal Driver Manager and it’s features.
For OpenInsight version 9.x
Network |
Client |
Minimum Requirement |
Recommended Version |
Windows 2016 (non-core)1 |
Windows 10, 11 |
Universal Driver 4.7.2 |
Universal Driver 4.7.2 NUL |
Windows 2012 (non-core)1 |
Windows 10, 11 |
Universal Driver 4.7.2 |
Universal Driver 4.7.2 NUL |
OpenInsight 9.x Notes
This version of OpenInsight is the only version compatible with both the Universal Driver and Universal Driver NUL. All other versions of OpenInsight and Advanced Revelation are only compatible with the Universal Driver.
Note 1 - All versions of Windows Server 2012 can be installed in core or non-core types. A core installation is a type of Windows installation with minimal GUI interface and is designed for administration through the command line. While the Universal Driver will run in this type of installation we strongly recommend the non-core installation for full utilization of the Universal Driver Manager and it’s features.
rev. 08-2023
- Details
OpenInsight is a repository-based development environment that provides professional development teams the means to rapidly design, implement, evolve and scale high performance business applications with access to SQL Server, U2 and D3 databases from Rocket Software, QM from Ladybridge, and Revelation’s Native Tables. The net result is that developers can deliver applications to their customers and users that meet the needs of a dynamically changing business environment.
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 teams freedom and flexibility. Some examples include:
- Check-in/check-out - lets developers work on a project at remote locations 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 - lets project managers 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.
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 variable length MultiValue 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 modeling 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.
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 and, therefore, 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.
HTML Publishing
OpenInsight enables developers to publish data in native tables to HTML. The new 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.
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 favorite reporting tool or writing VB, among 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.
OpenInsight's BASIC+Scripting Language
OpenInsight’s scripting language, BASIC+, is an event-driven language which is compatible with BASIC dialects and which 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 is 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
- OLE integration
- DLL calling capabilities
Arev32 for Advanced Revelation Developers
If you are an Advanced Revelation developer, OpenInsight enables you to:
- Create and run Advanced Revelation applications in a console application powered by OpenInsight eliminating the need for MS-DOS.
- 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
- Windows 7 compliant
- Add SQL Server, U2 and D3 data to your application
- Utilize OpenInsight's OIPI printer interface!
OpenInsight for Web (O4W)
The OpenInsight for Web (O4W) Development Toolkit makes it possible for OpenInsight Developers with limited or no HTML/XML/JavaScript experience to develop feature rich web pages.
O4W is designed to work the way OpenInsight developers think, taking advantage of the skills and knowledge they already have. While users with more web development experience can
use O4W's advanced features, all developers can create modern web applications (using JavaScript, XHTML, and AJAX) through O4W's APIs.
OpenInsight Tool Set
OpenInsight provides a powerful, easy-to-use set of tools to instantly build forms, reports, menus, and database:
- Table Builder - The Table Builder is used to create and maintain OpenInsight data file attributes.
- Database Manager - The Database Manager is an administrative tool used for database, user, environmental and index management, as well as linear hash maintenance utilities and ASCII data file import.
- OpenInsight for U2 - With OpenInsight you can attach U2 (UniVerse and UniData) files as native tables.
- OpenInsight for D3 - With OpenInsight you can attach D3 files as native tables.
- OpenInsight for SQL - With this connector, SQL tables are now seen as native tables to all components of OpenInsight including forms, reports, popups and stored procedures.
- 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 lets developers 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.
- Report Builder - The Report Builder allows developers and users to generate reports and lables populated by native data from a variety of sources. It is a fast and easy tool for creating presentation quality reports.
- Banded Report Writer - The Banded Report Writer offers an array of sophisticated, simple-to-use tools that allows users and developers alike to create stored and ad-hoc reports. Using our WYSIWYG layout form designer makes the creation of even the most complex reports a simple task.
- 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 this tools to visually create context-sensitive help for application users. It includes customizable location and size of help box, full font, color, and justification selections, and a scrolling text option.
- Character to OpenInsight (CTO) - The CTO interface is a green screen application that runs on a GUI engine, allowing you to run to run your existing MultiValue applications without major changes to your code or data.
- Arev32 - The Arev32 interface contained within OpenInsight 8.0 allows users and developers to run and create Advanced Revelation applications in a console application.
- OEngineServer - The OEngineServer is software that is responsible both for communicating with, and shutting down OpenInsight's OpenEngine. The OEngineServer also manages "caching" of OpenEngines, for efficient performance in non-persistent applications (e.g. web requests).
- NetOI - Using the NetOI .NET assembly, you can code entirely in Visual Studio and develop a Windows application that uses OpenInsight as its data source.
- RevDotNet - RevDotNet functionality is contained in a series of APIs that OpenInsight programmers can call to create and manipulate .NET classes.
- Details
For OpenInsight (Versions 10.0 and higher)
CPU:
|
Intel Processor 2 Ghz or better |
Software Requirements:
|
Windows 10 64-bit workstation Windows 11 64-bit workstation Windows 2019 Server 64-bit Windows 2022 Server 64-bit |
Memory:
|
4 Gb or better |
Disk space:
|
2 Gb or better |
Graphics adapter and monitor:
|
1280 x 800 or better |
Network operating systems:
|
Universal Driver 5.4 |
Other:
|
Microsoft .NET 2.0 Framework Microsoft .NET 4.0 Framework |
For 32-bit OpenInsight (Versions 9.0 and higher) - No Longer Supported
CPU | Intel Processor 2Ghz |
Memory | 1 GB |
Disk Space | 450 MB |
Screen Resolution | 1024 x 768 |
Software Requirements |
Windows XP Professional, Vista Business 32-bit & 64-bit, Vista Ultimate 32-bit & 64-bit, Windows 7 Professional 32-bit & 64-bit, Windows 7 Ultimate 32-bit & 64-bit, Windows 8 32-bit & 64-bit all versions except RT, Windows 8.1 32-bit & 64-bit all versions except RT, Windows 10 32-bit & 64-bit Pro and Enterprise (for versions 9.4 and higher) Windows 2003 Server 32-bit & 64-bit, Windows 2008 Server 32-bit & 64-bit, Windows Server 2012 with full GUI, Windows Server 2012 R2 with full GUI, Windows Server 2016 with full GUI |
Network (if used) | 100mbit or faster connection to Windows Server file share using Universal Driver |