Connecting to D&B Direct web Service

[ryan_moore3]

Hello all,

anyone out there connect to Dun & Bradstreet web API with SAP Data Services?

Having a challenging time. Can get the WSDL to load if I have it local but it will not connect to the web service when running a batch job.

thank you,

Cheers,

Ryan

[ryan_moore3]

If I use an HTTP adapter in the Admin Console, then set it up in the Designer, that works. Still having the issue with an HTTP/SOAP Service. There is some documentation to get the service configured to use HTTPS

Was trying to follow this document: http://scn.sap.com/thread/3190403

[Former Member]

Has anyone managed to get this issue resolved?

We are facing the same issue using the CreditAgencyReportQuery_Out service in SOA manager.    No PI, only via WSRM configuration.  We cannot get connected to the D&B 2.0 Direct service using either the HTTP or File download.

Any insight or a couple screen shots of the working service would be hugely appreciated.

regards,

Nathan

[ryan_moore3]

Published location of the WSDL is:

[ryan_moore3]

https://maxcvservices.dnb.com/Company/V4.0?wsdl

When connecting to the URL Above, SAP DS developer the URL Resolves. When executing the job on the Job Server, I get "unable to connect to the service"

Any thoughts?

[Former Member]

which datastore type you are using ? webservice or Adapter ?

can you post the complete error message from the job error log ?

also what is the DS version ?

[ryan_moore3]

Using an adapter I can get a login error message - expected result as it is using WSS and that has not yet been configured

Using a webservice (SOAP) there is no response only a "server is not responding" error.

The WebService uses HTTPS - looks like SAP DS does not support HTTPS as a protocol. It looks like I will have to use an adapter and modify the WSS settings so the login will work as well.

Thank you

[Former Member]

Data Services WebService/Adpater Datastore both support HTTPS

Data Services WebService Datastore also supports WS-Security

since it's HTTPS you need to do some configuration, may be that is missing what is the complete DS version ?

[ryan_moore3]

DS Version: 14.2.1.224 (14 sp1)

Job Server 14.2.2.5xx (14 sp2)

Configuration on the Web Service:

URL:

https://maxcvservices.dnb.com/Company/V4.0?wsdl

https://maxcvservices.dnb.com/FirmographicsProduct/V3.2?wsdl

WSS User: provided the name

WSS Pass: provided the pass

Timeout set to 500

All other settings are blank.

Does something need to be defined on the job server?

The WSDL does not even open on the workstation unless I use an adapter. I had found an article/help/note (something) that the web service in SAP DS does not work with HTTPS and it does with an HTTP Adapter.

I do not have access to Job Server, will have to schedule some changes if there is config that has to happen there.

Thanks for your input.

Cheers,

Ryan

[Former Member]

there is no issue with HTTPS and Webservice Datastore, in one particular version of DS 12.2, it was not working if the DS Servers were behind a proxy which was fixed in subsequent patch

you are on DS 4.2, there should be no problem using webservice datastore

please refer to following link and other posts in that forum to trouble shoot the DS WS issues with HTTPS/WS-Security etc

Help with batch job to web service (https)

if you still have problem please open a OSS Message and I will take a look, if you already one open, let me know the number

[Former Member]

Hi Ryan,

You might want to try http://developer.dnb.com/?prod=Toolkit Thank you, Ali