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.
mrybalko
Contributor

SAP Report connector. Target server selection

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.

11 Replies
flo
Contributor

Re: SAP Report connector. Target server selection

which version of the SAP connector are you using?

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

yfe
Contributor III

Re: SAP Report connector. Target server selection

Hi Maxim

Please attach you Connection String and I will help you

Yaniv

mrybalko
Contributor

Re: SAP Report connector. Target server selection

I use version 5.5

mrybalko
Contributor

Re: SAP Report connector. Target server selection

Connection string:

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

yfe
Contributor III

Re: SAP Report connector. Target server selection

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

mrybalko
Contributor

Re: SAP Report connector. Target server selection

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.

yfe
Contributor III

Re: SAP Report connector. Target server selection

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

mrybalko
Contributor

Re: Re: SAP Report connector. Target server selection

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.

yfe
Contributor III

Re: SAP Report connector. Target server selection

Great. Is the problem solved?

Community Browser