www.jSONAR.com • 781.369.JSON(5766) • info@jSONAR.com

HIGHLIGHTS• Full access to data in MongoDB without writing code JSON Studio is a suite of applications used by analysts and data scientists as well as developers and QA engineers to unlock the value of your data and drive your Big Data initiatives without the need for writing code or under standing complex JSON artifacts and syntax variants.

• Search using intuitive facets and point-and-click navigation Using JSON Studio anyone can query data easily no matter how complex the data is or how large documents become.

• Slice-and-dice using intuitive GUIs Run complex aggregations and transformations. Harness the full power of the aggregation framework and get access to a sandbox that helps you build analytical queries visually and incrementally.

• Excel Bridge Seamless integration with Excel allowing data in MongoDB to be used from Excel, enriched in Excel and loaded from Excel – all directly by analysts and QA engineers.

• Advanced visualization Visualize any data in MongoDB using more than 20 charting techniques. Exploratory visualization for making sense of complex data fast.

• Understand, visualize and track documentschemasandfieldtypes Explore and analyze collection and document schemas.

• ProfileaccesstodataCollect and storeprofilingdataforlengthy periods and use built-in analysis tools to gain insights from run time data.

• Compare collections and documents Compare documents and collections within a database or across databases for QA, ETL analysis and more.

OVERVIEW

If you’re like most leading enterprises, you use NoSQL in addition to relational databases to deliver cutting-edge applications, manage Big Data and support your Analytics 3.0 initiatives. And if that’s the case, you’re probably using MongoDB already and planning on more adoption of the industry’s leading NoSQL database.

Application developers love MongoDB because it is so easy to use. When developing, they use the MongoDB shell for getting access to data. But when you need to open your database and give the entire user population access to data, youfindthatit’snotsosimple.UserscannotuseSQLandarenotfamiliarwiththesyntaxrequiredforMongoDBfind,updatesandaggregationcommands.Theywant to use their standard tools such as Excel, but can’t. Even developers and QA engineersfinditisnoteasytowritead-hocqueriesandaggregations,toloadandextract partial data sets, and inspect data. You end up writing data-access applications and scripts in addition to the real application just so the data can also be used for various analytic and ad-hoc query tasks.

JSON Studio is the industry’s most effective and most widely-used tool suite and BI platform for MongoDB and makes access easy for all user groups within the enterprise. JSON Studio has been awarded the MongoDB Innovation Award by MongoDB Inc.

Get better returns from your MongoDB investment by giving users access to JSON data that is on-par or superior than access they are used to when using relational databases.

Maximize the value of your MongoDB Investment with JSON StudioSearch, analyze, slice-and-dice, profile, compare and visualize data stored in MongoDB

Highlights  

• Full access to data in MongoDB without writing code – JSON Studio is a suite of applications used by analysts and data scientists as well as developers and QA engineers to unlock the value of your data and drive your Big Data initiatives without the need for writing code or understanding complex JSON artifacts and syntax variants.

• Search using intuitive facets and point-and-click navigation – Using JSON Studio anyone can query data easily no matter how complex the data is or how large documents become.

• Slice-and-dice using intuitive GUIs - Run complex aggregations and transformations. Harness the full power of the aggregation framework and get access to a sandbox that helps you build analytical queries visually and incrementally.

• Excel Bridge – Seamless integration with Excel allowing data in MongoDB to be used from Excel, enriched in Excel and loaded from Excel – all directly by analysts and QA engineers.

• Advanced visualization – Visualize any data in MongoDB using more than 20 charting techniques. Exploratory visualization for making sense of complex data fast.

• Understand, visualize and track document schemas and field types – Explore and analyze collection and document schemas.

• Profile access to data – Collect and store profiling data for lengthy periods and use built-in analysis tools to gain insights from run time data.

• Compare collections and documents - Compare documents and collections within a database or across databases for QA, ETL analysis and more.

Overview

If you're like most leading enterprises, you use NoSQL in addition to relational databases to deliver cutting-edge applications, manage Big Data and support your Analytics 3.0 initiatives. And if that’s the case, you’re probably using MongoDB already and planning on more adoption of the industry’s leading NoSQL database.

Application developers love MongoDB because it is so easy to use. When developing, they use the MongoDB shell for getting access to data. But when you need to open your database and give the entire user population access to data, you find that it’s not so simple. Users cannot use SQL and are not familiar with the syntax required for MongoDB find, updates and aggregation commands. They want to use their standard tools such as Excel, but can’t. Even developers and QA engineers find it is not easy to write ad-hoc queries and aggregations, to load and extract partial data sets, and inspect data. You end up writing data-access applications and scripts in addition to the real application just so the data can also be used for various analytic and ad-hoc query tasks.

JSON Studio opens MongoDB to all user groups within the enterprise, providing tools for MongoDB data access without the need to learn the language or build task-specific applications.

Get better returns from your MongoDB investment by giving users access to JSON data that is on-par or superior than access they are used to when using relational databases.

Maximize the value of your MongoDB Investment with JSON Studio Search, analyze, slice-and-dice, profile, compare and visualize data stored in MongoDB

www.jSONAR.com • 781.369.JSON(5766) • info@jSONAR.com

Copyright © 2015 jSONAR Inc.TheinformationcontainedinthisdocumentistheproprietaryandexclusivepropertyofjSonar,Inc.Nopartofthisdocument,inwholeorinpart,maybereproduced,stored, transmitted, or used for design purposes without the prior written permission of jSONAR,Inc.Theinformationcontainedinthisdocumentissubjecttochangewithoutnoticeandisprovidedfor informational purposes only. MongoDB is a trademark of MongoDB inc. All trademarks and service marks are the property of their respective owners.

Searches and ad-hoc queries JSON Studio gives you various methods to search through your data anddoad-hocqueries.Theseinvolvevisual point-and-click as well as faceted search rather than programming JSON documents for matches and projections. And once you design a query, publish it as a parameterized API/service to any user/application.

Excel Bridge Use Excel to work with your MongoDB data. JSON Studio is not just an interface between Excel and MongoDB that allows you to export/import data – it also lets you build and manage the mapping between the tabular model of Excel and the document model of MongoDB. You can map arbitrarily complex and recursivestructurestoExcelworkbooks.Then, manipulate and analyze data in Excel. You can use formulas and macros to calculate new values, create new columns and new worksheets. JSON Studio then reads the data, updates the mappingon-the-flyandcreatesnewcollections,newdocumentsandnewfieldswithin existing documents.

Pipeline Analytics JSON Studio gives you a sandbox in which you can do both exploratory analytics and build aggregation pipelines. All the power of the MongoDB aggregation framework is available through an easy-to-use visual designer that allows you to design the transformations one step at a time whilst viewing the interim collections and making adjustments as needed.

Visualization JSONStudionotonlygivesyoutheindustry’sfirstvisualization platform for MongoDB data, it is also one of the most robust visualization frameworks for any data providing both simple charts such as lines, bars and pies as well as advanced charts such as histograms, treemaps, chord diagrams, scatter plots, and parallel plots.

ProfilingJSONStudioextendsMongoDB’sbuilt-inprofilingwiththeabilitytocollectprofilingdataoverlongperiods,theabilitytocentralizeprofilingdatafrommanydatabasesintoonestore,andtheabilitytoanalyze,aggregateandgraphprofilingdata.

Availability JSON Studio supports MongoDB 2.2 through MongoDB 3.0. It can be run on a desktop/laptop or on a server running Linux, Windows, OS X or Joyent SmartOS (Solaris x86). Supported browsers: Internet Explorer, Firefox, Chrome and Safari.

Searches and ad-hoc queries: JSON Studio gives you various methods to search through your data and do ad-hoc queries. These involve visual point-and-click as well as faceted search rather than programming JSON documents for matches and projections. And once you design a query, publish it as a parameterized API/service to any user/application.

Excel Bridge: Use Excel to work with your MongoDB data. JSON Studio is not just an interface between Excel and MongoDB that allows you to export/import data – it also lets you build and manage the mapping between the tabular model of Excel and the document model of MongoDB. You can map arbitrarily complex and recursive structures to Excel workbooks. Then, manipulate and analyze data in Excel. You can use formulas and macros to calculate new values, create new columns and new worksheets. JSON Studio then reads the data, updates the mapping on-the-fly and creates new collections, new documents and new fields within existing documents.  

   

Pipeline Analytics: JSON Studio gives you a sandbox in which you can do both exploratory analytics and build aggregation pipelines. All the power of the MongoDB aggregation framework is available through an easy-to-use visual designer that allows you to design the transformations one step at a time whilst viewing the interim collections and making adjustments as needed.    Visualization: JSON Studio not only gives you the industry’s first visualization platform for MongoDB data, it is also one of the most robust visualization frameworks for any data providing both simple charts such as lines, bars and pies as well as advanced charts such as histograms, treemaps, chord diagrams, scatter plots, and parallel plots.      Profiling: JSON Studio extends MongoDB’s built-in profiling with the ability to collect profiling data over long periods, the ability to centralize profiling data from many databases into one store, and the ability to analyze, aggregate and graph profiling data.      Availability: JSON Studio supports MongoDB 2.2 through MongoDB 2.6. It can be run on a desktop/laptop or on a server running Linux, Windows, OS X or Joyent SmartOS (Solaris x86). Supported browsers: Internet Explorer, Firefox, Chrome and Safari. For more information and demos, visit us at jsonstudio.com or call 781-369-JSON (781-369-5766).

Copyright © 2013 jSonar Inc. The information contained in this document is the proprietary and exclusive property of jSonar, Inc. No part of this document, in whole or in part, may be reproduced, stored, transmitted, or used for design purposes without the prior written permission of jSonar, Inc. The information contained in this document is subject to change without notice and is provided for

informational purposes only. MongoDB is a trademark of MongoDB inc. Excel is a trademark of Microsoft Inc. All trademarks and service marks are the property of their respective owners.

Searches and ad-hoc queries: JSON Studio gives you various methods to search through your data and do ad-hoc queries. These involve visual point-and-click as well as faceted search rather than programming JSON documents for matches and projections. And once you design a query, publish it as a parameterized API/service to any user/application.

Excel Bridge: Use Excel to work with your MongoDB data. JSON Studio is not just an interface between Excel and MongoDB that allows you to export/import data – it also lets you build and manage the mapping between the tabular model of Excel and the document model of MongoDB. You can map arbitrarily complex and recursive structures to Excel workbooks. Then, manipulate and analyze data in Excel. You can use formulas and macros to calculate new values, create new columns and new worksheets. JSON Studio then reads the data, updates the mapping on-the-fly and creates new collections, new documents and new fields within existing documents.  

   

Pipeline Analytics: JSON Studio gives you a sandbox in which you can do both exploratory analytics and build aggregation pipelines. All the power of the MongoDB aggregation framework is available through an easy-to-use visual designer that allows you to design the transformations one step at a time whilst viewing the interim collections and making adjustments as needed.    Visualization: JSON Studio not only gives you the industry’s first visualization platform for MongoDB data, it is also one of the most robust visualization frameworks for any data providing both simple charts such as lines, bars and pies as well as advanced charts such as histograms, treemaps, chord diagrams, scatter plots, and parallel plots.      Profiling: JSON Studio extends MongoDB’s built-in profiling with the ability to collect profiling data over long periods, the ability to centralize profiling data from many databases into one store, and the ability to analyze, aggregate and graph profiling data.      Availability: JSON Studio supports MongoDB 2.2 through MongoDB 2.6. It can be run on a desktop/laptop or on a server running Linux, Windows, OS X or Joyent SmartOS (Solaris x86). Supported browsers: Internet Explorer, Firefox, Chrome and Safari. For more information and demos, visit us at jsonstudio.com or call 781-369-JSON (781-369-5766).

Copyright © 2013 jSonar Inc. The information contained in this document is the proprietary and exclusive property of jSonar, Inc. No part of this document, in whole or in part, may be reproduced, stored, transmitted, or used for design purposes without the prior written permission of jSonar, Inc. The information contained in this document is subject to change without notice and is provided for

informational purposes only. MongoDB is a trademark of MongoDB inc. Excel is a trademark of Microsoft Inc. All trademarks and service marks are the property of their respective owners.

Searches and ad-hoc queries: JSON Studio gives you various methods to search through your data and do ad-hoc queries. These involve visual point-and-click as well as faceted search rather than programming JSON documents for matches and projections. And once you design a query, publish it as a parameterized API/service to any user/application.

Excel Bridge: Use Excel to work with your MongoDB data. JSON Studio is not just an interface between Excel and MongoDB that allows you to export/import data – it also lets you build and manage the mapping between the tabular model of Excel and the document model of MongoDB. You can map arbitrarily complex and recursive structures to Excel workbooks. Then, manipulate and analyze data in Excel. You can use formulas and macros to calculate new values, create new columns and new worksheets. JSON Studio then reads the data, updates the mapping on-the-fly and creates new collections, new documents and new fields within existing documents.  

   

Pipeline Analytics: JSON Studio gives you a sandbox in which you can do both exploratory analytics and build aggregation pipelines. All the power of the MongoDB aggregation framework is available through an easy-to-use visual designer that allows you to design the transformations one step at a time whilst viewing the interim collections and making adjustments as needed.    Visualization: JSON Studio not only gives you the industry’s first visualization platform for MongoDB data, it is also one of the most robust visualization frameworks for any data providing both simple charts such as lines, bars and pies as well as advanced charts such as histograms, treemaps, chord diagrams, scatter plots, and parallel plots.      Profiling: JSON Studio extends MongoDB’s built-in profiling with the ability to collect profiling data over long periods, the ability to centralize profiling data from many databases into one store, and the ability to analyze, aggregate and graph profiling data.      Availability: JSON Studio supports MongoDB 2.2 through MongoDB 2.6. It can be run on a desktop/laptop or on a server running Linux, Windows, OS X or Joyent SmartOS (Solaris x86). Supported browsers: Internet Explorer, Firefox, Chrome and Safari. For more information and demos, visit us at jsonstudio.com or call 781-369-JSON (781-369-5766).

Copyright © 2013 jSonar Inc. The information contained in this document is the proprietary and exclusive property of jSonar, Inc. No part of this document, in whole or in part, may be reproduced, stored, transmitted, or used for design purposes without the prior written permission of jSonar, Inc. The information contained in this document is subject to change without notice and is provided for

informational purposes only. MongoDB is a trademark of MongoDB inc. Excel is a trademark of Microsoft Inc. All trademarks and service marks are the property of their respective owners.

RECIPIENT OF THE