---
title: Creating a datafeed
description: Applies to v4.5 and later.
---

[Skip to content](https://help.intuitivebusinessintelligence.com/creating-a-datafeed#main-content)

English

Show submenu for translations

![Intuitive logo RGB-1.png\]](https://help.intuitivebusinessintelligence.com/hs-fs/hubfs/Intuitive%20logo%20RGB-1.png?height=40&name=Intuitive%20logo%20RGB-1.png)

Open main navigation

Close main navigation

- English
  
  Show submenu for translations
- [Go to weareintuitive.com](https://weareintuitive.com/)

[Go to weareintuitive.com](https://weareintuitive.com/)

 Hello. How can we help you?

- There are no suggestions because the search field is empty.

1. [Help Center](https://help.intuitivebusinessintelligence.com/?hsLang=en)
2. [Intuitive Dashboards Core Software](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en)
3. [Datafeeds](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#datafeeds)

# Creating a datafeed

## Applies to v4.5 and later.

Intuitive Dashboards retrieves raw data via **datafeeds**. To create a datafeed, firstly a [**connection**](https://help.intuitivebusinessintelligence.com/creating-connections?hsLang=en)to the source system will be required. Once a datafeed has been created, multiple [**datasets**](https://help.intuitivebusinessintelligence.com/creating-a-dataset?hsLang=en)can be created from the single datafeed.

 How to create a datafeed:

1. Select **Main Menu->Datafeed Builder->New Datafeed**![DatafeedNew](https://help.intuitivebusinessintelligence.com/hs-fs/hubfs/DatafeedNew.jpg?width=380&name=DatafeedNew.jpg)
2. Specify the **connection **you wish to base the datafeed on, by browsing the folder structure in the Connection Navigator or simply typing the title of the connection in the **search** field.  
   ![ConnectionNavigation_02](https://help.intuitivebusinessintelligence.com/hs-fs/hubfs/ConnectionNavigation_02.jpg?width=552&name=ConnectionNavigation_02.jpg)
3. Depending on the connection type (ODBC/Spreadsheet/Text), the drop down options in the tree view will determine if you need to specify a Raw SQL Statement, choose a table or a sheet from a spreadsheet. In the case above, the connection is an ODBC connection.
4. Where a Raw SQL Statement or table is selected, a SQL editor is available via the Edit Raw SQL Icon.  
   ![DatafeedRawSQLIcon](https://help.intuitivebusinessintelligence.com/hs-fs/hubfs/DatafeedRawSQLIcon.jpg?width=198&name=DatafeedRawSQLIcon.jpg)
5. The SQL will need to be **validated** before being **saved** to the datafeed.  
   ![DatafeedSQLEditor_01](https://help.intuitivebusinessintelligence.com/hs-fs/hubfs/DatafeedSQLEditor_01.jpg?width=688&name=DatafeedSQLEditor_01.jpg)**Note**: It is recommended that SQL scripts be developed and tested using a tool such as **TOAD** or **SQL Management Studio** which offer graphical query development. Once the SQL has been developed, you can just copy and paste into the Intuitive **SQL Editor** window. It would also be wise to use **Views** rather than expose your full SQL script here. **Stored procedures** can also be executed from here if preferable using '***Execute StoredProcName***'
6. Enter a datafeed title (optional) and Save the datafeed via the Save ![SaveAsButton](https://help.intuitivebusinessintelligence.com/hs-fs/hubfs/SaveAsButton.jpg?width=37&name=SaveAsButton.jpg) Icon provided on the toolstrip:  
   ![DatafeedIcons](https://help.intuitivebusinessintelligence.com/hs-fs/hubfs/DatafeedIcons.jpg?width=688&name=DatafeedIcons.jpg)
7. Optionally, publish ![sc60](https://help.intuitivebusinessintelligence.com/hs-fs/hubfs/sc60.png?width=24&name=sc60.png) the datafeed to the group structure so it can be used by other dataset designers.

 

- [Intuitive Dashboards Core Software](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#main-content)
  
  
  
  
  
    - [Getting Started](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#getting-started)
    - [Viewing Dashboards](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#viewing-dashboards)
    - [Interacting with dashboards](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#interacting-with-dashboards)
    - [Filters](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#filters)
    - [Connections](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#connections)
    - [Datafeeds](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#datafeeds)
    - [Datasets](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#datasets)
    - [Components](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#components)
    - [Creating Dashboards and Components - Overview](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#creating-dashboards-and-components-overview)
    - [Creating Components](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#creating-components)
    - [Creating a Dashboard](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#creating-a-dashboard)
    - [Administering the System](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#administering-the-system)
    - [Administering Users](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#administering-users)
    - [Administering Groups](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#administering-groups)
    - [Security Filters - V5.2 and earlier](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#security-filters-v5-2-and-earlier)
    - [Security Filters - V5.3 Onward](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#security-filters-v5-3-onward)
    - [Embedding Dashboards](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#embedding-dashboards)
    - [Configuration File](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#configuration-file)
    - [Installation & Configuration Guide](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#installation-configuration-guide)
    - [Version History](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#version-history)
- [Intuitive for PaperCut V2](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-v2?hsLang=en#main-content)
  
  
  
  
  
    - [Installing Intuitive for PaperCut](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-v2?hsLang=en#installing-intuitive-for-papercut)
    - [Viewing PaperCut Dashboards](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-v2?hsLang=en#viewing-papercut-dashboards)
    - [Editing PaperCut Dashboards](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-v2?hsLang=en#editing-papercut-dashboards)
    - [Intuitive for PaperCut Demonstration Videos](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-v2?hsLang=en#intuitive-for-papercut-demonstration-videos)
    - [Intuitive for PaperCut FAQs](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-v2?hsLang=en#intuitive-for-papercut-faqs)
- [Intuitive for PaperCut MF V3](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-mf-v3?hsLang=en#main-content)
  
  
  
  
  
    - [Installing Intuitive for PaperCut Version 3](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-mf-v3?hsLang=en#installing-intuitive-for-papercut-version-3)
    - [Viewing the dashboards - Intuitive for PaperCut Version 3](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-mf-v3?hsLang=en#viewing-the-dashboards-intuitive-for-papercut-version-3)
    - [Editing PaperCut Dashboards](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-mf-v3?hsLang=en#editing-papercut-dashboards)
    - [Intuitive for PaperCut FAQs](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-mf-v3?hsLang=en#intuitive-for-papercut-faqs)
- [Intuitive for SAFEQ](https://help.intuitivebusinessintelligence.com/intuitive-for-safeq?hsLang=en#main-content)
  
  
  
  
  
    - [General Help](https://help.intuitivebusinessintelligence.com/intuitive-for-safeq?hsLang=en#general-help)
    - [Software Installation](https://help.intuitivebusinessintelligence.com/intuitive-for-safeq?hsLang=en#software-installation)
    - [Solution Expertise](https://help.intuitivebusinessintelligence.com/intuitive-for-safeq?hsLang=en#solution-expertise)
- [Intuitive For Managed Print Services (MPS)](https://help.intuitivebusinessintelligence.com/intuitive-for-managed-print-services-mps?hsLang=en#main-content)
  
  
  
  
  
    - [Intuitive for MPS - Overview](https://help.intuitivebusinessintelligence.com/intuitive-for-managed-print-services-mps?hsLang=en#intuitive-for-mps-overview)
    - [Intuitive for MPS - Installation Steps](https://help.intuitivebusinessintelligence.com/intuitive-for-managed-print-services-mps?hsLang=en#intuitive-for-mps-installation-steps)
    - [Intuitive for MPS - Import File Layouts](https://help.intuitivebusinessintelligence.com/intuitive-for-managed-print-services-mps?hsLang=en#intuitive-for-mps-import-file-layouts)
    - [Intuitive For MPS - Loading the Data Warehouse](https://help.intuitivebusinessintelligence.com/intuitive-for-managed-print-services-mps?hsLang=en#intuitive-for-mps-loading-the-data-warehouse)
- [Intuitive Cloud Services](https://help.intuitivebusinessintelligence.com/intuitive-cloud-services?hsLang=en)
- [Intuitive for PaperCut Hive V1](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-hive-v1?hsLang=en#main-content)
  
  
  
  
  
    - [Viewing the dashboards - Intuitive for PaperCut Hive](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-hive-v1?hsLang=en#viewing-the-dashboards-intuitive-for-papercut-hive)
- [Intuitive for SAFEQ Cloud](https://help.intuitivebusinessintelligence.com/intuitive-for-safeq-cloud?hsLang=en#main-content)
  
  
  
  
  
    - [Intuitive Solution Expertise](https://help.intuitivebusinessintelligence.com/intuitive-for-safeq-cloud?hsLang=en#intuitive-solution-expertise)
    - [Intuitive Software Provisioning](https://help.intuitivebusinessintelligence.com/intuitive-for-safeq-cloud?hsLang=en#intuitive-software-provisioning)
- [Intuitive for Docuware](https://help.intuitivebusinessintelligence.com/intuitive-for-docuware?hsLang=en)
- [Intuitive for Print Management](https://help.intuitivebusinessintelligence.com/intuitive-for-print-management?hsLang=en#main-content)
  
  
  
  
  
    - [Solution Knowledge](https://help.intuitivebusinessintelligence.com/intuitive-for-print-management?hsLang=en#solution-knowledge)
    - [Technical Information](https://help.intuitivebusinessintelligence.com/intuitive-for-print-management?hsLang=en#technical-information)
- [Intuitive for e-BRIDGE Global Print](https://help.intuitivebusinessintelligence.com/intuitive-for-e-bridge-global-print?hsLang=en)
- [Intuitive for e-FOLLOW Cloud](https://help.intuitivebusinessintelligence.com/intuitive-for-e-follow-cloud?hsLang=en)
- [FAQ](https://help.intuitivebusinessintelligence.com/faq?hsLang=en#main-content)
  
  
  
  
  
    - [Connections](https://help.intuitivebusinessintelligence.com/faq?hsLang=en#connections)
    - [General Enquiries](https://help.intuitivebusinessintelligence.com/faq?hsLang=en#general-enquiries)
    - [Datafeeds](https://help.intuitivebusinessintelligence.com/faq?hsLang=en#datafeeds)
    - [Datasets](https://help.intuitivebusinessintelligence.com/faq?hsLang=en#datasets)
    - [System Compatability](https://help.intuitivebusinessintelligence.com/faq?hsLang=en#system-compatability)
    - [Software Installation](https://help.intuitivebusinessintelligence.com/faq?hsLang=en#software-installation)

[![Chill listening crop-3](https://help.intuitivebusinessintelligence.com/hs-fs/hubfs/Intuitive%20logo%20BLACK.png?width=102&height=24&name=Intuitive%20logo%20BLACK.png "Chill listening crop-3")](https://help.intuitivebusinessintelligence.com?hsLang=en)

weareintuitive.com Help Center

Copyright © 2026, Intuitive Business Intelligence Limited