topic Re: SAP Report connector. Target server selection in QlikView

SAP Report connector. Target server selection

mrybalko — Mon, 26 Jan 2026 21:26:37 GMT

I use SAP report connector and I need to select sap application server for job execution. Unfortunately, SAP report connector does not have parameter "TargetServer".

I tried some connection string "tricks" but had no luck:

Change MSHOST=mytargetservername
Add parameter TargetServer=mytargetservername

According SM37, job always starts on random application server.

Will be appreciated for any advice.

Re: SAP Report connector. Target server selection

fabrice_lawson — Wed, 15 Jan 2014 12:53:19 GMT

which version of the SAP connector are you using?

I know that with the connector 5.8 SR1 you can do more configuration.

Re: SAP Report connector. Target server selection

Anonymous — Thu, 16 Jan 2014 05:02:23 GMT

Hi Maxim

Please attach you Connection String and I will help you

Yaniv

Re: SAP Report connector. Target server selection

mrybalko — Thu, 16 Jan 2014 10:32:03 GMT

I use version 5.5

Re: SAP Report connector. Target server selection

mrybalko — Thu, 16 Jan 2014 10:34:42 GMT

Connection string:

CUSTOM CONNECT TO "Provider=QvSAPReportConnector.dll;MSHOST=SAPMessageServerHostName;R3NAME=00;GROUP=Group1;CLIENT=500;XUserId=user;XPassword=password;";

Re: SAP Report connector. Target server selection

Anonymous — Thu, 16 Jan 2014 15:26:41 GMT

Hi Maxim

you need to write the name of the Application Server for paramter MSHOST (i.e. MSHOST=ECCPRD )

also, you need to write the System ID for parameter R3NAME (i.e. R3NAME=ECP)

No need to use parameter GROUP (unless you have a Cluster of Application Servers and you want to use Load Balancing)

Yaniv

Re: SAP Report connector. Target server selection

mrybalko — Fri, 17 Jan 2014 11:37:12 GMT

Hello Yaniv

Could you please explain what is System ID?

For example, target server has parameters (transaction SM51):

Server Name: er2ap01_ER2
Host Name: er2ap01

I tried the following string:

CONNECT TO "Provider=QvSAPReportConnector.dll;ASHOST=er2ap01;R3NAME=er2ap01_er2;SYSNR=00;CLIENT=500;XUserId=user;XPassword=password;";

Then I started reload. After that I opened transaction sm37. According to SM37, job was executed on server er2ap12_ER2.

Re: SAP Report connector. Target server selection

Anonymous — Fri, 17 Jan 2014 12:29:13 GMT

Hi Maxim

System ID is 3 Letters representing your system, for example: ECP

In order to figure out you system ID - just ask you Basis team and they will tell you.

I looked at your connection string, you need to put also the SYSNR value (usually it's not 00)

Yaniv

Re: Re: SAP Report connector. Target server selection

mrybalko — Fri, 17 Jan 2014 12:53:20 GMT

Thank you for explanation. I asked Basis team about system ID.

Modified connection string:

CONNECT TO "Provider=QvSAPReportConnector.dll;ASHOST=er2ap01;R3NAME=ER2;SYSNR=00;CLIENT=500;XUserId=user;XPassword=password;";

Job was executed on er2ap06.

SYSNR=00 is correct parameter.

Re: SAP Report connector. Target server selection

Anonymous — Fri, 17 Jan 2014 16:15:09 GMT

Great. Is the problem solved?

Re: SAP Report connector. Target server selection

mrybalko — Mon, 20 Jan 2014 11:42:15 GMT

Nope. Connection string points at ASHOST=er2ap01, but job was executed on er2ap06.

Re: SAP Report connector. Target server selection

Anonymous — Mon, 20 Jan 2014 14:18:15 GMT

looks weird. maybe ask qliktech