Table responsible for storing information about Qlik Sense Tasks Execution Results. Important attributes, are nearly the same as you can see in QMC under Engine configuration section: Identifier ( ID), Listener ports ( ListenerPortsString), Autosave option ( AutosaveInterval), Document timeout on server ( DocumentTimeout), Table files directory (legacy in shared persistence environment) ( TableFilesDirectory), Working sets low / high ( WorkingSetSizeLoPct, WorkingSetSizeHiPct), Object calculation time limit ( ObjectTimeLimitSec), QRS notification port ( QrsHttpNotificationPort), Creation of search index on reload ( CreateSearchIndexOnReloadEnabled) Table responsible for storing information about Qlik Sense Engine Service configuration in server node. Important attributes: Identifier ( ID), Deleted (if engine row was recently deleted) ( Deleted), Server node configuration identifier ( ServerNodeConfiguration_ID) Table responsible for storing information about Qlik Sense Engine Services information in server node. Important attributes: Name (name of data connection) ( Name), Connection string (either path or connection string of data connection) ( ConnectionString), Identifier ( ID), username and password for data connections ( Username, PasswordString – hold your horses not a plain text), Owner Identitifers ( Owner_ID, File_ID, App_ID) ![]() Table responsible for storing information about Qlik Sense applications data connections in environment, folders, odbc / OleDB drivers etc. Important attributes: Name (particulary name of sheet, measure etc.) ( Name), Object Type (measure, sheet etc.) ( ObjectType), Identifier ( ID), status whether it is published / community or self sheet ( Published, Approved), Owner and Application and File Identitifers ( Owner_ID, File_ID, App_ID), Engine object identifier (used when accessing particular sheet in URL ( EngineObjectId) Table responsible for storing information about Qlik Sense applications objects in environment, like sheets, bookmarks, stories. Important attributes: Name ( Name), Identifier ( ID), status whether it is published or not ( Published), Owner and Stream Identitifers ( Owner_ID, Stream_ID) Table responsible for storing information about Qlik Sense applications in environment. Below description is based on Qlik Sense Version 3.2 SR 4 table structure it can be a point of change in future releases. Notice: Below description is solely based on my understanding of the tables, please do not treat it as an official documentation, and remember that changing / manipulating with Qlik Sense Repository Database is not supported by Qlik. ![]() What is worth mentioning here is that most of QS Repository Database tables names are pretty self explanatory – good job Qlik. ![]() Welcome in second part of a 3 part cycle Qlik Sense Repository Database under the hood, in previous article you’ve learnt how to connect to Qlik Sense database and why it may come in handy, this one will give you an overview and brief description of „essential” – from my perspective – tables inside of Qlik Sense Repository Database.
0 Comments
Leave a Reply. |