0 Replies Latest reply: Feb 23, 2016 4:50 AM by naveen kumar RSS

    sap connector

    naveen kumar

      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