Qlik Community

QlikView Connectors

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Qlik Sense - InfoProvider Connection String Syntax - ConvRoutine=1

Hi All,

I am trying to bring back data from BW without Alpha conversion using the SAP Infoprovider connection, in the manual it mentions to add ConvRoutine=1

Connection string properties

There are a number of properties that can be added to the connection string, if needed. Normally, the default values for these properties are sufficient. The following can be added as advanced properties in the connection dialog:

ConvRoutine   0/1 (default/off = 0, on = 1)

Indicates that output conversion routines are used. This is commonly used for fields like Material Number (MATNR).

Im new to Qlik Sense What is the valid syntax to add the properties to the connection dialog, the below doesnt seem to work when testing.

LIB CONNECT TO 'SapInfoProvider_TESTPOINTS (dlcc_qlik)';ConvRoutine=1;

Capture1.JPG

Any help much appreciated.

Cheers,

Matt

1 Solution

Accepted Solutions
aoi
Contributor

Re: Qlik Sense - InfoProvider Connection String Syntax - ConvRoutine=1

Just to clarify, the QMC should be used to modify an existing connection string. To set the connection string properties when creating the connection, mark the appropriate properties in the Connection dialog (they are visible once you have selected 'Connection String Properties'):

3 Replies
Not applicable

Re: Qlik Sense - InfoProvider Connection String Syntax - ConvRoutine=1

Found it in the end in QMC, works perfectly

Capture3.JPG

aoi
Contributor

Re: Qlik Sense - InfoProvider Connection String Syntax - ConvRoutine=1

Just to clarify, the QMC should be used to modify an existing connection string. To set the connection string properties when creating the connection, mark the appropriate properties in the Connection dialog (they are visible once you have selected 'Connection String Properties'):

Not applicable

Re: Qlik Sense - InfoProvider Connection String Syntax - ConvRoutine=1

Thanks Mats

Community Browser