Data Store using an API Data Connector

This page displays step-by-step process on how to create an API Data Connector based Data Store.

Check out the given walk-through on how to create a Data Store based on an API Data Connector.

• Navigate to the Data Center homepage.

• Click the New option.

• Select the Data Stores option from the context menu.

• Choose an API connector type from the filter panel.

• Select a data connector from the displayed list.

• Click on the Plus symbol option to create the Data Store.

Getting Data

• 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.

Configuring the Getting Data tab

Data Type Definition

• 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.

Configuring the Data Type Definition

Hierarchy Definition

• The Hierarchy Definition tab opens.

• Add a new Drill Def box by clicking the Add icon.

• Drag and drop Dimension fields or Time field to create a hierarchy (The dragged and dropped Time fields gets divided into three level granularities, E.g., Year>Month>Date).

• Click the Next tab to proceed.

Configuring the Hierarchy Definition tab

Data Restrictions

• 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.

Schedule Data Refresh

• The Schedule Data Refresh tab opens.

• The following options are provided to Schedule refresh the data:

  • Daily

  • Weekly

  • Monthly

  • Yearly

• Select any one 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 its creation.

• Enable Email Notification by enabling the option.

  • Provide the Email Address on which you want the notification email to be sent.

• Click the Finish option.

Configuring the Schedule Data Refresh tab

• 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.

A new Data Store based on an API connector gets added at the top of the Data Stores list