Datafeeds
      Back to home
      1. Help Center
      2. Intuitive Dashboards Core Software
      3. Datafeeds

      Creating a datafeed

      Applies to v4.5 and later.

      Intuitive Dashboards retrieves raw data via datafeeds. To create a datafeed, firstly a connection to the source system will be required. Once a datafeed has been created, multiple datasets can be created from the single datafeed.
      How to create a datafeed:

      1. Select Main Menu->Datafeed Builder->New DatafeedDatafeedNew
      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
      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
      5. The SQL will need to be validated before being saved to the datafeed.
        DatafeedSQLEditor_01Note: 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 Icon provided on the toolstrip:
        DatafeedIcons
      7. Optionally, publish sc60 the datafeed to the group structure so it can be used by other dataset designers.