Connecting data sources

On SlicingDice you can connect external sources to your account, so you can use it to load data into your physical databases or just execute queries and analyses directly over these sources. Here you'll learn how to connect them to SlicingDice using the Data Warehouse Module.


Adding a data source

Setting up a data source will save all the connection information (such as location and credentials) needed for its access so you can use all SlicingDice tools to query, analyse and execute predictions directly on the data stored on this external source. Below we explain how you can add a new data source to SlicingDice through the Data Warehouse Module.

In the Control Panel, access the Data Sources page on the the Data Warehouse Module and click on Create New Data Source to start connecting it.

The first step is to configure your data source identification as you can see below.

Screen to define
        the data source identification

Here you'll define the name, description, possible labels and the data availability for this source that defines if this data source will be available to be queried directly (Logical Data Sources), to be loaded into SlicingDice physical databases (Data Loading) or both. As the purpose of this guide is to use this source to execute queries and analyses directly over it (Logical Data Sources) you can choose the SlicingDice Databases or Both option. When ready, click on Save & Continue.

Now you'll define the appropriate data source credentials. Each data source type has its own credentials. Common credentials are IP, port, hostname, username, password, database name, URL address, access type, region and so on.

Below is an example of how to add a CSV (HTTP) data source.

Screen defining a csv data source

You can test the connection by clicking on Test Connection. If everything goes ok, you'll see a Connection Success message and then you can click on Save & Continue.

As you chose between Logical Data Warehouse or Both option on data availability, a new step called Logical Config will be added to this wizard. Here you should define if this source will be available to all databases you have or for just specific ones. You should also define the tables from your external source that will be available for queries.

Finally just check your data source configuration and click on Submit. Now you'll be able to find your created data source at the data sources list. That's it!, now you can use this data source to create a loading job that will connect to this source and load your data.

- 198.27.66.54
- 198.27.66.59
- 198.27.82.204
- 198.27.82.219
- 198.27.65.166
- 198.100.146.31
- 198.100.144.110
- 198.27.64.43
- 198.245.49.83
- 198.245.51.121
- 198.27.65.73
- 142.4.212.149
- 142.4.215.7
- 198.27.64.163
- 198.100.146.177
- 198.27.82.218
- 198.27.65.44
- 198.27.64.214
- 198.27.83.77
- 198.245.49.28
- 5.135.179.139
- 5.135.179.164
- 5.135.186.220
- 5.135.179.172
- 91.121.75.162
- 91.121.64.213
- 46.105.123.19
- 5.135.179.184
- 5.135.187.172
- 5.135.187.151
- 46.105.96.56
- 5.135.180.89
- 176.31.255.158
- 91.121.154.36
- 5.135.179.34
- 5.135.180.16
- 178.32.216.198
- 5.135.180.109
- 5.135.180.81
- 5.39.89.175