Informatica - POST data to REST API / SOAP Web Service (Upload XML / JSON File to HTTP URL)
POST data to REST / SOAP URL in Informatica PowerCenter. Learn more using below URL.
https://zappysys.com/blog/post-data-a...
https://zappysys.com/products/odbc-po...
https://zappysys.com/onlinehelp/odbc-...
In this video we cover many techniques such as
Calling REST API / Debugging REST API
Configure JSON Driver for Informatica
Use of SQL Transform to call ODBC SQL queries
Use of Expression Transform to format data (e.g. TO_CHAR function for date formatting )
Upload file content to REST / SOAP API using ZappySys REST API Driver
About ODBC JSON Driver / REST API Driver used in this video
==================================================
ODBC JSON Driver / REST API Driver can be used to read / write data from Web API / Cloud Data sources or Local JSON files. Easily integrate virtually any Web API inside your BI / ETL / Reporting / Tools or Programming Languages. Write familiar SQL queries to read /write data. This driver supports latest API security standards (i.e. OAuth 2.0, JWT, X509), and optimized for large data files. This driver comes with native support for SQL Server using Data Gateway.
This driver is using same high performance data processing engine which was originally developed for JSON / REST Connector in SSIS PowerPack. ODBC PowerPack and SSIS PowerPack, both products share many UI elements and concepts. We wrote many articles to explain various features in one product but concepts are mostly same in both products so hope you can reuse steps explained in different articles even though screenshots /steps may be slightly different.
Feature Summary
===============
Read /write data from Web API / REST API or local JSON files using familiar SQL Query language
De-normalize nested JSON into a flat document just like a regular database table
Integrate insight any ODBC Compliant Reporting / ETL tools (e.g. Power BI, Tableau, Qlik, SSRS, Informatica, Excel, SSIS)
Support for programming languages such as JAVA, C#, Python, PowerShell and more…
Tight integration with Microsoft SQL Server (With support for Gateway Option – No need to install Driver on Server)
Familiar SQL Query language support including WHERE, ORDER BY, GROUP BY constructs
Support for custom math/ string / datetime / JSON functions in SQL query Language
The unparalleled performance with large file support (See how we processed 3 million rows in 3 mins)
POST data to API server, Upload File to server (Support MultiPart File Upload).
Latest security standards such as OData, OAuth and JWT (RFC 7519) (Call services like Google API, Facebook …)
Call API using Dynamic Token Authenticate or Basic authorization (i.e. UserID / Password)
Reading from multiple files using wildcard pattern (e.g. Year??_data*.json)
Support for Array Flattening (Child Array Items as Columns)
HTTP Request with Custom Headers / Body / URL Parameters.
REST API Pagination Support to consume multiple requests / loop (many options explained here and here)
Support for 2D arrays and Complex Transformation (See this article and this for Google BigQuery)
Option for Pivoting nested data (Convert Columns to Rows)
Ability to read raw JSON / indent output from inner array
HTTPS / SSL / TLS 1.2 Support for more secure communication
Support for passing cookies
Support for Proxy Server