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.
kunkumnaveen
Contributor III

sap connector

Hello guys ,

I have got couple of connectors so any one of you let me known which connector is useful to get connect with SAPSRM server,

client have given me all the login credentials ,i just need to figure out through which connector do i need to get connect...i tryed by using

this connector..when i ask the SAPSRM developer he said that the data is in tables....so i used below connector

QVSAPConnector.dll...with given ip,usr,pwr given by client ,but unfortunately its not working out.then

i used another connector QVSAPOLAPConnector.dll  from the list of connectors with same credentials luckily connection is successful but when i tried to fetch data by writing SQL query its throwing me error

CUSTOM CONNECT TO "Provider=QvSAPOLAPConnector.dll;ASHOST=10.250.5.51;SYSNR=HSD;CLIENT=100;Log=1;XUserId=PPbYEXVMMbceGXVNEF;XPassword=ffAeRcVMBTcEDYEGWZGB;";

srm:

Load *;

SQL Select * from CRMD_ORDERADM_H;

STORE srm into $(vPath)SRM.qvd(qvd);

DROP Table srm;

so is it my SQL statement wrong or this connector which i connected is a wrong one

is it possible to get connect with ODBC or OLEDB  if so whats the processor

please find the attachment with list of connectors

thanks

naveen

Community Browser