Transcription
How to leverage SAP data withQlikAndrea CorainPrincipal Solution Architect
The challenge Giving users easy access to all data within multiple SAPsystems Easily analyze a combination of SAP and non-SAP data Making sure users can only access authorized data andapplication Reducing IT expenditures and reliance on limited businessanalyst resources Ensuring integrations are certified by SAP2
Qlik and SAP Accelerating time-to-value by enabling self-service visualization anddiscovery against your SAP data– Seamless combination of SAP and non-SAP content– Governed data discovery Reducing TCO with multiple SAP integration connectors and tools to meetthe requirements of each system Proven integration– Over 2,000 Qlik customers are already leveraging their SAP environment– SAP certified integrations Strong partnership between SAP and Qlik– Dedicated SAP Connector R&D team at Qlikis ais a3
Qlik is SAP certified Certified for SAP HANA Regardless of whether HANA is used with an SAPapplication (Ex. ERP) or by itselfValid for Qlik Sense 3.0 and higher Certified for SAP ERP and SAP BW Certified with SAP NetWeaver platform and SAP HANACovers eight different SAP APIsValid for QlikView 11.2 and higher Valid for Qlik Sense 2.0 and higher 4
Easily Connect to Add Value Qlik has a comprehensive set of SAP integrationproducts available today Enables SAP customers to get easy and quick access to all thedata hidden in different SAP systemsQlik’s Associative Model: SAP data can then easily becombined with Non-SAP data within individual Qlik applicationsCreates value out of SAP systems within a few weeks – ratherthan months/yearsCertified by SAP5
SAP ERP ConnectivitySAP ERP / SAP ctionModulesQueryConnectorReportConnectorSQL ConnectorBAPI Connectorqvd
SAP BW ConnectivitySAP BI / BWABAPSAPExtractorBAPI nctionModulesInfoObjectBExQueryDBInfoCubeDSOSQL x ConnectorOLAPBAPIDSOBAPIOLAP ConnectorDSO Connectorqvd
SAP Connectivity Strategy201620172018SQL ConnectorHANA (via ODBC)BEx ConnectorExtractor ConnectorBAPI ConnectorDSO ConnectorOLAP ConnectorReport ConnectorQuery ConnectorRelease dates - TBDMultiProviderUser Interface
How does each Qlik Connector perform?ConnectorSQLBWYES YESPerformanceImplem.EffortQV ES DIUMLOWSMALLProgramExtractor#qonnectionsERP9
QlikStart Templates for SAP ECC Contain the most important standard tables of each module. They arealready combined to a data model– Pre built linkages– 100’s of Business answers– Can be customized by customerAvailable Templates AP - Accounts Payable AR - Accounts Receivable BW - Cube builder CO - Controlling GL - General Ledger HR - Human Resources MM - Materials Management PP - Production Planning PS - Project Systems SD - Sales and Distribution10
Qlik Platform ArchitectureBusiness Users/Business AnalystsVisualizationAnalysisCreationHTML 5 Web ClientGovernanceCustom APIApps andExtensionsSystem Administrator/Enterprise ArchitectData Import &Incremental UpdatesGoverned Dataand MetricsDirect Query &On DemandData Architects/Web Developers
Appendix – Accessing SAPHANA
Qlik is SAP HANA certifiedHANA NativeHANA DBDescriptionHANA is the Data warehouse orused with customer developedapplicationsHANA is the database for SAPERP or SAP BWQlik solutionODBC connectivity in QlikSense.Qlik SAP Connectors packageQlik Solution certifiedQlik Sense 3.0Qlik SAP Connectors package6.xCertification valid forQlik Sense 3.xQlikView 11.2 and higherQlik Sense 2.0 and higherCurrent certificationexpirationMay 2019June 201813
Multiple methods to work with HANAScenarioHANA DBHANA is thedatabase forSAP ERP orSAP BWHANA NativeNative HANAapplicationsConnectivity MethodsComments SQL ConnectorReport ConnectorQuery ConnectorExtractor ConnectorBAPI ConnectorBEx ConnectorDSO ConnectorOLAP ConnectorInfoprovider ODBC ConnectivityODBC Connectivitywith Direct DiscoveryODBC Connectivitywith On Demand AppGeneration * These methods all involveconnecting to the SAP applicationlayer, not directly to HANAAll of these connectors are packagedtogether in a single Qlik SAPConnector licenseQlik Sense and QlikView both includeODBC ConnectivityAn ODBC driver also needs to beinstalled with SAPOn Demand App Generationexamples are shipped with QlikSense 3.0* On Demand App Generation is a method that empowers the user to automatically create a purpose-built analysis app every time theyselect a slice of a very large data source.
Example - Qlik and HANA DB usingSAP Connector packageSAP BW on ectorDSOConnectorSchemaOlapConnector
SAP HANA Connectivitynative ODBCSAP HANA BC ConnectorDBAnalyticViewsDirect Connect(SQL)Calculat.ViewsOn DemandAppGeneration
Thankyou
discovery against your SAP data – Seamless combination of SAP and non-SAP content – Governed data discovery Reducing TCO with multiple SAP integration connectors and toolsto meet the requirements of each system Proven integration – Over 2,000 Qlik customers are already leve
