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

[fiware-stackoverflow] How to connect Orion Context Broker with SQL Server

    Details

      Description

      Created question in FIWARE Q/A platform on 28-08-2019 at 12:08
      Please, ANSWER this question AT https://stackoverflow.com/questions/57690644/how-to-connect-orion-context-broker-with-sql-server

      Question:
      How to connect Orion Context Broker with SQL Server

      Description:
      Is there any way to send the entities from Orion Context Broker to SQL Server by using docker compose file?

      Right now, Orion subscribes to the entities and Quantum Leap notifies the Crate DB when there is a change for those entities. However, Crate DB is not what I want and this is the reason: https://community.powerbi.com/t5/Desktop/Direct-Query-for-PostgreSQL/m-p/776979/highlight/true#M374297

      So basically my question is, if there is any way to replace the Crate DB with any of these supported ones: https://docs.microsoft.com/en-us/power-bi/desktop-directquery-data-sources.
      (I randomly chose the SQL Server but any other is fine)

        Activity

        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Open Open In Progress In Progress
        2h 59m 1 Backlog Manager 29/Aug/19 3:06 AM
        In Progress In Progress Answered Answered
        3h 1 Backlog Manager 29/Aug/19 6:06 AM
        Answered Answered Closed Closed
        4d 5h 36m 1 Backlog Manager 02/Sep/19 11:42 AM
        fla Fernando Lopez made changes -
        Fix Version/s 2021 [ 12600 ]
        Hide
        backlogmanager Backlog Manager added a comment -

        2019-09-02 11:42|UPDATED status: transition Finish| # answers= 1, accepted answer= True

        Show
        backlogmanager Backlog Manager added a comment - 2019-09-02 11:42|UPDATED status: transition Finish| # answers= 1, accepted answer= True
        backlogmanager Backlog Manager made changes -
        Resolution Done [ 10000 ]
        Status Answered [ 10104 ] Closed [ 6 ]
        fla Fernando Lopez made changes -
        HD-Enabler Quantum-Leap [ 11558 ]
        Description
        Created question in FIWARE Q/A platform on 28-08-2019 at 12:08
        {color: red}Please, ANSWER this question AT{color} https://stackoverflow.com/questions/57690644/how-to-connect-orion-context-broker-with-sql-server


        +Question:+
        How to connect Orion Context Broker with SQL Server

        +Description:+
        Is there any way to send the entities from Orion Context Broker to SQL Server by using docker compose file?

        Right now, Orion subscribes to the entities and Quantum Leap notifies the Crate DB when there is a change for those entities. However, Crate DB is not what I want and this is the reason: https://community.powerbi.com/t5/Desktop/Direct-Query-for-PostgreSQL/m-p/776979/highlight/true#M374297

        So basically my question is, if there is any way to replace the Crate DB with any of these supported ones: https://docs.microsoft.com/en-us/power-bi/desktop-directquery-data-sources.
        (I randomly chose the SQL Server but any other is fine)
        Created question in FIWARE Q/A platform on 28-08-2019 at 12:08
        {color: red}Please, ANSWER this question AT{color} https://stackoverflow.com/questions/57690644/how-to-connect-orion-context-broker-with-sql-server


        +Question:+
        How to connect Orion Context Broker with SQL Server

        +Description:+
        Is there any way to send the entities from Orion Context Broker to SQL Server by using docker compose file?

        Right now, Orion subscribes to the entities and Quantum Leap notifies the Crate DB when there is a change for those entities. However, Crate DB is not what I want and this is the reason: https://community.powerbi.com/t5/Desktop/Direct-Query-for-PostgreSQL/m-p/776979/highlight/true#M374297

        So basically my question is, if there is any way to replace the Crate DB with any of these supported ones: https://docs.microsoft.com/en-us/power-bi/desktop-directquery-data-sources.
        (I randomly chose the SQL Server but any other is fine)
        fla Fernando Lopez made changes -
        Assignee MARTEL [ smartsdk_martel ]
        Hide
        backlogmanager Backlog Manager added a comment -

        2019-08-29 06:06|UPDATED status: transition Answered| # answers= 1, accepted answer= False

        Show
        backlogmanager Backlog Manager added a comment - 2019-08-29 06:06|UPDATED status: transition Answered| # answers= 1, accepted answer= False
        backlogmanager Backlog Manager made changes -
        Status In Progress [ 3 ] Answered [ 10104 ]
        Hide
        backlogmanager Backlog Manager added a comment -

        2019-08-29 03:06|UPDATED status: transition Answer| # answers= 1, accepted answer= False

        Show
        backlogmanager Backlog Manager added a comment - 2019-08-29 03:06|UPDATED status: transition Answer| # answers= 1, accepted answer= False
        backlogmanager Backlog Manager made changes -
        Status Open [ 1 ] In Progress [ 3 ]
        backlogmanager Backlog Manager made changes -
        Field Original Value New Value
        Component/s FIWARE-TECH-HELP [ 10278 ]
        Hide
        backlogmanager Backlog Manager added a comment -

        2019-08-29 00:06|CREATED monitor | # answers= 1, accepted answer= False

        Show
        backlogmanager Backlog Manager added a comment - 2019-08-29 00:06|CREATED monitor | # answers= 1, accepted answer= False
        backlogmanager Backlog Manager created issue -

          People

          • Assignee:
            smartsdk_martel MARTEL
            Reporter:
            backlogmanager Backlog Manager
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: