Data Center
  • Data Center
    • Homepage
    • Data Connectors
      • Create Data Connector
      • Data Connector List
        • Edit Data Connectors
        • Create Option
        • Reconnecting to a Data Connector
        • Sharing a Data Connector
        • Delete a Data Connector
      • Supported Data Connectors
        • Database Connectors
          • MySQL
          • MSSQL
          • Elastic (Beta Release)
          • Oracle
          • ClickHouse
          • Athena
          • Arango DB
          • Hive
          • Cassandra
          • MongoDB
          • MongoDB for BI
          • PostgreSQL
          • Snowflake
        • File Data Connector
        • API Connectors
          • API Connector
          • Amazon
          • App Store
          • Bing Ads
          • Dropbox
          • FTP Server
          • Facebook
          • Facebook Ads
          • Firebase DB
          • Fitbit
          • Flipkart
          • Google AdWords
          • Google Analytics
          • Google Big Query
          • Google Forms
          • Google Sheet
          • HubSpot
          • Jira
          • Lead Squared
          • Linkedin
          • Linkedin Ads
          • MS Dynamics
          • Mailchimp
          • QuickBooks
          • SalesForce
          • ServiceNow
          • Twitter
          • Twitter Ads
          • Yelp
          • YouTube
          • ZOHO Books
        • Others
          • MS Sql Olap
          • Data Store
          • OData
          • Spark SQL
          • AWS Redshift
          • SAP HANA
    • Data Sets
      • Creating a New Data Set
        • Creating a New Data Set using RDBMS Connector
        • Creating a Data Set using Arango DB Connector
        • Creating a Data Set using an API Connector
        • Creating a New FTP Data Set
        • Creating a Data Set based on an Elastic Connector
      • Data Set List
        • View Options: Data Sets List Page
        • Data Set List: Actions
          • Editing a Data Set
          • Sharing a Data Set
          • Publishing a Data Set
          • Push to VCS
          • Pull from VCS
          • Deleting a Data Set
          • Data Preparation
    • Data Stores
      • Creating a New Data Store
        • Data Store using an RDBMS Connector
        • Data Store using an API Data Connector
      • Data Stores List
        • Edit a Data Store
        • Refresh Data for a Data Store
        • Store Info
        • Sharing a Data Store
        • Adding Synonyms to a Data Store
        • Refresh Synonyms
        • Push to VCS
        • Pull from VCS
        • Delete a Data Store
    • Data Store Meta Data
      • Creating a New Meta Data Store
      • Data Store Meta Data List
        • Editing Meta Data Store
        • Store Details
        • Adding Synonyms to Meta Data Store
        • Refresh Synonyms
        • Sharing a Metadata Store
        • Deleting Meta Data Store
    • Data Sheets
      • Creating a New Data Sheet
      • Editing a Data Sheet
      • Publishing a Data Sheet
        • Entering Data
        • Applying Filter
        • Deleting a Row
      • Removing a Data Sheet
    • Data Sandbox
      • Creating a New Data Sandbox
      • Data Sandbox List
        • Upload File Status
        • Using the Data Preparation Option
        • Deleting a Data Sandbox
        • Create Data Store
        • Reupload
        • Preview
        • Create Datasheet
    • Data as API
    • Data Preparation
      • Accessing the Data Preparation Option
      • Data Preparation Workspace
        • Data Preparation Landing Page
        • Profile Tab
        • Transforms
          • Advanced
          • Anonymization
          • Columns
          • Conversions
          • Data Cleansing
          • Dates
          • Functions
          • Integer
          • ML
          • Numbers
          • String
        • Steps
      • Data Preparation List
        • Rename
        • Edit
        • Delete
Powered by GitBook
On this page
  • Getting Data
  • Data Type Definition
  • Hierarchy Definition
  • Data Restrictions
  • Schedule Data Refresh
  1. Data Center
  2. Data Stores
  3. Creating a New Data Store

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.

PreviousData Store using an RDBMS ConnectorNextData Stores List

Last updated 9 months ago

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

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

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.

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.

Hierarchy Definition

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

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:

    • Hourly

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

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

Data Store based on an API Data Connector
Configuring the Getting Data tab
Configuring the Data Type Definition
Configuring the Hierarchy Definition tab
The Data Restrictions tab
Configuring the Schedule Data Refresh tab
A new Data Store based on an API connector gets added at the top of the Data Stores list