Qlik Community

QlikView Connector for SAP

Discussion Board for collaboration related to the QlikView Connector for SAP.

veeramallav
New Contributor

Qlik support for Netwever7.5 BW and BW/4HANA

Hello Team,

Please let us know , qlik will support BW 7.5 and BW/4 HANA ?

As there are lot of changes in the application layer ? will qlik support next version of BW (BW/4HANA) ?

EX:

All source system types except ODP, HANA and File System are not supported

  • All Business Content Datasources (extractors) that are released for Operational Data Provisioning (ODP) will be supported (the ODP Source System is replacing the SAP Source System in SAP BW/4HANA).
  • Object types from the 3.x data flow are not supported any more and must be migrated.
  • BW4/HANA does not support legacy BW objects like Multiprovider, Infocubes, Infosets etc. It only supports the new objects like Composite Providers, ADSOs, Open ODS etc.
  • Modeling in the Data Warehousing Workbench (SAPGUI) is replaced by modeling in the BW Modeling tools in Eclipse. The BW modeling tools have been adapted to the SAP HANA modeling environment. The BW objects recommended for use with SAP HANA are modeled exclusively in the BW modeling tools.
  • All Classical objects need to be migrated to BW/4HANA supported objects using the migration tools provided.
  • InfoPackage creation, maintenance and related process types in process chains are NOT supported
  • Persistent Staging Area (PSA) maintenance and related process types in process chains are NOT supported
  • Traditional BI Content will not be supported (software components BI_CONT and BI_CONT_XT). New SAP BW/4HANA business content on top of the Business Content DataSources will be delivered in Q4 2016.
  • Realtime Data Acquisition (RDA) is NOT supported
  • Data Transfer Processes will now longer support extraction from PSA. Hence, they will always use the Data Extraction setting “Directly from source system. PSA not used” from now on. The respective setting “Data Extraction” has been removed from the Data Transfer Process Maintenance.
  • Error Handling in Data Transfer Processes (because of using PSA based error stacks) is NOT supported

Regards

Venkat Veeramlla .

3 Replies
aoi
Contributor

Re: Qlik support for Netwever7.5 BW and BW/4HANA

 

Hi Venkat, the short answer is: Yes, we will continue to support connectivity to SAP.

 

Our connectors install and run on BW 7.5 and we are currently evaluating BW/4HANA. However, there are no dedicated connectors to the new BW objects such as ODP, CompositeProviders etc. The data is usually available through the SAP SQL Connector, BEx Connector (some limitations on new functionality exist) or any of the other SAP Connectors that we offer. There is also the possibility of exposing the BW objects as HANA view and access them through the ODBC connector. We are continuously improving our connectivity options to SAP and you can expect more dedicated BW 7.5 and BW/4HANA connectivity in the future.

 

/ Mats

 

p_van_craenenbr
New Contributor II

Re: Qlik support for Netwever7.5 BW and BW/4HANA

Mats, can you update your answer please?

What is today the recommended way to connect Qlik Sense to SAP BW/4HANA?

  • Do we connect with the SAP Connector Package to the application layer? If so, what connectors will we precisely use?
  • Or alternatively, do we connect with ODBC to HANA?

Is there anything in the pipeline?

Peter

aoi
Contributor

Re: Qlik support for Netwever7.5 BW and BW/4HANA

Hi Peter,

These are the BW4 objects that right now are extractable through the Application Layer (there might be some limitations):

  • InfoObject : SQL Connector
  • ADSO: SQL Connector
  • BW Query: BEx Connector

We are currently in the process of developing an updated version of the InfoProvider connector that can extract data from ADSO, CompositeProvider and Open ODS View. After that connector is released the connectivity options will be:

  • InfoObject : SQL Connector
  • ADSO: InfoProvider or SQL Connector
  • CompositeProvider: InfoProvider Connector
  • Open ODS View: InfoProvider Connector
  • BW Query: BEx Connector

If you prefer to connect to the DB layer you will be using the ODBC connector.

I can’t give you any definitive recommendations on how to extract data, going directly towards the DB will probably make your extractions faster (since you bypass the Application layer) but it will also mean that you will need to maintain authorizations on the DB layer etc.

For more details or specific question please contact your Qlik representative and he or she can help you get in contact with the Product Manager for connectivity and/or the SAP Connectors team at Qlik R&D.

/ Mats