topic Qlik Sense with IssueTrak in App Development

Qlik Sense with IssueTrak

jas0012qlik — Thu, 21 Jun 2018 18:55:10 GMT

Has anyone ever used Qlik Sense to report on data in IssueTrak? We use it as our work order system, and would like to make the data view-able in Qlik, but are not quite sure where to start.

Re: Qlik Sense with IssueTrak

petter — Thu, 21 Jun 2018 19:32:46 GMT

I have noticed that IssueTrak has a RESTful API. That means that it should be possible to get data out of IssueTrak with the help of the Qlik REST Connector: https://help.qlik.com/en-US/connectors/Subsystems/REST_connector_help/Content/REST-connector.htm

Here is the link to IssueTrak API documentation:

Issuetrak Help Center - The Issuetrak RESTful API

Using the Qlik REST Connector can be a technical challenge unless youre already familiar with RESTful APIs.

There is also an option to export data from IssueTrak as CSV files but I dont know if that will provide you with the data you need: Issuetrak Help Center - Exporting Survey Data

Re: Qlik Sense with IssueTrak

jas0012qlik — Thu, 21 Jun 2018 20:26:21 GMT

We run issuetrak on a microsoft sql database. is that compatible?

Re: Qlik Sense with IssueTrak

petter — Fri, 22 Jun 2018 13:37:40 GMT

Well - it might very well be that you can pull the data out of Microsoft SQL Server directly. That depends on how easy the database model in IssueTrak is. Usually an API like the RESTful API will provide the source for where it is best to pull data from actually.

Whether IssueTrak use MS SQL Server or some other database shouldn't matter anything when it comes to the use of the RESTful API.