JSON Studio documentation

Use these sections to learn how to use JSON Studio:

• Introduction to JSON Studio
• JSON Studio Architecture
  • Privileges Requirements
• Installing JSON Studio
  • Installing on *nix
  • Installing on Windows
  • Uninstall
• Working with JSON Studio
• Validating JSON
• Working with the Finder
  • Point-and-click
  • Subqueries for $in, $nin and $all
  • Result Sets
• Working with the Aggregation Builder
• Subqueries
• Formatters
• Using Pattern Formatters for Implementing Report Drill-Down in Dashboards
• Using Pattern Formatters for Implementing Drill-Down that Change a Bind Variable in Dashboards
• Formatters in Offline Reports
• Working with the Spreadsheet Bridge
• Working with the Visualizer
• Working with the Schema Analyzer
  • Casting using the Schema Analyzer
  • Adding Bind Variables using the Schema Analyzer
  • Adding Aliases using the Schema Analyzer
• Schema Analyzer/Sampler
• Metadata Collection and Advanced Architectures
• Visualization Geo-Spatial Data with the Mapper
• Binding Variables
  • Query-based drop-downs
  • Built-in Date Bind Variables
• Using the Gateway (External API)
  • Published APIs
  • Write Operations
  • Join
• Scheduler
  • Scheduler Setup and Internals
  • Scheduling within JSON Studio
  • Firing Jobs
  • Dispatcher
  • Dispatcher LDAP integration
  • Bind Variables and Jobs
• Dashboard Builder
  • Bind Variables in Dashboards
  • Adding an “ALL” Value to Drop Downs
  • Factors
  • Gateway Prefix
• JSON Data Pump (jPump)
  • Using Simple Pumps
  • Building and Using Full Pumps
• jSonarR - Using Gateway data from within R
• Working with Aliases
• Resource Management and Indexes
• Sonar Resource Manager
  • SRM_Log
  • Fine-grained Rules and Instrumentation
  • Test Mode
  • Sharding
  • Limitations and Compensating Controls
• Working with differs
  • GUI Differ
  • SonarDiffer
  • SQL Diffs
  • Diffs using Aggregation
• Working with Sonar SQL Transfer
  • ELT or ETL?
    • Dictionary Lookups in SQL Transfer
    • Logging
• Working with the Run-time Viewer
  • Canceling long running operations:
• Working with SonarProfiler
  • Pipelines:
    • Slow avg by day time:
    • Slow avg by day time per query:
    • Slow avg by time range, op and collection:
    • Slow avg by time range, query and collection:
• JSON Studio configuration options
  • JSON Studio License
  • Preferences
  • Administrator Override of Preferences
  • Read Only Mode
  • Local Only Mode
  • Configuring for Embedded URLs in Dashboards and Applications
  • CSRF Filter
  • Permissions required for Python tools
• Advanced Topics
  • Connecting to MongoDB over SSL
  • Connecting to MongoDB using Kerberos Authentication
  • Using LDAP Authentication
  • Credential mapping
  • Central Datasource Management (aka support for Mongo-as-a-Service - MaaS)
  • Mongo-as-a-Service Redirects
  • Custom Auditing
  • Connecting to a replica set
  • SSL Certificates for JSON Studio
  • Running JSON Studio without SSL
  • Working with the Debug Log
  • Inactivity Timeout
  • Displaying Document Creation Date/Time from oid
  • Custom Operators
• Release Notes for JSON Studio
  • Supported Platforms
  • Unsupported Features and Limitation
  • Prerequisites
  • Known Issues

Sample Scenarios / Tutorials

Use these sections to view sample usage examples for JSON Studio. Each sample provides a short of tutorial on using various features of JSON Studio:

• Build a Report in 5 Minutes
• Using World Bank Project data
• Using Twitter data
• An Aggregation Pipeline Primer for those Familiar with SQL
• Using the Gateway to build composites (Chaining API calls)
• Using the Gateway to Build Dashboards and Applications
  • Step 1 & 2 - Use the Finder to build your query
  • Step 3 - Use the Aggregation Builder to build your aggregation pipeline
  • Step 4 - Use the Visualizer to build a graph
  • Step 5 - Test your pipeline and graph through the Gateway
  • Step 6 - Build your Web page
• Implementing a Simple Asset Management System
  • Using a Subquery
  • Joining the Data
  • Answering Questions with Aggregation
  • Building a Dashboard
• Internet of Things (IoT) Use Case
• Building a Recommendation Engine using R and JSON Studio using Data Stored in MongoDB

Frequently Asked Questions (FAQ)

• Frequently asked questions (FAQ)
  • General
    • What ports does JSON Studio use?
    • I’m using Internet Explorer and point-and-click does not work
    • Can I run JSON Studio on a WAN?
    • What does this message mean? “Possibly multiple windows/tabs open - close all JSON Studio windows/tabs but one.”
    • Why can’t I use the browser’s back and forward buttons?
    • How do I use regular expressions in queries?
    • What’s the difference between cursors and chunks?
    • I get a database error saying something about a cursor not found on server
    • I get a Java out of memory error or heap size error
    • I’m running the Studio on a desktop that does not have a lot of memory
    • I get a java.net.ConnectException when shutting down the Studio
    • “Tomcat did not stop in time” message in the catalina log file
    • What are all these collections that start with lmrm__?
    • What is lmrm__audit_trail?
    • What does lmrm stand for?
    • What is the recommended screen resolution when using JSON Studio?
    • I’m getting an error that I’ve exceeded my license but I don’t think I am.
    • “Exceeded license of -1 currently connected 0” on the Tomcat console.
    • Can I connect using users defined in the admin database?
    • Opening a tabular display on the Finder on the Aggregation Builder fails.
  • Finder
    • When I copy/paste queries shown in the Finder to the shell I sometimes get errors
    • How do the sort and limit work in the Studio?
    • The facet menus seem to be only leaf nodes - why?
    • Why do I need a parameter that controls the depth for populating facets?
    • I changed the facet depth preference and nothing happened.
    • I did a text search, clicked “next” on the cursor and the results were cleared
    • What rows are shown by the “Open Tabular” button?
    • In the result set table view, when I have documents with different fields, the column headers show the last document’s fields
    • What color-coding is used in the Finder?
  • Aggregation Builder
    • Can I drop collections with name like lmrm__agg_pipeline_ _127_0_0_1_60074?
    • I get an error running a pipeline saying “fields stored in the db can’t start with a ‘$’
  • Spreadsheet Bridge
    • What’s happening to my numeric data when I export to Excel and re-import?
    • How do the sort and limit work in the Studio?
    • I get errors when importing large xslx files
    • When I navigate to the Spreadsheet Bridge from the Finder’s result set, the subquery and bind variable are expanded; does the Spreadsheet Bridge not support these?
    • When I import data from a spreadsheet I get a cryptic error such as LEFT_SUBFIELD only supports Object: stats not: 6
  • Visualizer
    • I’m using a line graph and a logarithmic scale and see nothing
    • How can I use a guage visualization to plot different values in the same document vs. a gauge per document
  • Schema Analyzer
    • When building schema metadata from Finder or Schema Analyzer I get a “Too many fields for metadata calculation through JSON Studio (30000 limit reached). Try using sonarsample for this collection/database” error
  • Differ
    • Nothing happens when I click the arrow buttons to open the Differ
  • Bind Variables
    • How do I add a bind variable with a drop down selection?
  • Gateway
    • I’m using curl to invoke a query through the Gateway and getting an error of an SSL certificate problem - why?