10 Replies Latest reply: Dec 29, 2015 8:39 AM by Uzo Aneke RSS

    Qliksense lib connection

    Logesh Jayaraman

      Where does the lib details stored in QlikSense

        • Re: Qliksense lib connection
          Jonathan Poole

          They are stored in the Qlik Sense repository.

           

          Also, in the desktop, there is a reference in the app that allows the connection to be auto-imported into the server repository (unless there is a conflict).

            • Re: Qliksense lib connection
              Logesh Jayaraman

              Thanks Jonathan,

               

              I am looking more in terms of  desktop app. Where the lib is stored in the Desktop app. In load script it always shows the lib:\\connection name.  Would like to know where is the lib:\\ connection name details or mapping details are stored.

                • Re: Qliksense lib connection
                  Jonathan Poole

                  I believe the connection list within a desktop app is saved in the QVF file on the hard drive.

                   

                  If you created a QVF, moved the QVF to a new machine, and opened the QVF on the new machine (new desktop install), you would still see all the same connections from the load editor (they may not work but they are there)

                    • Re: Qliksense lib connection
                      Logesh Jayaraman

                      Thanks Jonathan,

                       

                      I agree but i am looking where does the reference to lib://Connectionname point the connection to the actual path is stored.

                        • Re: Qliksense lib connection
                          Jonathan Poole

                          I'm not sure that there is any further detail available in the context of a desktop scenario.

                           

                          In the server, you can go to the QMC, edit a connection, and see the exact connect string or folder.. specific attributes of the data connection object.

                           

                          its the same with a desktop but i'm not certain there is a desktop API to retrieve this.

                          • Re: Qliksense lib connection
                            Naresh Guntur

                            lib://...... contains the connection string which we create, basically the folder structure.

                             

                            and this will be stored in the .qvf file just like the variables gets stored.

                             

                             

                             

                            Cheers,

                            Naresh

                              • Re: Qliksense lib connection
                                Logesh Jayaraman

                                Naresh i understand it is stored qvf like just like variable. But the question is it possible to access it or where it is stored?

                                  • Re: Qliksense lib connection
                                    Jonathan Dienst

                                    The syntax "lib:" refers to a data file connection. In Desktop, you can view and edit connections in the Data Load Editor.

                                    t1.png

                                    Click the pencil icon to edit - the path will be visible there

                                    t2.png

                                      • Re: Qliksense lib connection
                                        Logesh Jayaraman

                                        Thanks Jonathan, I think i didn't post my question clearly. I understand how to create the connection and how to use it.

                                        For the flat files once you created the connection in the load script it shows the lib://connection name/filename.

                                         

                                        What i am looking is where does the reference actual file path and lib://connection name/ is stored. Is there any config file i can look at it or is it stored internally with in the qvf. Do we have any documentation on this?

                                          • Re: Qliksense lib connection
                                            Uzo Aneke

                                            Don't know if this helps Brindlogcool, but if you look at Jonathan's snapshot above, it does show you the complete path from which the "lib:" statement is stored. The complete path should be viewable from your data load editor page via the pencil icon. So notice in Jonathan's snapshot, his lib path is called "lib://Notepad2/Notepad2". In the right part of the page under "Create New Connections", is a connection called "Notepad2". When you hit the pencil icon it shows you the complete path for that "lib://" connection.

                                             

                                            So in essence it is stored on the qvf, and as long as you have access to the data load editor page, you should be able to reference all the "lib://" connections for that file. If still not clear, send a snapshot that may help to clarify your question further.