Simba Technologies
Simba Technologies

Schema Editor 3.2.0
User Guide

Simba > Drivers > MongoDB > Schema Editor User Guide > Introduction > About the Schema Editor

About the Schema Editor

NoSQL data stores are able to store "denormalized" data, which does not follow the rules of data typing and structure that apply to traditional relational data. Denormalized data does not have a schema, and can include complex data types such as nested arrays or arrays of differently-typed elements. Because traditional ODBC and JDBC toolsets do not support these data structures, the data needs to be mapped to a relational form.

The Schema Editor is a Java application that enables you to create and modify schema definitions for NoSQL data stores. A schema definition serves as a database layer that maps NoSQL data to ODBC- and JDBC-compatible formats so that you can use standard BI tools to work with the data.

You can use the Schema Editor in conjunction with a Simba driver to create schema definitions. The driver generates the initial schema definition by sampling the data to detect its structure, and then assigning an appropriate data type to each column and generating virtual tables to represent complex data types. You can then use the options in the Schema Editor to manually modify the schema definition and make sure that your application can work with the data.

All Simba drivers that support schema definitions include the Schema Editor as part of the driver installation.


The AIX version of the Simba MongoDB ODBC Driver with SQL Connector does not include the Schema Editor, because the Schema Editor is not compatible with AIX at this time.