Rocket D3 Technical Specifications

Visual Studio

• Supports the latest versions of Visual Studio .NET (2005 and above)

Development Language

• This API can be used to develop applications in any Visual Studio .NET development language, including C#, C++ and Visual Basic.

Most recent version:

Rocket D3 .NET API 2.0

Back to top

Database Environment

• The Rocket D3 Java API works with Rocket D3 DBMS.

Development Language

• This API allows Java developers to build applications using their preferred Java IDE.

Most recent version:

Rocket D3 Java API 1.8.0

Back to top

RDBMS

• RDBMS must be ODBC-compliant.
• RDBMS must support a Windows ODBC driver.

ODBC Driver

• The ODBC driver is used to create the link between the Microsoft ODBC manager and the RDBMS.

OpenDB Driver

• The OpenDB driver is installed on the server with the ODBC manager.

ODBC Bridge

• The ODBC bridge can be installed on the D3 server if it is a Windows environment (D3 Windows) or on the remote database server if the latter is a Windows-based RDBMS.
• If D3 and the RDBMS servers are both UNIX based, a Microsoft Windows server needs to be present somewhere on the network to serve as the ODBC bridge.

Most recent version.

Rocket Open DB 3.4

Back to top

Rocket FlashConnect provides the ability to run Rocket D3 DBMS applications from the Web through a CGI, ISAPI, or Java interface.

Rocket FlashConnect consists of two components, the Web server component and the D3 component. While both components can reside on the same physical system, usually, for security reasons the Web server and the D3 component are located on physically different systems.

Rocket FlashConnect components can be mixed and matched across Web servers and D3 platforms. One or more Web servers running the Rocket FlashConnect Web component can work with one or more D3 database servers. Each server can be running on a different hardware or O/S platform.

Web Server Requirements

• Rocket FlashConnect is designed to work with any Web server that supports the CGI or ISAPI (on Windows Web servers only) interface.
• Whenever the Web server is started, a Rocket FlashConnect program must also be started. This program must be able to create and access a named pipe in the /tmp directory.

Most recent version.

Rocket FlashConnect 3.9

Back to top

Supported development and deployment platforms include the following:

MVS Toolkit IDE

• Microsoft Windows Server 2008 & 2012, Windows 7, 8 &10 with the latest service pack (both 32 and 64 bit systems).

MVS Web Service Provider

• Microsoft Windows Server 2008 & 2012 with the latest service pack (both 32 and 64 bit systems).
• Red Hat Enterprise Linux/Cent OS 5.11 and 6.4 or later (both 32 and 64 bit systems).

The Rocket MVS Toolkit is free of charge to licensed Rocket D3 DBMS (versions 9.0 and above) and Rocket mvBase DBMS (versions 3.0 and above) database customers covered by a current Rocket Software Software Maintenance Agreement ("SMA"), and includes one (1) MVS Web Service Provider per Rocket D3 DBMS or Rocket mvBase DBMS database server (System ID) and the MVS Toolkit IDE (Windows Only).

To download the Rocket MVS Toolkit, go to the Rocket Customer Portal (Purchase Order not required to download).

If you require additional MVS Web Service Providers, please email [email protected]. For customers not under a Rocket Software SMA, please email [email protected] to discuss how to take advantage of this offer.

Most recent version.

Rocket MVS Toolkit 2.2

Back to top

System

Security

• Multilevel security supports user and account passwords and file access restrictions including update name, date stamping and encryption. Supports SSL and SSH communications. Host Authentication offers enhanced user security by validating the user within the O/S.

Enterprise Licensing

• Allows multiple connections from a client to share a single license. Supported clients include both the .NET and Java (Windows only) MVSP clients and wIntegrate’s Telnet and SSH connections.

Memory

• Through shared program object code usage and virtual memory management, D3 requires as little as one-fifth the memory per user of other database products.

Importable/Exportable

• Import and Export features facilitate complete movement of data between environments. Files can be maintained where they are most often used, and portability between versions of D3 makes data and programs transportable between development and production systems.

Most recent versions:

• Rocket D3 AIX 10.2
• Rocket D3 Linux 10.2
• Rocket D3 Windows 10.2

Back to top

Rocket D3 ODBC Server provides services for SQL and ODBC requests.

Compliance

• The bundled Rocket D3 DBMS ODBC server is SQL-compliant with extended ODBC functionality.
• Examples of SQL features supported include: Create/Drop Table, Select, Insert, Update/Delete Searched, Simple Expressions, Alter Table, Full Select, Create/Drop Index, Select for Update, Update/Delete Positioned, Unions and Transaction Processing statements.
• All statements completely support the Rocket D3 DBMS MultiValue data structure. This includes, but is not limited to, single-value, multi-values and multi-subvalues, correlatives, translates, standard dictionary definition, etc.
• The included D3 ODBC driver currently supports Microsoft's ODBC 2.0 and above.

Semantic Layer

• Utilities are provided to assist in the creation of a semantic layer that describes the D3 database in normalized relational definitions that SQL/ODBC-based clients expect. The existing D3 database structure does not require any physical alterations.
• Multi-valued and multi-subvalued attributes (nested tables) expose unique IDs, permitting direct and unique access to nested structures.

Additional

• Rocket D3 DBMS ODBC supports Star Schema index structures, database triggers, constraints, and execution of AQL statements and stored procedures.
• All database access via SQL also honors the OSFI (Open System File interface) that enables the re-vectoring of file I/O to remote D3 AIX, D3 Linux, D3 Windows or other heterogeneous file systems.

• The D3 ODBC server is available on all Rocket D3 DBMS platforms (AIX, Linux, and Windows).
• The D3 ODBC client driver is only available on Microsoft Windows platforms.

SQL

• D3 data can be accessed using SQL through this Rocket D3 ODBC server layer or through the D3 Class Library.
• If SQL is used to access the D3 multi-dimensional file structure, the multi-dimensional structure needs to be 'flattened' or 'normalized'.
• The D3 SQL-CREATE-TABLE utility is used to create a data map of a 'normalized' view of the D3 file, which is utilized to produce the SQL results.
• The existing D3 database structure does not require any physical alterations

For more information, please refer to SQL/ODBC Server.

Most recent version.

Rocket D3 ODBC Server 2.0

Back to top

Compatibility with Oracle

• The Rocket D3 Oracle Gateway is compatible with Oracle versions 7.3, 8.0, 8i, 9i, 10g and 11. Note: The 32 bit version of the Oracle version 11g runtime client is required, even if you are running on a 64 bit platform.

Supported Operating Systems

• AIX: AIX version 5L 5.2.0.10 or higher and the C compiler must be installed.
• Linux: Redhat Enterprise Linux 5 or higher and the C compiler must be installed.

Required Versions Rocket D3

• Rocket D3 DBMS 7.4.1 or higher.

Standard API

• The Rocket D3 Oracle Gateway uses the standard Oracle Data Access API called Oracle Connectivity Interface (OCI).

Most recent version.

Rocket D3 Oracle Gateway 2.1

Back to top