Which QlikView SAP connector is suitable with SAP modules (DB2 as Back-end)

[#1]

Hi Experts,

I have a project with SAP, the customer has deployed SAP Modules as mentioned below:

• SAP Financial Accounting (FI)
• SAP Controlling (CO)
• SAP Sales and Distribution (SD)
• SAP Production Planning (PP)
• SAP Materials Management (MM)
• SAP Quality Management (QM)
• SAP Human Capital Management (HCM).

The back-end of SAP is DB2.

My question here, which SAP connector will be suitable for these inputs above? Additionally, what is the normal expected days to implement QlikView with these Modules above.

Thanks in advance.

[Peter_Cammaert]

The best SAP Connector doesn't really depend on the SAP module you want to develop documents for. It depends on the data/reporting layer you want to access and - more importantly - how you want the meta data to be handled.

For example, SAP SQL Connector allows you to access almost every one of the 80000+ tables in your SAP environment, but - as the name says it - in a query-based unprocessed way ("raw data" if you like). While the SAP OLAP Connector lets you query the SAP B/W Cubes in that same SAP system.

Read the first few pages of the SAP Connector help, which is now published on-line and available here: SAP

Best,

Peter

[Peter_Cammaert]

And for your second question: it depends on whether you want tailored documents or you want to get started as quickly as possible. The first can take you months to years (you did include everything in your module list), the second one can be done rather quickly by using the standard QlikStart templates for SAP. See here: A Collection of QlikView SAP Template. They may be a bit outdated though.

Best,

Peter

[#4]

Hi Peter,

Thanks for your reply.

Another question,is there a way to integrate QlikView with SAP or it is mandatory to position SAP Connector in that case.

Additionally, what about QlikSense, can i  use it with SAP Sys

[#5]

if i implement these templates what is the estimated time for those template?

[Peter_Cammaert]

I don't know. I guess I can make them work more-or-less (some are a bit outdated) in a couple of days. But I have no idea about the resources and expertise you have at your disposal.

[Peter_Cammaert · Accepted solution]

1. The best method to offload data from an SAP system is to use a connector to handle the special tables, meta-data, call interfaces, roles etc. It should be possible to connect straight to the source DB (DB2 in your case) but I would advise you not to do so. You will be rebuilding a lot of SAP logic in QlikView, which in my opinion is not what you intend to spend your money on.
   Note: there are other vendors of SAP connectors for QlikView.
2. The QlikView SAP Connector has been promoted recently to simply being called Qlik Connector... So I guess the connector works with Qlik Sense too.

Best,

Peter

[#8]

Thanks for your info above,

I have last question in that case, can I use SAP SQL Connector as the SAP SQL Connector only applicable with QlikSense.

[saniiiil]

Hi,

as I know not all components of the Qlik Connector works with Qlik Sense at the moment, check the documentation for that.

As Peter said, there is another SAP Connector for QlikView (from a third party) and my company is used that.

I would recommend that you evaluate both connectors and check which one is the best for you.

[kunkumnaveen]

Hello Peter

Will u suggest me how to get connect to SAP SRM server from qlikview.Is there any third party connectors ?

my requirement is to connect and extract data from SAP SRM server

thanks

naveen