SlicingDice Documentation

SlicingDice - The All-in-One Solution Documentation

Welcome to the SlicingDice 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

1. What is the Data Loading Module

Our main mission is to allow you to focus on analyzing your data, not spending precious time on data preparation, ETL scripts and so on. At the same time, depending on your use case, we understand that you might need to load some existing data to your SlicingDice database.

Because of that, we built our Data Loading & Syncing module, that contains all necessary ETL capabilities, allowing you to easily load and incrementally update data from more than 100 different sources, without having to write a single line of code.

Overview of the Data Loading & Syncing module

Watch this quick video below to learn more about our Data Loading module.


Getting Started

To insert external data into SlicingDice, you'll need to do two things:

Add a new data source

The data source will contain information such as the location of the data source and its credentials in order to be loaded by a Loading Job.

Add a new loading job

The loading job will use the information of the Data Source to map and load your data into SlicingDice.


Supported data sources

On top of the proprietary connection methods, SlicingDice makes use of all the CData's JDBC and ODBC drivers in order to connect to the data sources. Because of that, we are able to connect to a huge variety of sources, shown below.

Type of data source
Data sources

Databases

  • Amazon DynamoDB,
  • Amazon Redshift,
  • Apache Cassandra,
  • Apache Drill,
  • Apache HBase,
  • Apache Hive,
  • Apache Ignite,
  • Apache Spark SQL,
  • Azure CosmosDB,
  • BigQuery,
  • ClickHouse,
  • Cloudant,
  • Couchbase Server,
  • CrateDB,
  • Druid,
  • ElasticSearch,
  • EnterpriseDB,
  • Greenplum,
  • HP Vertica,
  • IBM DB2,
  • Impala,
  • MariaDB,
  • Microsoft SQL Server,
  • MongoDB,
  • MySQL,
  • neo4j,
  • NuoDB,
  • Oracle Database,
  • PostgreSQL,
  • Redis,
  • SAP Hana,
  • Snowflake,
  • Teradata.

ERP, CRM and Financial systems

  • Authorize,
  • Fresh Books,
  • Highrise CRM,
  • Magento,
  • NetSuite,
  • Oracle Sales Cloud,
  • Paypal,
  • QuickBooks Desktop,
  • QuickBooks Online,
  • QuickBooks Point Of Sale,
  • Sage 50 Uk,
  • Salesforce,
  • SAP NetWeaver,
  • Square,
  • Stripe,
  • Sugar CRM,
  • SuiteCRM,
  • Xero,
  • Zoho CRM.

Data collection platforms

  • Segment,
  • mParticle.

Marketing and Analytics platforms

  • Cooladata,
  • DoubleClick Campaign Manager,
  • DoubleClick For Publishers,
  • Exact Online,
  • Google AdWords,
  • Google Analytics,
  • HubSpot,
  • MailChimp,
  • Marketo,
  • Microsoft Dynamics CRM,
  • Oracle Marketing Cloud.

Log collection and files

  • Amazon S3,
  • Excel Files,
  • FTP Servers,
  • Google Drive,
  • Google Sheets,
  • JSON,
  • Smartsheet,
  • XML Files.

Other services and tools

  • Basecamp,
  • Google Calendar,
  • Google Contacts,
  • Google Directory,
  • Google Search,
  • JSON,
  • SendGrid,
  • Twilio,
  • Twitter,
  • YouTube,
  • YouTube Analytics.