Here to Help

Create Datasources from API Servers

Estimated reading: 5 minutes 196 views

Infoveave helps you create a datasource using the APIs. Infoveave supports APIs from IoT devices, Facebook, Twitter, Google Analytics, and data.world. You can create an account right here if you don’t already have one on any of these social media sites. In Infoveave, we create a new custom Datasource using IoT Datasources.

Datasource from Social Media Platforms APIs

Instructions to build datasource from API server

  1. Click on StudioDatasorces New  to select the APIs from the drop-down.
  2. Select Facebook from the drop-down menu.

We’ll use Facebook to show you how to do it. You may pick from Twitter, data.world, Google Analytics, and IoT, among others.

  1. Create the database and the schema through Connect New Account.
  1. Enter the social media account credentials for Infoveave to connect with social media API. 

Infoveave specifies the Measures and Dimensions for datasources from social networking platform APIs.

Datasource from IoT device APIs

IoT devices collect and send data to Infoveave in real-time at regular intervals. A custom URL linked to the datasource sends the data to Infoveave. Infoveave adds the new data to the relevant datasource.

In Infoboards, widgets related to IoT datasource will display the real-time updates. All widgets dependent on the IoT datasource will be marked with a along with the widget name.

Use the resource files EventDate.txt to study and discover more about creating a datasource in Infoveave from IoT devices API.

To build a Datasource from IoT device APIs, follow the below instructions.

Selecting the IoT Server

  1. To create a new datasource, click New and select IoT Devices from the drop-down and click OK.
  2. Click on Choose File to select the file.

The supported file extension for IoT devices is .json.

  1. Select the desired file location in the file picker dialog box.
  2. Click on Local File.
  3. Click on Select your Data to upload the file to Infoveave.
  4. As the file processing is complete, a tabular preview of the data will be available. This will also show the sheet name in the delimited file.

Defining Calculated Columns and Date Dimensions

  1. Assign a name for the datasource.
  2. Click on Add Calculated Column, if you want to add a new additional column with some calculations not available in the dataset. For information on calculated columns, see Datasource Features.
  3. Click on Date Column Settings to set the auto generated date. Detailed  explanation comes under Advanced Features.
  • Once the new calculated column is in your datasource, you cannot edit or delete it.

Data Ingestion

  1. Click  , close to the sheet name, to change the table name or the data ingestion type.
    • Infoveave supports three ingestion types Incremental, Truncate and Reload, and Update. Learn more from the section Data Ingestion.
  1. Click  in the column header of the tabular view to do the following options:
    • Column Type: to change the column data type.
    • Auto Size All Columns: to perfectly fit the data in the column.
    • Fit to Chart: To limit the visibility of the data to suit the chart for quick viewing
  1. Click on Add File to add another set of data as a table to the same datasource.
  2. Click on Save and Continue.
    • The datasource is available in the cube designer window now.

Configure measures and Dimensions

  1. To define a measure in cube designer, mouseover the icons next to the column name in the table, click Add as Measure and then pick the proper aggregation (Sum, Average, Count, Distinct Count, Min, Max).
  2. For the new chosen measure, add description, format, decimal precision, prefix and suffix for a selected measure and click on Add measure. The new measure will get added under a measure on the left side of the cube designer. Further details are explained under Measures.

Choose the aggressions as count or distinct count if choosing a date column or a text column as a measure.

  1. To add a column as a dimension in cube-designer mouseover the icons next to the column name in the table, then click Add as Dimension.
  2. For dimension, select Use Unique Values. For the date column as a Date Dimension, select Use as Date Dimension. To know more about dimensions, visit Dimensions .
  1. By selecting the icon on a cube , you can conceal that specific cube within the cube designer.
  2. Clicking the icon will help to add calculated columns, download template, preview data, and manage template.
    • Add calculated columns to the table with the Add Calculated Columns.
    • Preview Data helps you view the uploaded data table.
    • To add new columns and to define the data upload method, use Manage Template.
    • Click on Downloads Template to download the new table template with added columns and calculated columns.

You must add at least one measure and one dimension for Infoveave to save the datasource.

Multiple Table Data

  1. Click on Add File to upload multiple files one by one. . 
  1. Click on Available Tables if you need to establish a relationship between the tables using the existing datasources with the Primary Key Column. For understanding more visit the section Create Measures, Dimensions, Hierarchies.
  2. Click Update Datasource to make any changes in datasource. You can ignore the unnecessary dimensions by unchecking the Import option.

Data Upload

  1. You can view all the datasources,
    • You have created under Studio DatasourcesMy Datasources
    • Shared with you under Studio DatasourcesShared Datasources
  1. To upload data to the IoT datasource, use HTTP URL that you see, when clicking the Data Upload Icon