If nothing available then you can use flat file target. Access to a Relational database such as SQL Server (or use any of your choice e.g.Install Informatica PowerCenter Client Tools (e.g.Download Install ZappySys ODBC PowerPack (API Driver for Outlook Mail (Office 365) included).This article assumes that you have full filled following basic requirements. Next article will focus on how to write data to API in Informatica (POST / PUT data) Requirements Read JSON files in Informatica, Import REST API in Informatica). XML / JSON can come from a local file or REST API service (internal or public) so we will include both examples in this article (i.e. We will go through many screenshots and step-by-step examples to demonstrate JSON File or REST API integration in Informatica PowerCenter. However many tips and techniques described in this article will help you to understand how to integrate XML SOAP / JSON / REST API in other ETL / Reporting apps such as Tableau, Power BI, SSRS, Talend, Excel and many more.Īfter going through this article you will learn how to Read Outlook Mail (Office 365) / JSON / REST API data in Informatica and understand the concept of JSON / REST API. This article is primarily focused on Informatica users who want to access Outlook Mail (Office 365) data or may be other API Integration in Informatica. JSON / REST API is becoming more and more popular each day as everyone embrace cloud-centric services.
0 Comments
Leave a Reply. |