Para su comodidad, hemos incluido enlaces a Google Translate para traducir la información del producto que todavía tenemos que traducir. Por favor, tenga en cuenta que traducciones automáticas no siempre son totalmente exactas.

Con la tecnología de

Acerca de SSIS Web API Integration Pack

Automatice los escenarios de integración de servicio REST API/Web API/SOAP/OAuth/OData en SSIS.

SSIS Web API Integration Pack is a toolset to automate REST API/Web API/SOAP/OAuth/OData Service integration in SSIS. Using a simple drag and drop interface you can consume data from any Web Service in few clicks (XML or JSON format). You can also send Ad-hoc requests to any web server including file upload requests. It includes JSON Source Connector, XML Source Connector and REST API Task.

SSIS Web API Integration Pack (Call REST API, SOAP Web Service)

  • Consume any RESTful Web API or XML SOAP Web Service in few clicks.
  • Send Ad-hoc Http Web Request (e.g. GET, POST) and save response into SSIS variable or file.
  • Filter, Pivot, De-normalize nested XML or JSON into flat document just like regular database table.
  • Read data from JSON/XML files or RESTful API services (such as Twitter, Zendesk).
  • Support for JSONPath style expression to extract sub-documents or array.
  • Support for OAuth 1.0 and 2.0 security standard which is adopted by major cloud services (e.g. Google API, Facebook, Salesforce, Dynamics CRM, Office 365, MailChimp and many more).
  • Support for OData format.
  • Support for Basic authorization (Passing UserID and Password to REST API Service).
  • Support for looping through multiple files using wild card pattern (e.g. *.json).
  • Support for HTTP Request with Custom Headers.
  • Support for REST API Paging (3 different methods) – Loop through multiple requests.
  • Support for very large JSON files.
  • Support for Pivoting (Convert Columns to Rows).
  • Ability to output and indent raw JSON from inner array.
  • Support for SSL3 and TLS 1.2 protocol for encryption.
  • Support for passing cookies.