Qlik View and Salesforce com Integration Marcus Spitzmiller

Presentation Layer Qlik. View Component Architecture Data Access Layer Application Layer Web Server (Qlik.

Integration Overview • i. Frame in Salesforce. com embeds Qlik. View Application • Uses

Qlik. View and Salesforce. com Integration

Authentication / Authorization Authenticate Navigate to Qlik. View Tab i. Frame to SFDCLogin. aspx

Data Integration DMZ Salesforce Connector pulls data Web Server Authentication Internal Network Ap QV

Authentication / Authorization Ports 443 App Exchange API: 443 i. Frame: 80 / 443

Data Integration Ports DMZ Salesforce Connector: 443 Web Server Authentication Internal Network Authorization QV

Qlik. View Security – Row and Column Entitlements Associate with Data Model to drive

Qlik. View Security – Row and Column Sourced from Management Console Sourced from Database

Slides: 13

Download presentation

Qlik. View and Salesforce. com Integration Marcus Spitzmiller

Presentation Layer Qlik. View Component Architecture Data Access Layer Application Layer Web Server (Qlik. View or IIS) • AJAX • Mobile HTTP / HTTPS • Multi-tiered Architecture One Tier Two Tier Three Tier (or more) • Security Integrated Active Directory LDAP Qlik. View Server Qlik. View Developer QVD and QVW files • ODBC • OLEDB • Custom Qlik. View Publisher • Simple Windows servers Windows files Single Mgmt Console

Integration Overview • i. Frame in Salesforce. com embeds Qlik. View Application • Uses Salesforce. com App. Exchange API for authentication • Uses Qlik. View Salesforce. com Connector for data integration • Freely available code: http: //community. qlikview. com/docs/DOC-3730

Qlik. View and Salesforce. com Integration

Authentication / Authorization Authenticate Navigate to Qlik. View Tab i. Frame to SFDCLogin. aspx Pass SFDC Session ID, Server URL, Qlik. View Document App Exchange API Pass SFDC Session ID, Server URL Receive User. Info Qlik. View Web Server SFDCLogin. aspx Tr an sla te ID DMZ Create Session User. Info / Document s ply Qlik. View Server Ap Internal Network Qlik. View Publisher Authentication up ok Lo Authorization

Data Integration DMZ Salesforce Connector pulls data Web Server Authentication Internal Network Ap QV Server ply Authorization QV Publisher up ok Lo

Authentication / Authorization Ports 443 App Exchange API: 443 i. Frame: 80 / 443 Qlik. View Web Server DMZ Authentication AD Internal Network : 3 89 Sessions: 4747 (Encrypted) Qlik. View Server 89 Apply: 4747 (Encrypted) /SMB A 3 D: Qlik. View Publisher Authorization

Data Integration Ports DMZ Salesforce Connector: 443 Web Server Authentication Internal Network Authorization QV Server Apply: 4747/SMB QV Publisher 89 A 3 D:

Thank You!

Appendix – Row and Column Security

Qlik. View Security – Dynamic Reduction

Qlik. View Security – Row and Column Entitlements Associate with Data Model to drive data visibility Data Model

Qlik. View Security – Row and Column Sourced from Management Console Sourced from Database