Salesforce Adapter on SAP Data Services 4.2

Recently on one of our clients, we needed to bring some data from Salesforce to SAP HANA using SAP Data Services. The client installation was 4.2 SP9, so the solution should be simple: Create an adapter service on Job Server, create a Datastore with the credentials and done!

But that was not that simple, when we tried to create the adapter with the default settings, an error massage was saying that the commons-collections-3.1.jar couldn’t be found.

Removing that lib from classpath made the service starts, but then we couldn’t connect with the Salesforce service.

Reading the logs, the connection failed at some point and after some research and much try and error, I’ve ended with a classpath that worked:

<LINK_DIR>\lib\acta_adapter_sdk.jar;<LINK_DIR>\lib\acta_broker_client.jar;<LINK_DIR>\lib\acta_tool.jar;<LINK_DIR>\ext\lib\bcm.jar;<LINK_DIR>\ext\lib\cryptojFIPS.jar;<LINK_DIR>\ext\lib\ssljFIPS.jar;<LINK_DIR>\ext\lib\xercesImpl.jar;<LINK_DIR>\ext\lib\xml-apis.jar;<LINK_DIR>\ext\lib\log4j-1.2.15.jar;<LINK_DIR>\lib\acta_salesforce_adapter.jar;<LINK_DIR>\ext\lib\partnerSample.jar;<LINK_DIR>\ext\lib\commons-pool-1.2.jar;<LINK_DIR>\ext\lib\commons-codec-1.3.jar;<LINK_DIR>\ext\lib\activation-1.1.jar;<LINK_DIR>\ext\lib\axiom-dom-1.2.13.jar;<LINK_DIR>\ext\lib\axis2-xmlbeans-1.6.2.jar;<LINK_DIR>\ext\lib\wsdl4j-1.6.2.jar;<LINK_DIR>\ext\lib\xercesImpl.jar;<LINK_DIR>\ext\lib\xml-apis.jar;<LINK_DIR>\ext\lib\axis2-adb-1.6.2.jar;<LINK_DIR>\ext\lib\axis2-jibx-1.6.2.jar;<LINK_DIR>\ext\lib\axis2-kernel-1.6.2.jar;<LINK_DIR>\ext\lib\axiom-api-1.2.13.jar;<LINK_DIR>\ext\lib\axiom-impl-1.2.13.jar;<LINK_DIR>\ext\lib\commons-logging-1.1.1.jar;<LINK_DIR>\ext\lib\commons-httpclient-3.1.jar;<LINK_DIR>\ext\lib\commons-codec-1.3.jar;<LINK_DIR>\ext\lib\wsdl4j-1.6.2.jar;<LINK_DIR>\ext\lib\wstx-asl-3.2.9.jar;<LINK_DIR>\ext\lib\XmlSchema-1.4.7.jar;<LINK_DIR>\ext\lib\axis2-codegen-1.6.2.jar;<LINK_DIR>\ext\lib\neethi-3.0.2.jar;<LINK_DIR>\ext\lib\httpcore-4.0.jar;<LINK_DIR>\ext\lib\mail-1.4.jar;<LINK_DIR>\ext\lib\axis2-transport-http-1.6.2.jar;<LINK_DIR>\ext\lib\axis2-transport-local-1.6.2.jar;

So, if you are in the same situation, please,  try with the classpath above and remember to change <LINK_DIR> with the Data services installation path as in “D:\Program Files (x86)\SAP BusinessObjects\Data Services\” for exemple.

For more information about Adapter, please check the Suplement for adapters in the SAP Data Services documentation.