Transcript QlikView Integration Overviewx

QlikView Integration Overview
QlikView Integration Overview
Embed QlikView
Web
• Open and extensible API’s for AJAX environments / iFrame
Extend QlikView
Extensions
• 3rd Party / Custom Visualizations and Functionality in QlikView
Secure QlikView
Security
• Integration with Active Directory, LDAP, SSO solutions
Feed QlikView
• Many Standard Data Sources
Data
• Prebuilt Custom Connectors / SDK
Manage QlikView
• API for Administrative Functions
Management
• Version and Deployment Control
Web Integration
Web Integration – Embed QlikView
Integrating with websites
• Built on well-documented, open,
extensible QlikView AJAX API
• Use to render QlikView objects
• Use to access underlying QlikView data
and methods
• QlikView WorkBench is a product that
allows developers using MS Visual Studio
to embed QlikView objects into .NET
websites
• Non-.NET leverage AJAX API / Div Tags
directly
• An entire QlikView application can be
embedded into a website using standard
iFrame technology
Web Integration – Embed QlikView
Integrating with Microsoft SharePoint
• QlikView supports and promotes ‘Web Part’ technology
– Every object (e.g. chart, listbox) in a QlikView application can be used
as a web part. Each web part can be used as a live object within
SharePoint
– All data, client-server communication and the in-memory processing
still occurs in the QlikView Server
– QlikView embedded within SharePoint
allows for a single intranet portal to show
KPI’s and dashboard information
Extensions
Extensions – Extend QlikView
Integrating with 3rd Party / Custom Content
• Built on well-documented, open,
extensible QlikView AJAX API
• Use to render 3rd Party / Custom
Visualizations in QlikView
• Use to access underlying QlikView data
and methods
• MS Visual Studio template projects
speed development
Security Integration
Security – Secure QlikView
• QlikView integrates with a series of standard security systems for
authentication and authorization purposes
– MS Active Directory
– Single Sign-On systems (SSO) (e.g. SiteMinder)
– Non-AD LDAP’s
• QlikView can use a combination of Integrated Windows
Authentication, HTTP headers, ticketing, Directory Service
Connectors (DSC’s)
Security – Secure QlikView
Single Sign-On Integration
• QlikView can work with existing SSO
providers for user authentication
• Method used is HTTP Header injection
• Example deployments include
– IBM Tivoli Access Manager
– MS ISA/TMG
– CA SiteMinder
Security – Secure QlikView
• The topic of QlikView Security is covered extensively in the following
content:
– QlikView Security Overview White Paper
– QlikView Security Video Series
– QlikView Development and Deployment Technical Brief
Data Integration
Data – Feed QlikView
Integrating with many diverse data sources is a key tenet of QlikView
• SQL Server
• Oracle
• Any ODBC/OLE source
• xls/xlsx
• csv text
• XML
• Salesforce.com
• SAP Netweaver
• Informatica
Data – Feed QlikView
Accessing ‘non-standard’ data sources
• Salesforce.com Connector
– ‘Native’ connectivity to SFDC data,
similar in appearance to the ODBC/OLE
connector
– Can access all common fields in SFDC,
as well as custom fields
Data – Feed QlikView
Accessing ‘non-standard’ data sources
• SAP Connector
– Simple query builder to SAP data
– Uses metadata and field descriptions
from SAP to allow QlikView developers
‘make sense’ of SAP field and data
names
– Supports extraction from SAP R/3,
mySAP and existing SAP BW and BEX
information
Data – Feed QlikView
Accessing ‘non-standard’ data sources
• QVX is a open file/stream format for high performance data input
into QlikView.
– QVX as a file format. Data is ‘pushed’ to QVX files and consumed by
QlikView
– QVX as a connector. Data is ‘pulled’ from QVX files.
• QVX SDK available on QlikCommunity
Management Integration
Integration with 3rd party systems and processes
Management Integration
• QlikView provides a web-based Management Console out of the
box
• Extensive management API’s exist to allow automation of tasks on a
larger scale, or to allow integration with existing centralized
application management software
• Example: integrating an HR system for
employee on-boarding with the QlikView
admin tasks to allocate QlikView licenses
Integration with 3rd party systems and processes
Automation and Scheduling
• QlikView provides a native scheduling solution for automating data
reloads
• However: often before data is reloaded, a number of activities need
to take place: e.g. cleansing or data retrieval checks
• QlikView reloads can be triggered (using Event Driven Execution –
EDX) by any external dedicated schedulers such as
– BMC Software Control-M
– IBM Tivoli
Manageability
One code base – regardless of consumption
Simple architecture – few moving parts
One mgmt console – regardless of deployment
Thank You