Easysoft Blog

Fri, 24 Apr 2015

SQL Access to MongoDB

MongoDB has grown quickly to become one of the most popular enterprise databases on the market today, and Easysoft Limited is using its data access expertise to provide these enterprises with SQL access to their "Big Data" solution.

Enterprises need SQL access for: Business Intelligence (BI) and other analytics applications, connecting Web Applications to database backends, data access for business applications (empowering corporate users), mobile deployment and data integration (ETL).

Amongst our MongoDB clients, gaining SQL access to their complex data for Business Intelligence is their strongest requirement, which is why we addressed this problem first.

As their primary pain point is getting data for Business Intelligence and analytic applications, we know that Read access is important to them, so our initial MongoDB ODBC offering is designed to offer them just that.

As our expertise in data access and ODBC connectivity is pretty amazing, our approach to connecting to the JSON datasets held within MongoDB is also pretty amazing.

MongoDB JSON document structures are free from typical architecture constraints, so there is no predictable Database/Table/Column structure of Relational Databases. Most ODBC/data transfer solutions available today would attempt to flatten these datasets and bring back an over simplified view of the nested data, not Easysoft...this first release of the Driver reads what your MongoDB Schema is really like on the fly, and allows you to Read the data based on that view.

Apart from the increased speed of deployment, the benefits of this approach are simple:

Future developments will include a MongoDB Schema Editor that will allow you to inform our ODBC Driver exactly what your MongoDB Schema looks like, allowing a perfect view of your data.

This Schema Editor will also allow you to adjust SQL types and sizes, alter column and table names, and even hide whole databases, tables and columns from your end users and ODBC applications, ultimately offering you complete flexibility on how you want to expose your MongoDB data to the ODBC application.

MongoDB ODBC Driver - click on the link if you want to read more about our Driver and start your free trial.