Gain Deeper Insights with Better Analysis from your Modern Data Investment

Qarbine helps enterprises quickly analyze, present, and understand their NoSQL, graph, and NewSQL data- whether DBAs reviewing their deployment or end users reviewing the latest customer sales analysis. Qarbine’s agile BI and reporting delivery promotes better decision-making and more efficient workflows across the team.

Professional Workbench

With Query by Example (QBE) and Report by Example (RBE), users simply select fields and fill in the blanks. Qarbine handles generating the native query, retrieving the data, performing the analysis, and formatting the result. This includes a variety of data grouping and Excel-like aggregate functions like SUM and COUNT. Many times the resulting output is all that is needed to gain the desired insight. If desired, you can generate Qarbine components to then access Qarbine’s full querying and template design tools. Click here to see an example of an RBE template and the resulting report result.

The Template Designer is the full featured, interactive tool for use by both developers and end users to specify how data is processed and formatted. It leverages familiar Microsoft Office interactions such as Word formatting, Powerpoint layout interactions, and Excel formulas. Qarbine includes over 400 built-in, Excel-like functions. Instead of using ambiguous cell references in formulas (“= @B6 * C7”), formulas use meaningful field names (“value = #price * #quantity”). A common question in business is, “What percent of the total does this number represent?”. Unlike some other BI tools, Qarbine’s two-pass reporting engine supports calculating this insight and can even render percent-of-total bar charts. An example is shown below.

Modern databases store a very dynamic range of data structures. However, SQL centric tools can only handle simple, 2-dimensional table structures. Complex data structures such as embedded documents and embedded arrays are naturally supported by Qarbine. In addition, given the schema-less nature of some data, Qarbine provides a variety of conditional processing and formatting options. These features are required by any modern BI tool to analyze the dynamic data structures from modern databases.

Prompts are dialogs which promote flexibility in your data retrieval and reporting components. Rather than managing lots of hard coded queries, those queries can have placeholders that are filled in based on user input. Prompts are dialogs to obtain that input using input fields, lists, checkboxes, radio groups, and sliders. For example, a prompt may ask the user which sales region to perform an analysis. The Prompt Designer is a flexible “no-code” tool. End-users can be self-sufficient and not require often overloaded IT resources.

The Data Source Designer is used to perform interactive queries against your database and save those queries in the Qarbine Catalog. It also provides useful information on the general structure of data collections to help you write queries. Data Sources saved in the Qarbine catalog can then be reused by reference from any number of Analysis Templates. DBAs can manage and optimize those retrieval components independent of the many end user templates reusing them. Placeholders in your query and templates can be filled in using input obtained from no-code Qarbine Prompts.

The Data Source Designer tool complements tools like MongoDB Compass and interactive notebooks. Native queries can be pasted into Qarbine Data Source components and managed in the Qarbine Catalog. Likewise, raw queries can be copied from Qarbine and pasted into vendor tools.

The Catalog Browser uses a Windows Explorer-like metaphor to present the components in the Qarbine Catalog. Folders allow better organization and faster access as the number of components scales. Qarbine enforces several different component visibility, read, and write rules. Besides a simple name, Qarbine components include description and other metadata to facilitate discovery and overall productivity. 

Qarbine supports the familiar rich formatting options found in Microsoft Word and even conditional formatting found in Excel. Support for fonts, justification, borders, colors is all included. Furthermore, Qarbine has over 20 custom cell types to support images, interactive buttons, calendars, Adobe PDF forms, geographical maps, charts, and various graphics. In addition, it allows defining common formatting specifications such as headings, subheadings, and standard text. Like Word, these definitions can be stored together in a reusable Style Set. Qarbine report templates can reference a Style Set so that enterprises can quickly apply standard formatting and maintain presentation consistency across reports.

Modern Data Features

Qarbine is designed to leverage modern data features across diverse NoSQL, graph, NewSQL, and Distributed SQL databases. Among the many APIs to be released are MongoDB, Cassandra, Gremlin, Cypher, DynamoDB, and even some SQL ones.

  • Qarbine uses native queries and drivers to retrieve data in its natural form
  • Author native queries in the query designer tool or have Qarbine generate native queries from its fill-in-the-blank tools
  • Cloud agnostic design supports internal and public cloud deployments
  • Supports secondary, analytic node, and other operational strategies
  • Reports can embed interactive graph data diagrams and MongoDB Charts
  • Catalog searches use Apache Lucene (MongoDB Full Text Search) to improve component discoverability
  • Manage ad hoc queries from popular tools all within the Qarbine catalog
Tablet Qarbine Server Visual

Qarbine Deployment

Qarbine deployments consist of one main node and, with the Team edition, additional secondary nodes. The main node manages the Qarbine catalog and configuration. Qarbine secondary nodes may be deployed closer to your data for lower latency or based on legislated geographic rules such as GDPR. Hybrid and multi-cloud deployments are possible.

Qarbine deployments are through a cloud image (i.e., AWS AMI) which resides within the enterprise’s own VPC. By design, enterprise data does not flow through any Qarbine cloud infrastructure. This maximizes your security and flexibility to deploy Qarbine in a manner that is best suits your requirements.

Qarbine’s System Administration tool provides definition and management of users, data services, catalog collections, and other settings. It also provides a monitoring interface for the Qarbine nodes.

Get Started Now!

Close Menu