We have a database in SQL Server Azure with has informational data. The informational database has many tables like A, B, Index fragmentation etc. Now each of these tables hold some metric like if the index fragmentation is less then we can show that on ‘qlik sense dashboard’. So we are planning to have a report on dashboard. Now, what should be the approach, connect sql server azure DB to Qlik sense or view directly( is it possible??) or have ssrs report created and then from there pull data into Qliksense/view. Let me know your thoughts. Let me know what is the best way..
As long as those metrics are stored into a table or procedure and somehow accessible via a driver (ODBC, MSSQL DSN, etc.), they can be loaded into QlikView or Qlik Sense as with any other data.
Once you have it loaded you can create the charts to meet your requirements.
As long as those metrics are stored into a table or procedure and somehow accessible via a driver (ODBC, MSSQL DSN, etc.), they can be loaded into QlikView or Qlik Sense as with any other data.
Once you have it loaded you can create the charts to meet your requirements.
.png "Miguel_Angel_Baeyens"){kind=avatar}
