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
