The dbSpaces MongoSQL server provides users, application developers and IT managers with the ability to access and maintain MongoDB documents using SQL, making the data available to a wide range of BI and Reporting applications through the dbSpaces ODBC and JDBC APIs.

The dbSpaces MongoSQL server also allows noSQL access when using the available dbSpaces noSQL API's; C++, Java and COBOL

The dbSpaces MongoSQL server can be used for COBOL modernization by allowing COBOL applications to store their data in MongoDB as documents and enjoying all the features of MongoDB such as replication.

dbSpaces data dictionaries are also stored in MongoDB as documents in their own databases and are replicated as any other MongoDB database.

Existing MongoDB databases can be easily imported using the dbSpaces Data Source Import wizard. Once imported you can immediately start querying your MongoDB data using SQL.

With dbSpaces MongoDB SQL you can easily:

• Create Schemas
• Create Tables that can contain Multiple row definitions, Structures and Arrays
• Create Indexes
• Create Relations
• Create Views
• Create Materialized Views (requires the Advanced Services add-on)
• Create Synonyms
• Create Comments
• Create and execute Java (SQLJ) and Native based Stored Procedures
• Create standard database Security of Roles and Privileges

The dbSpaces Studio is also available to the dbSpaces MongoSQL server providing a GUI interface to maintain your MongoDB databases.

ADDONS

The dbSpaces MongoSQL Server features can be expanded using Addons from dbSpaces and third party vendors.

For example there are addons such as:

• Data masking using Data Sensitivity addon.
• Data usage and retention policies can be implemented using the Data Policy addon.
• Fine grain Security can be added using the Hippocratic Security addon.
• Create and Execute events and Alerts using the Events + Alerts addon.
• Access other data sources such as Oracle or SQL Server using the Data Orchestration addon.