[Fiware-tech-help] How to fetch historical data?

[Juanjo Hierro]

Dear Krishan,

   GUIs of applications tend to be tailor-made.  Nevertheless, I will 
try to give you some hints that I hope can be useful:

  * Knowage <https://github.com/KnowageLabs/Knowage-Server> is a very
    complete business intelligence tool that comprises many functions
    including those for producing reports on historic data which has
    beeen stored in data-sinks using Cygnus.  It also include some
    functions for creating dashboards.
  * Operational dashboards which query directly on the Orion Context
    Broker or some other data services can also be based on Wirecloud
    <https://github.com/Wirecloud/wirecloud>.
  * STH-Comet <https://github.com/telefonicaid/fiware-sth-comet> can be
    used to store raw and aggregated time series context information in
    MongoDB which then you can get access to using an API
  * You can also use QuantumLeap
    <https://smartsdk.github.io/ngsi-timeseries-api/> for transferring
    historic data into time series databases and then use some GUI tools
    for visualizing data (e.g., Grafana). This is useful is some use cases.

   I add people from the Eng and FICodes teams in case they want to add 
something regarding Knowage and Wirecloud.

   Let us know if these hints bring answer to your questions.

   I would like to take advantage of this mail to let you know that we 
have re-structure contents of the FIWARE developers' page 
<https://developer.fiware.org/> and the FIWARE Catalogue 
<https://www.fiware.org/developers/catalogue/>.  We will continue 
working on improving it based on feedback.

   Cheers,

   Juanjo


On 14/05/2018 08:45, Krishan Babbar wrote:
>
> Any input?
>
> Thanks & Regards,
>
> *_Krishan Babbar_**__*
>
> */Technical Architect/*//
>
> *_IES Internet of Things_**_|_**_ Tech Mahindra_*
>
> Rajiv Gandhi Chandigarh Technology Park, Plot No. 23, Phase 2, 
> Kishangarh, Chandigarh 160101, INDIA
>
> (Office: +91 172 666 8400 Ext. 8352 *| *Mobile: +91 946 303 0996
>
> ============================================================================================================================
> Disclaimer: This message and the information contained herein is 
> proprietary and confidential and subject to the Tech Mahindra policy 
> statement, you may review the policy at 
> http://www.techmahindra.com/Disclaimer.html externally 
> http://tim.techmahindra.com/tim/disclaimer.html internally within 
> TechMahindra.
> ===========================================================================================================================
>
> *From:* Krishan Babbar
> *Sent:* Friday, May 11, 2018 2:40 PM
> *To:* Jose Ignacio Carretero <joseignacio.carretero at fiware.org>
> *Cc:* fiware-tech-help at lists.fiware.org; Fernando López Aguilar 
> <fernando.lopez at fiware.org>; Yugal Kishor Mullick 
> <YM00106030 at TechMahindra.com>; PC00474884 at TechMahindra.com
> *Subject:* How to fetch historical data?
>
> Hi Jose,
>
> Thanks for all your support so far.
>
> I have setup Cygnus with MySQL agent and now data is storing into MySQL.
>
> As a next step, we need to show reports of historical data (Saved in 
> Cygnus_MySQL) in GUI. It may be based upon some filters like data for 
> today, last week/month, area wise etc.
>
> My questions are
>
> 1.Do we need to create our own APIs for fetching data from MySQL and 
> returning to GUI application?
>
> 2.Or is there any GUI component (WireCloud or any other) in which we 
> can directly fetch Cygnus Data? Or we need to create our custom GUI 
> ourselves?
>
> 3.I found a component STH-Comet 
> (https://github.com/telefonicaid/fiware-sth-comet), will it fit in our 
> requirements for fetching Cygnus_MySQL data?
>
> 4.Do let me know if Fiware have any other components matching with our 
> requirement.
>
> Thanks & Regards,
>
> *_Krishan Babbar_*
>
> */Technical Architect/*//
>
> *_IES Internet of Things_**_|_**_ Tech Mahindra_*
>
> Rajiv Gandhi Chandigarh Technology Park, Plot No. 23, Phase 2, 
> Kishangarh, Chandigarh 160101, INDIA
>
> (Office: +91 172 666 8400 Ext. 8352 *| *Mobile: +91 946 303 0996
>
> ============================================================================================================================
> Disclaimer: This message and the information contained herein is 
> proprietary and confidential and subject to the Tech Mahindra policy 
> statement, you may review the policy at 
> http://www.techmahindra.com/Disclaimer.html externally 
> http://tim.techmahindra.com/tim/disclaimer.html internally within 
> TechMahindra.
> ===========================================================================================================================
>
> ============================================================================================================================
>
> Disclaimer:  This message and the information contained herein is 
> proprietary and confidential and subject to the Tech Mahindra policy 
> statement, you may review the policy at 
> http://www.techmahindra.com/Disclaimer.html externally 
> http://tim.techmahindra.com/tim/disclaimer.html internally within 
> TechMahindra.
>
> ============================================================================================================================
>
>
>
> __________________________________________________________________________________________
>
> You can get more information about our cookies and privacy policies on the following links:
> - http://forge.fiware.org/plugins/mediawiki/wiki/fiware/index.php/FIWARE_Privacy_Policy
> - http://forge.fiware.org/plugins/mediawiki/wiki/fiware/index.php/Cookies_Policy_FIWARE
>
> Fiware-tech-help mailing list
> Fiware-tech-help at lists.fiware.org
> https://lists.fiware.org/listinfo/fiware-tech-help
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.fiware.org/private/fiware-tech-help/attachments/20180514/79443a2d/attachment-0001.html>