1 / 8

What is the QlikView Connector?

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

dafydd
Download Presentation

What is the QlikView Connector?

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 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

  2. Overview of all Qlikview connectors for use with SAP Netweaver ® Any SAP system QlikView Developer or Server/Publisher Report Connector QVC RFC Functions OpenSQL Query Connector DB QVC RFC Functions OpenSQL SQL Connector OpenSQL QVC RFC Functions SAP BW / BI OLAPConnector Cube OLAPBAPI BEXQuery DSO/ODS Connector ODSBAPI DSO/ODS QVD

  3. Pros and Cons for the different connectors

  4. 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.

  5. Technical benefits No dependencies on other products (e.g. SAPGUI, Bex) Field level security Follows SAP security model Delta load capable Zero administration One connector to multiple SAP servers (DEV, QAS, PRD) Parallel downloads No 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

  6. 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

  7. Security • 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

  8. Leveraging SAP security to Qlikview SAP Connector Log Monitor QVD Generator Base QVD Files Final QVD Files Dashboards

More Related