SlicingDice Documentation

SlicingDice API Docs

Welcome to the SlicingDice API documentation. You'll find comprehensive guides and documentation to help you start working with SlicingDice as quickly as possible, as well as support if you get stuck. Let's jump right in!

Get Started    Guides

Documentation Guide - Start Here

Welcome to the SlicingDice documentation.

Devs and DBAs love our Docs

:trophy+: SlicingDice is recognized by its customers for having one of the best documentations on the market.
We consider our documentation to be our main product. If you disagree, please give us feedback.

First things first

The first thing you need to know is that SlicingDice gives you three different methods to interact with your database:

  • The JDBC, ODBC and ADO.NET SQL Drivers.
  • The API-based SQL Endpoint.
  • The API-based JSON Endpoint.

All these methods allow you to insert and query your data, using standard SQL (on the SQL Drivers and SQL Endpoint) or JSON request (on our API-based methods). Because of that, you are going to see examples for all the methods we support as you go through our documentation pages.

The second thing you need to know is that SlicingDice has few but important differences to other databases or data warehouses, for example: the fact that you don't have to create multiple tables and a relational model in order to store your data on SlicingDice. Actually, SlicingDice doesn't even have the concept of a table, as you can see in more details on the SlicingDice key concepts page.

Are we a good fit for you?

Before jumping to the next sections of our documentation, we recommend that you take a minute to read about what SlicingDice is NOT good at and our current technical restrictions. We don't want to waste your time if we can't perfectly support your needs.

What should I learn to use SlicingDice?

SlicingDice is very simple and easy to use. Although we are faster and cheaper than our competitors, our main advantage is that you don't need to learn almost anything new to use SlicingDice.

  • If you are a developer, notice that you can integrate SlicingDice to your system using our REST API (JSON) or our JDBC, ODBC and SQL drivers.

  • If you are a database administrator (DBA), you can load your existing data from hundreds of sources directly to SlicingDice using the Data Loading & Syncing module, without having to write a single line of code, and then connect your SQL Workbench [SQL or BI tool to start leveraging our amazing query speed. If you don't already have a BI tool, you can use SlicingDice's Data Visualization module.

  • For both cases, the only information you need to learn in order to move forward with SlicingDice is described on the SlicingDice Key Concepts page.

Once you understood all the SlicingDice's key concepts, you can move forward to the SQL Quickstart Guide if you plan to use SQL or the API Quickstart Guide if you prefer to use our REST API.

Documentation Sections

  • Getting Started and SlicingDice Pricing sections shows everything you need to know about SlicingDice as a product and its specifics. Including where we excel as a provider and also our current limitations. We strongly recommend that you read the SlicingDice Key Concepts page before moving to other pages of the docs, because it contains few but very important terms and concepts used everywhere on our documentation.

  • How to start using SlicingDice section guides you on a quick and hands-on overview on how to start using SlicingDice, from the database creation to the first inserts and queries on your SlicingDice database.

  • Database, Dimension, Columns and Data Modeling section explains all the details about creating and modeling a database on SlicingDice, including all the types of columns and data types supported by the platform.

  • Connecting to SlicingDice section details how you can connect/interact to a database, using SQL, our API or external tools, such as BI platforms or plugins.

  • Insert, Update, Delete & Export section demonstrate in practice all the methods you can use to insert, update, delete and export data on your SlicingDice database, using standard SQL (on the SQL Drivers) or JSON request (on our API-based methods).

  • Query section shows how you can query and analyze your data, using standard SQL (on the SQL Drivers) or JSON request (on our API-based methods).

Pro Tip

In order to make your life simpler and easier, we created many ready-to-use examples, in SQL and JSON, showing how to insert data and also how to make queries for all the data types we support. We expect the examples to speedup your knowledge ramp up about SlicingDice.

  • Data Loading section describes how to use the SlicingDice's Data Loading and Syncing module, that is basically a built-in ETL tool we created for you to quickly and easily load your data from more than 100 different sources, such as other databases (MySQL, Oracle, etc.) or even online services (Salesforce, Google Analytics, etc.).

  • Data Visualization section guides you on how to leverage the SlicingDice's Data Visualization module, that is a built-in chart and dashboard creation tool you can use to start visualizing immediately any the data you insert for your databases.

  • SQL Docs section presents all the SQL specific details you might want to know if you decide to use SQL to interact with your database.

  • API Docs section contains all the necessary information for you to use the SlicingDice's API and leverage all our client libraries to quickly integrate our API into your existing software.

  • Managing your account section guides you on how to perform day-to-day tasks on your SlicingDice account, such as user creation, security and access policies and many more.

  • SlicingDice Internals section gives a detailed overview on how SlicingDice infrastructure works under the hood and how we manage your data in order to be always consistent, accessible and secure. This section also describes S1Search in details, the database technology we developed from the ground up, although you don't need to learn about it to use SlicingDice.

  • Guides & Tutorials section helps demonstrate in practice how you can use SlicingDice to solve real-life problems using many use cases.

Try before you buy

You don't have to create an account or pay just to test how SlicingDice works. Check the try before you buy page.

Documentation Guide - Start Here