Qlik Sense with IssueTrak

[jas0012qlik]

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.

[petter]

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

[jas0012qlik]

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

[petter]

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.