topic Qlik Sense - InfoProvider Connection String Syntax - ConvRoutine=1 in QlikView

Qlik Sense - InfoProvider Connection String Syntax - ConvRoutine=1

Mon, 26 Jan 2026 21:26:37 GMT

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;

Any help much appreciated.

Cheers,

Matt

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

Mon, 29 May 2017 05:35:49 GMT

Found it in the end in QMC, works perfectly

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

mats_olin — Mon, 29 May 2017 08:04:29 GMT

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'):

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

Mon, 29 May 2017 09:36:36 GMT

Thanks Mats