7 Replies Latest reply: May 16, 2018 6:35 AM by Steve Dark RSS

    OData support

    Edward Zents

      Hello,

       

      I am wondering to what extend OData is supported by Qlik. I can't try it out because apparently I need a customer or partner account to download the Qlik Web Connector. Is there any possibility to get a trial for this web connector? I have the following questions about the OData connector:

      Looking forward to any help, thanks

        • Re: OData support
          Steve Dark

          Hi Edward,

           

          The latest download can be retrieved from here:

          https://da3hntz84uekx.cloudfront.net/WebConnectors/2.28.7/2/_MSI/QlikWebConnectorsNovember2017Patch2.zip

           

          As OData is a Premium connector you will need to get a trial licence to be able to give this a go.  You should look to find a local Qlik Partner who should be able to provide this for you.  If you are in the UK please get in touch.

           

          Cheers,

          Steve

            • Re: OData support
              Edward Zents

              Thanks for your reply Steve. Do you know if the web connector only supports OData v3? If so applying for a trial license would be kind of pointless. Otherwise I'll start looking into getting a trial license.

                • Re: OData support
                  Steve Dark

                  Hi  Edward,

                   

                  I'm afraid I don't have a service I can connect to to test - unless you are aware of an open endpoint I can test for you?

                   

                  The last entry in the change log for the version I have is for October 2016.  There may be a subsequent one though - as I am due an upgrade.

                   

                  Getting a trial licence is not a big issue, and it is relatively quick to set-up and test.

                   

                  Steve

                    • Re: OData support
                      Edward Zents

                      Hi Steve, thank you for your time. An open v4 endpoint is the TripPin service which can be found at: http://services.odata.org/V4/(S(uvirdrvfpbph5stgebkebtf2))/TripPinServiceRW/

                       

                      That entry is quite promising then as OData v4 was released 2 years before it.

                       

                      Edward

                        • Re: OData support
                          Steve Dark

                          I've not put long into trying, but it doesn't seem to be playing ball:

                          2018-05-11_16-08-34.png

                          It looks like it is always expecting authentication - which I suppose is a reasonable assumption that there will be some.

                           

                          bal or bam may be able to help you out as to whether OData v4 is possible with the connector.

                           

                          Steve

                            • Re: OData support
                              Edward Zents

                              Little update on this, I've since gotten my hands on a license for the OData connector. It is possible to connect to OData v4 sources but it looks like the connector only accepts XML return values.

                               

                              System query options can be used in the connector but sub queries seem to be ignored (for example $expand=something($select=Name)). And using the $expand options returns a table which adds the expanded entities as new rows, see here: Working with OData relational data. I'm not sure why this happens but it makes working with the data a hassle.

                                • Re: OData support
                                  Steve Dark

                                  I've not yet encountered an API that doesn't have quirks.

                                   

                                  When working with REST sources different hierarchical levels of data are all returned in a single table, with columns returning null when the row is not at the level that column is for.  You need to pull the whole grouped table into a temporary table in Qlik and then do a number of resident loads, where a column in each hierarchy is non-null, to split into the constituent tables.

                                   

                                  It sounds as if the OData connector may be doing something similar?

                                   

                                  Glad you got a trial licence and can connect.  Hope you can make it work for what you require it to do.