Integrating Qlik with Salesforce [Setup + Examples]

Integrating Qlik with Salesforce [Setup + Examples]

By Stiliyan Neychev

December 4, 2023

Salesforce, a leading CRM globally, is renowned for its myriad capabilities that foster business growth.  Its integration prowess is a pivotal factor setting it apart from other CRM platforms, prompting us to delve into the seamless collaboration of Salesforce and Qlik in this article. 

Since we’re big fans of Qlik’s easy-to-use interface and its numerous features, we decided it’d be good to share with you all why we believe integrating Qlik with Salesforce instance would be beneficial to your company. 

Table of Contents

What Are the Benefits of Integrating Qlik with Salesforce? 

The Three Modes of Qlik Salesforce Integration 

Qlik Salesforce Integration: Example Use Cases 

Qlik Salesforce Integration Setup 

Integrating Qlik with Salesforce FAQs 

Qlik and Salesforce Integration: Next Steps

What Are the Benefits of Integrating Qlik with Salesforce? 

Before we begin, it’s worth mentioning that Salesforce has its own charts and visualizations and can present the data it’s storing. However, they’re quite limited, and this brings us to the first benefit – compared to Salesforce, Qlik is more robust, agile and provides a much more customizable visualization of your data. On top of that, Qlik’s UI is much more simplified; therefore, it can provide you with powerful tools without making it difficult for the users to maneuver around. Additionally, by integrating Qlik within your Salesforce instance, you open yourself up to more data sources, since Salesforce can only visualize the information you have within the platform. This benefit can, for example, mean getting access to public data that would help you make more informed decisions on potential customers. 

All these benefits, combined with the fantastic mobile application Salesforce provides, equals a more natural, clear, and complete understanding of your company goals and strategy for your employees. By taking advantage of Qlik, they can tap into the right data at the right time while on the move towards their next potential sale. 

You May Also Like: How Sales Analytics in Qlik Sense Improve Performance and Profitability Insights 

The Three Modes of Qlik Salesforce Integration 

Qlik Application Using a Salesforce Data Model 

So, we’ve touched on this subject a bit earlier. Still, to reiterate, you can integrate your Salesforce data into a Qlik application via a native data connector and make a Qlik application based on it. 

This first mode of integration provides you with a great bridge between your data and the insight you are looking to take away from it.  The flexibility to combine Salesforce data with external sources provides a competitive advantage. 

Screenshot of a Salesforce dashboard displaying various key performance indicators (KPIs) for sales metrics. It includes drop-down menus for KPI Period and filters for year, quarter, month, campaign name, lead name, and opportunity name. The dashboard shows visualizations such as a funnel chart for Leads to Opportunities Won, a bar graph comparing Actual vs. Expected Amount, and a table for Top 5 Opportunities by Status. There are line graphs for Opportunities and Leads over the rolling 12 months. Data is up to date as of 03/31/2017. Icons for Salesforce and other functionalities are visible.

Embedding Qlik Elements into Salesforce 

To get even more benefits out of this integration, you will have to use the next mode of integration – the possibility of embedding separate dashboards, objects, or even mashups within your Salesforce instance. This allows you to implement various Qlik apps in your Salesforce custom pages, or even combine specific objects from several apps into one custom tab. 

This second part is quite beneficial when you need some “straight to the point” information quickly because you could just go to the appropriate tab and view all the key information there. 

The best part is you won’t need to jump between different platforms and apps and log into several places at once just to view a few KPIs, because you’ll have everything in one place – Salesforce. 

Alt text: "Screenshot of a Salesforce dashboard titled 'Partner Analysis'. It features various widgets including a line graph labeled 'Quarter Over Quarter Analysis (Closed Won)' showing fluctuations in revenue over four quarters, and a large bar chart titled 'Total Closed Won by Account (Partner)' displaying revenues by partner accounts. There's also a colorful treemap named 'Partner Breakdown by Industry' categorizing partners into industries such as Education, Services, and Chemicals. The dashboard offers filters by year, quarter, and opportunity type. The interface has tabs like Home, Chatter, Campaigns, Leads, and more, indicative of the Salesforce platform.

Update Salesforce Data Through Qlik 

The final aspect to cover is the ability to fill in or update fields in Salesforce through Qlik.  While not immediately apparent, this capability proves valuable for tasks like daily field updates based on previous day performance or adjusting price fields to reflect current discounts. 

Composite image showing a Salesforce workflow with three screens. The left screen displays an account detail page for 'Applied Microfilm' with a notification about a recent address change by the integration system. The middle screen shows a tabular list of customer records, including details like account name, owner, and industry. The right screen features an interactive map titled 'Select a single Account 50 miles of Applied Microfilm' with a color-coded travel area and various points marked, indicating the account locations within the specified radius. Below the map, options to adjust the travel range for nearby accounts are present. An arrow points from the account detail to the map, indicating the flow of information.

Qlik Salesforce Integration: Example Use Cases

So far, we’ve talked a great deal about the various benefits of the integration, but how about some examples. For starters, from the previous section, we touched on the possibility of creating mashups with the help of the embedding aspect. 

This way, we can provide the salespeople with the company’s portfolio performance, competition situation, and market shares for a clearer picture of the current state of affairs. 

Likewise, they can also have connecting pages that also show the ongoing marketing strategies and promotions, and maybe even some other key performance indicators (KPIs) or key object descriptions (KODs). Knowing all the relevant information for their customer provides the sales representative with a competitive edge over other companies. 

Now couple this with the fact that a company’s Salesforce instance can be set to have one universal home page or different profiles in the organization can have a customized one. 

This means that every user can have the most important metrics for them at their fingertips at any time, mashed up in a single page. This way, your employees will have easy access to the company’s strategic measures and other important information while on the move. 

If you think that this isn’t necessary, then consider that most of the users would be salespeople using Salesforce’s mobile app to get some insight while traveling to their next customer. By integrating Qlik in this case, you’ll give your users a quick and easy way to be better prepared, more productive, and efficient, which in turn leads to better results for your company. 

Finally, these results could be tracked and analyzed to provide your salespeople with accurate information about their performance, various target achievements, and even a real-time bonus calculation, thus motivating them to do better and aim higher. 

Keep Exploring: All You Need to Know About Qlik Cloud. Moving From On-Premise to Cloud. 

Qlik Salesforce Integration Setup 

For all of you interested in the technical side of the integration, we’ve put together a quick guide that you can follow. This will be more a showcase of how easy and quick the integration can be, rather than a detailed step-by-step approach, so we hope all of you will read on. 

1. Download Salesforce Metadata 

First thing’s first, you’ll need to download the metadata from Salesforce from the Identity Provider tab, in order to use it as an authentication for the integration between the two platforms. 

Screenshot of the Salesforce setup interface for Identity Provider Setup. The screen shows a navigation pane on the left with options like 'Manage Users' and 'Security Controls'. In the main panel, there are sections for 'Identity Provider' details, 'Certificate and Key Management', and 'Service Providers', with various details and links. Notably, there are buttons for 'Edit', 'Disable', 'Download Certificate', and a highlighted 'Download Metadata'. Below, a list for Service Providers is empty with a note that service providers are now created via Connected Apps.

2. Create a Virtual Proxy in Qlik QMC 

Then in your Qlik QMC, you’ll want to create a new virtual proxy, so that you can establish a connection. It’s not mandatory, however, since you can use any proxy you already have. This way, though, you’ll be able to set up various rules and settings for this exact connection. 

Screenshot of a web-based management console, showing the 'Virtual proxies' configuration page. The interface indicates one total proxy listed, named 'Central Proxy (Default)', with options to edit, delete, and download service provider metadata. A highlighted button labeled 'Create new' is displayed, suggesting the action to add a new virtual proxy. The browser tab and bookmarks suggest the user is on a site related to Qlik Sense, indicated by the URL 'www.randomqliks.us

3. Adjust the Proxy Settings 

Following that, you’ll want to adjust the settings of the proxy. Mainly you’ll need to specify that the SAML host URI is your Qlik server and that the SAML attribute for user ID would be an email since that’s how you’d usually validate a user. 

Also, be sure to upload the metadata here, in order for the authentication to have a source to go from. In the end, you’ll need to whitelist the proxy server and any other server that might need to communicate with the environment. 

Screenshot of a 'Virtual proxy edit' form in a web interface, detailing the configuration settings for authentication. It shows fields for anonymous access mode set to 'No anonymous user', authentication method as 'SAML', and fields for SAML host URI, entity ID, metadata IDP, attribute for user ID, and attribute for user directory, with inputs like URLs and codes. A section for 'Websocket origin white list' at the bottom includes 'www.randomqliks.us' as an entry. The interface allows for uploading files and adding new values to the whitelist.

4. Set Up a License Rule 

This next bit is optional but recommended. You can set up a rule in Qlik that would automatically provide a license to all the users accessing the server through Salesforce. Again, this is not necessary, but keep in mind that if you don’t, then you’ll need to do it manually. 

Screenshot of a user access rule configuration panel within a software interface, titled 'Edit user access rule'. The panel is for 'SFDC Users' with a checkbox for enabling/disabling, a description stating it's a license rule to grant access to users coming from SFDC. Under 'Basic', there's a setting 'Actions' with 'Allow access' selected, and fields for user and user directory set to 'SFDC'. The 'Advanced' section shows a condition expression related to the user directory. At the bottom, there's a link to Qlik Sense help about security rules and a 'Validate rule' button.

5. Connect Qlik to Salesforce 

Lastly, you  need to connect Qlik to Salesforce by creating a so-called “Connected App” back at the Identity Provider tab in Salesforce. Just fill in the info as needed and make sure to download the SP metadata from your Qlik proxy, so that you can provide it in the ACS URL field. 

Then you’ll need to provide access to the Connected App to all of the users that will be taking advantage of the Qlik within Salesforce, and bingo! You’ve successfully completed the integration process. 

Screenshot of a web configuration interface for Service Providers with a section highlighted for a Connected App named 'Qlik Sense'. Details include the app name, contact information, and various settings. Below, 'API (Enable OAuth Settings)' is displayed with options to configure. In the 'Web App Settings' section, SAML is enabled with fields for Entity ID, ACS URL, and others filled out. An XML document is open in a text editor on the right, showing the corresponding SAML metadata with URL references matching the web interface settings. Red arrows indicate the flow of information from the web settings to the XML metadata.

Integrating Qlik with Salesforce FAQs 

Discover More: Qlik vs Tableau vs Power BI: A Complete Guide to Choosing the Right Tool 

Maximize Your Data Insights with B EYE’s Expert Qlik and Salesforce Integration 

Integrating Qlik with Salesforce offers direct benefits: advanced data visualization, streamlined analytics, and comprehensive insights.  

At B EYE, we specialize in crafting these integrations to maximize efficiency and decision-making accuracy for businesses. Our team’s expertise in Qlik and Salesforce ensures a tailored solution, directly aligning with your specific operational needs.  

Interested in leveraging these benefits for your business?  

Contact us for a consultation to discuss a tailored Qlik and Salesforce integration strategy. 

Book a Consultation

Name(Required)
Company Name(Required)

Explore More: