Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
I'm new to Qlik Sense and would like to store historical data (which isn't stored within our DB's right now) and I'm looking for the best approach.
1. Store historical data to a dedicated MySQL table
2. Store historical data to a QVD
Both will be updated with increments of changed rows daily (and manually if needed, per special request).
Which approach would be the best?
The data to be stored will be some fields of Jira Issues within particular projects.
Date, Storypoints, Status, Sprint, JiraID, IssueType. This fields are to be populated and stored daily to db or qvd.
That looks reasonable to me, again, the target storage will depend mainly on the consumption of such data.
If you are only exploring and analyzing that data with Qlik tools, definitely go for QVDs, at the end of the day, if a new tool, not planned today, comes in place, you can also connect to JIRA and see.
Depending on your efforts, see if it would be useful to send from JIRA to MySQL then to QVD then to Qlik. It might be a lot of work, but if you will use that data somewhere else, it will be easier to consume from a database than from the JIRA source itself.
If the data is to be consumed exclusively or mostly in Qlik, then QVD. If that data will be used in other tools, then MySQL and QVDs (loading from optimized QVDs is extremely fast in Qlik)
Which mechanism will populate those QVDs though? JIRA -> ??? -> MySQL/QVD.
It depends on various aspects of your environment and you may do both. In regard of performance loading from qvd's is usually much faster as from a db - especially if they are stored on a very fast storage/network and the cardinality of the fields against the number of records is rather low and if they could be loaded optimized.
- Marcus
To populate the MySQL we use G-Scripts. To populate QVD I'm planning to use REST connection directly from Qlik to Jira. Are there other easy to setup ways?
That looks reasonable to me, again, the target storage will depend mainly on the consumption of such data.
If you are only exploring and analyzing that data with Qlik tools, definitely go for QVDs, at the end of the day, if a new tool, not planned today, comes in place, you can also connect to JIRA and see.
Depending on your efforts, see if it would be useful to send from JIRA to MySQL then to QVD then to Qlik. It might be a lot of work, but if you will use that data somewhere else, it will be easier to consume from a database than from the JIRA source itself.