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

Adding a new loading job

First time checking our docs? You might want to start with the right foot by reading our Documentation Guide first.

On this page we explain how to add a new loading job to the SlicingDice's Data Loading & Syncing using SlicingDice's Control Panel.


Adding a loading job using the control panel

Watch this quick video below to learn step-by-step how to add a loading job using the SlicingDice's Control Panel.


Loading jobs wizard explained

Below we explain each one of the steps and fields required when adding a loading job.

Step 1 - Loading Job Setup

Field
Description

Loading Job Name

The name of your loading job. Can be edited at any time.

Loading Job Description

The description of your loading job. Can be edited at any time.

Loading Job Type

The type of your job, options are "One-time manual load", "Manual incremental load" or "Automatic/Scheduled". Cannot be edited once it's created.

Data Source

The data source you want to use to load data from. Cannot be edited once it's created.

Step 2 - Destination Config

Field
Description

Database

The database in which you want to load data. Can be edited at any time.

Destination Dimension Type

Select if you want to insert the data in an existing dimension or if you prefer to insert the data in a new dimension. Can be edited at any time.

Destination Dimension Name or Destination Dimension

Depending on what you selected on the previous field (Destination Dimension Type), you need to select the database's dimension you want to load the data or inform a name to the new dimension. Cannot be edited once it's created.

Step 3 - Data Source Config
The fields from the data sources config step varies according to the Loading Job Type selected on the first step.

Field
Description

Access Mode

How you want to select the data to be loaded from the source, using a SQL query (Query) or selecting the columns (Table). Can be edited at any time.

Rows per request per second

In order to avoid overloading or flooding your data source, select how many rows per second you want to load. Options are 10, 50, 100, 500, 1000 rows per second. Can be edited at any time.

Table or View (If you selected the "Table" option on the "Access Mode" field)

Select the table or view from the data source that you want to load your data. Can be edited at any time.

Where clause (If you selected the "Table" option on the "Access Mode" field)

Define the "where" clause that will be used to load the rows from the table you selected. This allows you to filter the data you want to load. Can be edited at any time.

Detect Schema Button

Once you defined the "Query" or the "Table" field, the detect schema button will load to your screen all the columns from the data source, in order for you to map the source's columns to the SlicingDice's columns on the next steps (below).

Attribute column Mappings - Data Source

All the data source's columns.

Attribute column Mappings - Destination

The SlicingDice's database columns. On this step you need to map all the columns that you want to load as an Attribute column, so the columns and its data that is not related to a date/time.

Event column Mappings - Data Source

All the data source's columns.

Event column Mappings - Destination

The SlicingDice's database columns. On this step you need to map all the columns that you want to load as an Event column, so the columns and its data that are related to a date/time.

Event column Mappings - Date Source

The column from the data source that you are going to use as the date/time (timestamp) value, for each column from the data source that you are going to import to SlicingDice as an Event column.

Step 4 - Confirmation
Summary of all the information and configurations you defined for the loading job, before you finally create it.

Once the loading job is created, it will immediately start to load your data to your SlicingDice database, and automatically appear on the list of loading jobs.