Importing Virtual Tables in MS Access (JSON REST API Example)

Using Custom Objects in ZappySys Drivers

Introduction ODBC PowerPack v1.2 release brought an interesting feature for all API drivers. New version gives you an ability to create Custom Objects. You can create parameterized Stored Procedure and Virtual Tables on the same Data Source (ODBC DSN or Data Gateway Data Source). Custom Stored Procedure You can create procedures to encapsulate custom logic […]

Informatica PowerCenter Logo

POST data to API in Informatica using SQL Transformation

Introduction In our previous blog post we saw how to read JSON REST API / XML SOAP in Informatica using ZappySys ODBC Drivers. Now lets look at API Write scenario. We will learn how to to POST data to API in Informatica (Insert / Update). We will use SQL Transformation to fire ODBC Driver Queries […]

Informatica PowerCenter Logo

Read JSON in Informatica – Import REST API / SOAP / JSON File

Introduction JSON / REST API is becoming more and more popular each day as everyone embrace cloud-centric┬áservices. This article is primarily focused on Informatica users who want to do XML SOAP/┬áJSON / REST API Integration in Informatica. However many tips and techniques described in this article will help you to understand how to integrate XML […]

Informatica PowerCenter Redshift Data Load - Amazon Redshift Import Command line tools (COPY, S3, AWS)

Amazon Redshift data load in Informatica PowerCenter

Introduction In our previous post you learned how to load data into Redshift using SSIS. Now in this post you will learn how to load data into Redshift using Informatica PowerCenter. For PowerCenter we will use ZappyShell Command line for Redshift Data Load. This small powerful command line utility can handle load of several millions […]