Configuring the Simba MongoDB JDBC Driver Options for MongoDB Connector

Back Next

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 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.

Configure the Simba MongoDB JDBC Driver Options in a MongoDB Connection

Using the Schema Editor for JDBC Connections

System Requirements

Start the Schema Editor for JDBC Connections

Start the Schema Editor from the Secure Agent location

Download Guide

Watch

Comments

Cloud Connectivity Homepage

Communities

Knowledge Base