what is the qlikview connector? remote function call connection to sap sap becomes a “standard”...
TRANSCRIPT
What is the QlikView Connector?•Remote Function Call connection to SAP
• SAP becomes a “standard” data source for QV Development• 5 connectors, SQL based and MDX based (for BW info
cubes/queries)•Reads SAP data dictionary• Reads Cluster, Pool and Transparent tables• Including SAP Metadata• Extracts tables/views from SAP (standard or custom Z* and
Y*)• Extracts BW info cubes/BEX queries or ODS/DSO• Extracts from SAP queries and ABAP reports•Compatible with R/3 >= 4.6C and BW >= 3.1
• Initial certification December 2006• Recertified April 2009
Overview of all Qlikview connectors for use with SAP Netweaver ®
DSO/ODSConnector
QlikView Developer
orServer/Publisher
OLAPConnector
SAP BW / BIOLAPBAPI
Cube
QVD
Any SAP system
QVC RFCFunctions
OpenSQL
DB
ReportConnector
ODSBAPI DSO/ODS
BEXQuery
QueryConnector
SQLConnector
QVC RFCFunctions
OpenSQL
QVC RFCFunctions
OpenSQL
Pros and Cons for the different connectors Advantages Disadvantages
SQL Connector • Very fast, 20K-50K records/sec• Robust, no memory limitations• Works with any SAP systems that we
support
• Requires installation of transports• Works only at the table/view level
OLAP Connector • No transports required• Presents a nice user interface, allows
to pick key figures/characteristics.• Extracts from BEX queries
• Works with BW/BI only• Has memory limitations (good for
small amounts of data)• Slower• Generates MDX syntax instead of
SQL
ODS/DSO Connector • No transports required• Generates SQL • Presents nice user interface, allows
slicing on columns if memory is low
• Works only with BI/BW ODS/DSO structures
• Super seeded by the SQL connector
Query Connector • Works with SAP R/3 queries • Requires installation of transports
Report Connector • Extracts data from ABAP reports • Requires the installation of transports
• Reports need to output to spool
Business benefits•Rapid Deployment
• Deployments are measured in days and weeks—not months. This way, implementation costs are significantly lower than competing solutions. •No Data Warehouse required
• QlikView pulls data directly from SAP. Data from SAP BW and other data warehouse can be loaded as well – but it is not required. •SAP and Non-SAP data combined
• QlikView combines data from multiple sources, giving customers a complete view of their business. •Easy-To-Use
• Patented technology makes QlikView applications easy to learn, for developers and for end-users.
Technical benefitsNo dependencies on other products (e.g. SAPGUI, Bex)Field level securityFollows SAP security modelDelta load capableZero administration One connector to multiple SAP servers (DEV, QAS, PRD)Parallel downloadsNo extra hardware (coexists with QV Development and Server/Publisher)Quick installation and configuration (1/2 hr)Automatic ETL script generation based on easy point and click selection using Qlikview Script Builder application
QlikStart Templates for SAP• QlikStart for:
• SD –Sales and Distribution
• AR – Accounts Receivable
• AP- Accounts Payable
• CO – Controlling
• PS – Project Systems
• MM – Materials Management
• PP – Production Planning
• HR – Human Resources
• FI – General Ledger
• Contains Extraction/layout app and guide
• Value to IT
• Pre built linkages
• 100’s of Business answers
• Developer’s Level (extraction)
• Adhere to SAP security model with roles and authorizations
• Additional security provided by SAP Connector
• End User Level (user access)• Qlikview native via Section
Access• Through Publisher via
Loop/Reduce/Distribute• Leverage SAP security
Security
Leveraging SAP security to Qlikview
SAP Connector Log Monitor
Dashboards
Base QVD Files
Final QVD Files
QVD Generator