You are here

Understanding Qlikview Data Sources

Lots of companies use data warehouses to obtain a single data source. Much of the time, this is only of limited help, because it takes too long to generate and maintain reports for users. Recently, QlikView launched its' “Direct Discovery” feature, which makes a data source database accessible to reports on demand. In its' standard settings, QlikView uploads all the necessary data into a column store database in advance. However, when needed, the Direct Discovery function enables it to access data from SQL data sources, to complement the column store database. To analyse your information, you can combine sources of data from different suppliers and vendors into one QlikView application.
 Accessible Data with Qlickview Technology
-Utilize the connectors from third parties, database suppliers or QlikTech to extract data. The ODBC connector is another option as well.
-Utilize QlikView data technology to link to data files like XML, websites and spreadsheets.
-Utilize QVX technology to create a customized data source connector.
-Utilize the Direct Discovery feature to perform database analysis.
 Developing the Right Data Model
You need to determine precisely which rows and columns you need, before including them in your data model. Superfluous fields can result in avoidable performance problems, confusion and additional work. Testing ideas with extra fields is OK, but trim down after you find out what you need. Also, bear in mind that QlikView associations function in a vastly different manner to the SQL equivalent. In all likelihood, you are already aware of the fact that fields with identical names in several tables will associate. Whenever there are several fields with identical names, this generates a synthetic key — which is never desirable. If you notice additional tables with dollar signs in their names, you should go back to the drawing board and reconsider the design of your data model. Rather than trying to join fact tables together, it is better to concatenate them. This is true in almost every situation. By doing this, you can include numerous columns with identical names, and QlikView will display their values as a single field. The values from the concatenated tables will be extracted, whenever a user selects one of the single field values. In particular, this method is helpful when extracting information from multiple sources, or when incorporating predictive or financial information into the design of your model.
 Convenient and Easy to use Software
QlikView is user friendly technology that can benefit all types of businesses. It is easy for IT professionals to work with too. The majority of people learn to use the software in under sixty minutes. QlikView has a reputation for being a tool that creates glossy and interactive graphs, however it is of little use without access to reliable data sources. Typically, over fifty percent of the development time should be spent on designing and testing data management methods. By making the effort to do this, your QlikView project will be much more likely to succeed.