# Data Store using an API Data Connector

{% hint style="success" %}
*Check out the given walk-through on how to create a Data Store based on an API Data Connector.*
{% endhint %}

{% embed url="<https://files.gitbook.com/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fe7P9Uf1O3iaFlsO3hfWI%2Fuploads%2FuVSWqK57Bugf3Ouyx7vY%2FAPI%20Connector%20based%20Data%20Store.mp4?alt=media&token=78551d9d-4c84-4ff0-9a98-72a7e46be040>" %}
***Data Store based on an API Data Connector***
{% endembed %}

* Access the Data Source List page (Click the Data Store option from the New context menu, to access the Data Source List page).
* Choose an API connector type from the filter panel.
* Click on the ***Create Data Store*** icon to create the Data Store.

<figure><img src="https://content.gitbook.com/content/Kg5pfnNkTs1b1YNYX7rD/blobs/PSTssHnpfPd84lHAS4sY/image.png" alt=""><figcaption></figcaption></figure>

## **Getting Data**  <a href="#getting-data" id="getting-data"></a>

* The ***Getting Data*** tab opens.
* Provide a name for the Data Store.
* The name of the selected Data Connector gets displayed by default.
* Select a data set using the ***Data Set List*** drop-down menu.
* Use a checkmark in the given box to ***Enable Scheduler***
* Click the ***Next*** option.

<figure><img src="https://content.gitbook.com/content/Kg5pfnNkTs1b1YNYX7rD/blobs/PgMCfknkfS2isSHZTIrd/image.png" alt=""><figcaption><p>Configuring the <em><strong>Getting Data</strong></em> tab</p></figcaption></figure>

## **Data Type Definition** <a href="#data-type-definition" id="data-type-definition"></a>

* The ***Data Type Definition*** tab opens.
* The user can interchange the available Dimensions, Measures, and Time fields to define data.
* Enable dimension fields with a checkmark to get in the LOV of the Filter pane of the Self-service BI Report.
* Click the ***Next*** option to proceed.

<figure><img src="https://content.gitbook.com/content/Kg5pfnNkTs1b1YNYX7rD/blobs/DmZbkIsROxKoivVl98ut/image.png" alt=""><figcaption><p>Configuring the <em><strong>Data Type Definition</strong></em></p></figcaption></figure>

## Hierarchy Definition <a href="#hierarchy-definition" id="hierarchy-definition"></a>

* The ***Hierarchy Definition*** tab opens.
* Add a new Drill Def box by clicking the ***Add*** icon.
* Drag and drop Dimension or Time fields to create a hierarchy (The dragged and dropped ***Time*** fields get divided into three level granularities, E.g., Year>Month>Date).
* Click the ***Next*** tab to proceed.

<figure><img src="https://content.gitbook.com/content/Kg5pfnNkTs1b1YNYX7rD/blobs/BNehPIpbOjTQkOCjNY4n/image.png" alt=""><figcaption><p>Configuring the <em><strong>Hierarchy Definition</strong></em> tab</p></figcaption></figure>

## Data Restrictions <a href="#data-restrictions" id="data-restrictions"></a>

* The ***Data Restrictions*** tab opens.
* Click the ***Add*** icon.
* Select a Dimension from the drop-down menu.
* Enter a **User Property** based on the inserted custom fields of a specific user(s) or user group(s).
* Click the ***Next*** option to proceed.

<figure><img src="https://content.gitbook.com/content/Kg5pfnNkTs1b1YNYX7rD/blobs/omRsbxFGyBpCzmQqSxqq/image.png" alt=""><figcaption><p>The <em><strong>Data Restrictions</strong></em> tab</p></figcaption></figure>

## Schedule Data Refresh <a href="#schedule-data-refresh" id="schedule-data-refresh"></a>

* The ***Schedule Data Refresh*** tab opens.
* The following options are provided to Schedule refresh the data:
  * Hourly&#x20;
  * Daily (default option)
  * Weekly
  * Monthly
  * Yearly
* Select any option from the above-given list and configure the required information to set the data refresh interval.
* Select the ***Refresh Now*** option by enabling the box to refresh the Data Store immediately after creation.
* Enable Email Notification by enabling the option.
  * Provide the Email Address to get notified by mail.
* Click the ***Finish*** option.

<figure><img src="https://content.gitbook.com/content/Kg5pfnNkTs1b1YNYX7rD/blobs/scHd6WJnRNO04W9mrNTt/image.png" alt=""><figcaption><p>Configuring the <em><strong>Schedule Data Refresh</strong></em> tab</p></figcaption></figure>

* A success message appears to inform about the creation of a new data store.
* The newly created Data Store gets added to the Data Stores list.

<figure><img src="https://content.gitbook.com/content/Kg5pfnNkTs1b1YNYX7rD/blobs/ItzXvfeTlLZZWeIOyqsf/image.png" alt=""><figcaption><p>A new Data Store based on an API connector gets added at the top of the Data Stores list</p></figcaption></figure>