May 21, 2021 at 5:20 pm
Does anyone know the basics of connecting SSIS with 3rd party vendors that use APIs or REST APIs? Do I use an HTTP Connection Manager?
May 21, 2021 at 5:44 pm
We currently send data to a third party via a web service.
I used a script component in the data flow and added a web reference (URL) which points to their WSDL. This defined all the objects and the interface which were created as classes, methods, and properties right in my script component code. I can then simply use by creating new instances and populating the property values then the send method will serialize them as XML and send. That framework was defined by the WSDL.
You can use the web service task (the authentication/protocol options I think are limited) but yes then you use the HTTP connection manager I believe to define the endpoint. I know the web service task will also accept a WSDL file, in fact it might be required, not sure though on that one.
hth
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply