I recently spoke with QlikView experts Ian Crosland (principal pre-sales consultant) and Adrian Bereanu (senior consultant, SAP technologies) about how organizations can bring SAP data into their QlikView dashboards, analysis and reports. (See this related QlikView blog article.)
QlikView makes SAP integration possible quickly and easily with:
- A certified connector. QlikTech offers an SAP-certified connector called QlikView Connector for use with SAP NetWeaver®. We use this connector to access data in traditional SAP transaction systems, SAP BW (data warehouse), and SAP reports and queries. We use ODBC when accessing SAP systems like Business One.
- A field and table name mapper. A QlikView script builder maps the cryptic SAP table nomenclature to meaningful business descriptors. The script builder imports SAP metadata (table names and descriptions) and translates it into any language the organization has active in the SAP Data Dictionary. For example, the field "KNA1" becomes "customer master" and the field "VBAK" becomes "sales order header." When people who have worked with SAP for many years see this they say, "Wow."
- Mind-blowing "Seeing Is Believing" events. In a Seeing Is Believing event that can last anywhere from one to five days, QlikView consultants go into a prospective customer's site and demonstrate QlikView applications running with the customer's real data. (See this related QlikView blog article about QlikView Seeing Is Believing events for SAP customers.) Consultants fire up templates showing commonly-used data (e.g., sales numbers), connected to 30 or 40 different SAP tables on the back end, and the customers' eyes light up.
With the QlikView Connector for use with SAP NetWeaver®, our script builder, and power-packed Seeing Is Believing events, QlikView can unlock SAP data and deliver business value in just a few days.
What are your experiences implementing QlikView in SAP environments?