Questions on SAP connector clients 7.0

What are the SAP connector clients in Qliksense??

SAP Bex Connector
SAP SQL Connector
SAP Extractor Connector
SAP Info provider ConnectorSAP BAPI Connector


What are the objects supported by SAP Bex connector 7.0??


Bex Query
Composite Provider

What are the data types can not be downloaded using by the SAP SQL Connector??

A field in an SAP database table is assigned to a Data Type. Fields assigned to the following Data Types cannot be downloaded by the SQL Connector:

• LCHR (Long character string, requires preceding INT2 field)
• LRAW (Long byte string, requires preceding INT2 field)
• RAWSTRING (Byte String of Variable Length)

What are the Objects supported by SAP SQL connector 7.0??

DSO
Info Objects
Info Cube
ADSO

What is Delta load and which connector supports it??

Delta load is used when there are new records added. Instead of extracting all the records, we can extract records which are updated recently. Extractor connector supports Delta load 

What are the objects supported by SAP extractor connector??

DSO
Info Objects
Infocube
Hierarchy 

What are the info providers supported by SAP Info provider connector??

InfoCube
MultiProviderADSO
Composite ProviderOpen ODS view 


What is BAPI connector??

The BAPI Connector enables calls to Function Modules or BAPIs (Business Application Programming Interface) in an SAP BASIS System 6.40, 7.00, and later. The QA method of a BAPI is implemented as a Function module.

Qlikview Question -2

Binary Load

            Loading one .qvw file as a source into another .qvw file is called binary load.

• Only one binary load will be allowed within a .qvw file.
• It should be loaded as first line of the script before the set variables in first tab.
• Using binary we will get the data model from the another qvw file but not the front end object. Please find data model view in the below screen shot after binary load

Below is the sample code:- 

Binary  C:\users\.....\.........\binary.qvw;

How to convert .PGO to XML files in qlikview

As user license information stored in .PGO files in Qlikview, we can not see the information.We can convert them into XML files to get loaded into qlikview. We will see the process of converting PGO files to XML below.

(PGO files are stored in Root folder. you can find the root folder path under QMC > System > Setup > QlikView Servers > QVS@ > Folders tab > Root Folder field)

We can convert by changing parameter in Settings.ini file. Please open settings.ini file and change the parameter to PgoAsXmlAlso=1

Please find in below screen shot

Once the parameter is changed then save the file and restart the Qlikview server service. Now XML files are available in Root folder