Uploaded image for project: 'Help-Desk'
  1. Help-Desk
  2. HELP-5374

FIWARE.Request.Tech.Apps.DataViz-SpagoBI.: SpagoBI Server + SpagoBI Studio + MongoDB. Is it possible?.

    Details

    • Type: extRequest
    • Status: Closed
    • Priority: Major
    • Resolution: Done
    • Fix Version/s: 2021
    • Component/s: FIWARE-TECH-HELP
    • Labels:
      None

      Description

      Hi there,
      Our company is currently trying to get in touch with the SpagoBI
      technologies but we are unable overcome some technical difficulties.
      Is MongoDb currently fully supported by SpagoBI?

      Our first and main task is to display some charts in our SpagoBI Server
      (e.g. active vs total users, sales by month, etc)
      Can this only be achieved by using SpagoBI Studio?

      What we've accomplished:

      • Our SpagoBI Server is running and our remote MongoDB database was
        added as new data source

      Our obstacles:

      • We can't add MongoDb as Data Connection in SpagoBI Studio

      We've been reading the documentation but we've found very few
      information about SpagoBI and MongoDb.
      Can you point us to some direction that could help us to bring some
      light over this subject?

      Best Regards,
      João Claro

      Since January 1st, old domains won't be supported and messages sent to any domain different to @lists.fiware.org will be lost.
      Please, send your messages using the new domain (Fiware-tech-help@lists.fiware.org) instead of the old one.
      _______________________________________________
      Fiware-tech-help mailing list
      Fiware-tech-help@lists.fiware.org
      https://lists.fiware.org/listinfo/fiware-tech-help
      [Created via e-mail received from: =?UTF-8?Q?Jo=c3=a3o_Claro?= <joaoclaro@stratio.pt>]

        Activity

        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Open Open In Progress In Progress
        1d 22h 50m 1 Davide Zerbetto 24/Nov/15 3:03 PM
        In Progress In Progress Answered Answered
        5s 1 Davide Zerbetto 24/Nov/15 3:03 PM
        Answered Answered Closed Closed
        6d 1m 1 Davide Zerbetto 30/Nov/15 3:04 PM
        fla Fernando Lopez made changes -
        Fix Version/s 2021 [ 12600 ]
        mev Manuel Escriche made changes -
        HD-Enabler SpagoBI [ 10856 ]
        HD-Chapter Apps [ 10836 ]
        backlogmanager Backlog Manager made changes -
        Summary FIWARE.Question.Tech.Apps.DataViz-SpagoBI.: SpagoBI Server + SpagoBI Studio + MongoDB. Is it possible? FIWARE.Request.Tech.Apps.DataViz-SpagoBI.: SpagoBI Server + SpagoBI Studio + MongoDB. Is it possible?.
        mev Manuel Escriche made changes -
        Sender Email joaoclaro@stratio.pt
        mev Manuel Escriche made changes -
        Summary FIWARE.Question.Lab.Apps.DataViz-SpagoBI.: SpagoBI Server + SpagoBI Studio + MongoDB. Is it possible? FIWARE.Question.Tech.Apps.DataViz-SpagoBI.: SpagoBI Server + SpagoBI Studio + MongoDB. Is it possible?
        zerbetto Davide Zerbetto made changes -
        Resolution Done [ 10000 ]
        Status Answered [ 10104 ] Closed [ 6 ]
        zerbetto Davide Zerbetto made changes -
        Status In Progress [ 3 ] Answered [ 10104 ]
        zerbetto Davide Zerbetto made changes -
        Status Open [ 1 ] In Progress [ 3 ]
        Hide
        zerbetto Davide Zerbetto added a comment -

        Hi João,
        you can develop charts using SpagoBI and MongoDB: you have to define a MongoDB data source in SpagoBI (as you did), then a SpagoBI dataset (I think you are missing this item), and then you can define a chart using SpagoBI Studio that is using the SpagoBI dataset. For documentation of charts have a look here.
        Using MongoDB you cannot neither add it as a connection in SpagoBI Studio nor define a business model with SpagoBI Meta, since MongoDB hasn't structured data.
        Pay attention to the fact that we recently removed HighchartsJS from FIWARE distribution for license problems: look here for details. In case you can use HighchartsJS according to its license or you want to buy it, please contact us. As free alternatives to Highcharts, look at ExtJS or JFreeChart charts.
        Hope this helps.
        Best regards
        Davide

        Show
        zerbetto Davide Zerbetto added a comment - Hi João, you can develop charts using SpagoBI and MongoDB: you have to define a MongoDB data source in SpagoBI (as you did), then a SpagoBI dataset (I think you are missing this item), and then you can define a chart using SpagoBI Studio that is using the SpagoBI dataset. For documentation of charts have a look here . Using MongoDB you cannot neither add it as a connection in SpagoBI Studio nor define a business model with SpagoBI Meta, since MongoDB hasn't structured data. Pay attention to the fact that we recently removed HighchartsJS from FIWARE distribution for license problems: look here for details. In case you can use HighchartsJS according to its license or you want to buy it, please contact us. As free alternatives to Highcharts, look at ExtJS or JFreeChart charts. Hope this helps. Best regards Davide
        zerbetto Davide Zerbetto made changes -
        Summary [Fiware-tech-help] SpagoBI Server + SpagoBI Studio + MongoDB. Is it possible? FIWARE.Question.Lab.Apps.DataViz-SpagoBI.: SpagoBI Server + SpagoBI Studio + MongoDB. Is it possible?
        mev Manuel Escriche made changes -
        Assignee Davide Zerbetto [ davide.zerbetto ]
        backlogmanager Backlog Manager made changes -
        Field Original Value New Value
        Component/s FIWARE-TECH-HELP [ 10278 ]
        fw.ext.user FW External User created issue -

          People

          • Assignee:
            zerbetto Davide Zerbetto
            Reporter:
            fw.ext.user FW External User
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: