AMISALABS

Amisa Analytical SQL is the best tool for analytical work on NoSQL databases: write SQL, share ad-hoc analysis, and build powerful visualizations.

Speed

Run analytics up to 150x faster.

All query filters are executed 100% in-database. Amisa Analytical SQL then applies advanced analytical functions on the results in-memory. Amisa Analytical SQL has very low memory footprint.

Ease of Use

Write analytical queries in SQL.

Amisa Analytical SQL is a variant of T-SQL/PL-SQL. It features a compelling array of analytical functions to drive enhanced reporting, advanced aggregations and complex analytics against data sources of all sizes.

Runs Everywhere

Access diverse NoSQL databases.

Amisa Analytical SQL runs in any environment, from cloud, to on-premises, to desktop and laptops. It connects directly to your databases so you can query and join data from different NoSQL systems.

  Analytical Features

More than SQL SELECT. Some built-in analytical features include:

  • Joins & Derived tables
  • Temporary tables
  • Event window functions
  • Ranking
  • LAG/LEAD
  • FIRST/LAST
  • Percentiles
  • Complex Aggregations
  • User Defined Functions

  Visualize Data

Type SQL, Get Charts. Some built-in chart types include:

  • Bar Charts
  • Pie Charts
  • Scatter Charts
  • Bubble Charts
  • Area Charts
  • Line Charts
  • Geo Chart

  Data Sources Supported

Query and join different data sources

  • MongoDB
  • ElasticSearch
  • Solr
  • Cassandra
  • Couchbase
  • S3
  • CSV files
  • If your proprietary data store supports REST API, chances are you can connect it to Amisa Analytical SQL. And we're adding new data stores all the time.

Join The Beta