»

Navigation¶

For Everyone

• Main Website
• Introduction
• Getting Started
• Demo Applications
• Troubleshooting
• Support
• Testimonials
• About
• Support QVSource
• Badges & Logos
  

For QlikView Users

• Google Analytics (demo)
• Twitter (demo)
• Facebook Pages (demo)
• Facebook Insights (demo)
• Sentiment Analysis & Text Analytics
• Mailbox (Imap/Pop3)
• Twingly (Blog Search)
• Google Spreadsheets
• YouTube (demo)
• MailChimp (demo)
• Klout (demo)
• OData
• AdSense
• Notifier
• Twitter Trust & Influence Metrics
• Facebook (demo)
• LinkedIn (demo)
• Other Connectors
  

For Advanced Users

• Running QVSource on a Server
• Enterprise Features
• Cache Management
• Logging QVSource
• Using Multiple Accounts
  

For .NET Developers

• Developing Connectors
• Using the SDK
• Using OAuth
• Caching Data
• Aliasing Column Names
• Checklist
  

Search the wiki
»

Wiki Links

• Create a new Page
• All Pages
• Categories
• Navigation Paths
  

• Administration
• File Management
  

• Create Account
  

OData Connector for QlikView

Tweet

Table of Contents [Hide/Show] OData Sources Usage Change Log

OData Sources¶

The OData Connector opens up a huge number of data sets for QlikView users, including

• Sharepoint 2010.
• Those on the Windows Azure Dataset Marketplace
• Those listed on the official OData website.
• Microsoft Dynamics CRM (Apparently also has an OData option)
• Facebook Insights also provides its data in OData format (see this page for specific details on loading Facebook Insights data into QlikView) This is no longer recommended, please use the dedicated Facebook Insights Connector.
  

Usage¶

When you view the OData connector you should be presented with something similar to the following:



You will need to enter the service endpoint and optionally any credentials. For example if you are connecting to a Dataset in the Windows Azure Dataset Marketplace you will need to enter your Windows Live ID and the key from the account keys section of your account as shown below.



Once you have entered the necessary information for your OData source click the 'Connect' button.



And then move to the 'Connector Data' tab where you should see a list of available tables.

Notice that the top table, named AllTablesList, is an additional table supplied by QVSource which supplies a table listing all the other tables so that you have the option to enumerate through the tables in your load script.



You should now be able to copy the QlikView load script for any required tables into your QlikView application.

Change Log¶

0.9.0 - 07/02/2012

• Connector now renamed from IndustrialCodeBox_ODataConnector to ODataConnector (in generated QlikView script).
• Added entry to specify cache age on a per request basis (in hours).
• Added new AllTablesList table to enumerate available tables in QlikView script.
• Radio buttons added (and domain textbox) to select basic or windows authentication.
• DefaultNetworkCredentials used if no username/password passed and windows authentication selected.
• Option added to set cache time for table data.
  

0.8.3 - 06/02/2012

• Radio buttons added (and domain textbox) to select basic or windows authentication.
• DefaultNetworkCredentials used if no username/password passed and windows authentication selected.
  

0.8.2 - 21/06/2011

• Better error handling on intial connection.
  

0.8.1 - 21/06/2011

• Fixed bug where 'child' columns were being combined into a single column.
• No longer reports total of 0 if total not returned with results.
• Added additional default datasources to the drop down.