Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2017-09-28 11:14 PM

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 .

4,661 Views
4 Replies
mats_olin
Employee
Employee
‎2017-10-05 02:49 AM

 

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

 

3,385 Views
p_van_craenenbr
Partner - Contributor II
Partner - Contributor II
‎2018-02-28 04:58 PM

In response to mats_olin

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

3,385 Views
0 Likes
mats_olin
Employee
Employee
‎2018-03-02 08:39 AM

In response to p_van_craenenbr

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

 

3,385 Views
Dario88
Contributor
Contributor
‎2020-05-05 04:25 PM

In response to mats_olin

Hi Mats,

We are trying to connect Qlik with a Bex Query BUT, this Bex Query is based on a CDS view, it's not a Bex Query created in the Query Designer tool, it's more like a query artificially created in eclipse. (I think is called transient query)

We are able to see and execute this quey from RSRT, but when we open Qlik and try to connect  to that Bex Query is not there, we cannot find the  infoprovider in the list or the query name on the list.

So I started to wonder whether this is possible or not to do this, and maybe you can shed some light on this.

Thanks in advance

Dario

 

2,015 Views
0 Likes