Example SSIS Package - Google DFP API Integration (Read / Write data in Google Double Click for Publisher) - No Coding required

Calling Google DFP API with SSIS – DoubleClick

 Introduction Google DoubleClick is one of the most popular platforms for Advertisers. Many times you have need for custom integration or Automation for many operations. In this article we will learn how to Call Google DFP API (i.e. DoubleClick for Publishers) without coding using SSIS (Microsoft SQL Server Integration Services). In our previous article we […]

SSIS Advanced File System Task - Search / Replace Option -Remove invalid XML characters using Regex (Regular Expression)

How to remove invalid characters from XML using SSIS and Regex

 Introduction In this blog post you will see how to remove invalid characters from XML using SSIS. We will use search and replace feature of Advanced File System Task. Remove Invalid characters from XML Xml file specification have restriction about which characters can be part of XML data and which should be avoided. If you use […]

SSIS OAuth Connection - Call Amazon MWS API (Marketplace Web service API)

Call Amazon MWS API using SSIS (Marketplace Web Service)

Introduction In this post you will learn how to call Amazon MWS API (Amazon Marketplace Web Service) using SSIS PowerPack. Using drag and drop approach you can consume data from Amazon MWS XML Web service. In this post we will use ZappySys XML Source connector to read data from Amazon MWS API and load into SQL […]

Handling Rows/Array Elements (Repeated XML Elements)

SSIS Import XML data two ways (XML Parser)

Introduction In this post you will learn how to import XML file into target such as SQL Server, CSV, Excel, Oracle. Converting or Importing XML requires flattening XML structure (i.e. hierarchy) sometimes we refer this process as de-normalization.  Parsing XML can be tricky depending on how many levels you have and from which level you need data. […]

Create new SoapUI project to generate / test Soap Requests

Calling SOAP Web Service in SSIS (XML Source)

Introduction In this article you will learn how to call SOAP Web Service in SSIS. We will use drag and drop approach to consume SOAP Webservice using SSIS XML Source Connector. This same XML Connector can be used to consume data from local XML Files (wild card allowed e.g. *.xml) or you can consume XML stored in […]

Google AdWords API Integration Example - Create Ad, Get Accounts, Get Campaigns, Get Ad Groups, Get Ads (Extract AdWords data via SOAP API)

How to get data from Google AdWords using SSIS

Introduction Google AdWords is one of the most popular Advertise Platforms. In this article you will learn how to get data from Google AdWords using drag and drop SSIS XML/SOAP connector ( No coding required ). For demo purpose we will extract data from Google AdWords Account and load into Microsoft SQL Server. But you […]

ZappySys Logo - SSIS, SQL Server, Big Data, Cloud Computing, NoSQL, Business Intelligence

Get data from Zuora in SSIS using REST API

Full article coming soon…  (Learn how to get data from Zuora) SSIS XML Source (FILE, SOAP, REST API Connector) SSIS JSON Source (File, REST Connector) Meanwhile check following similar articles : Read Zendesk data in SSIS using REST API Get data from SurveyMonkey in SSIS using REST API Read Twitter data in SSIS using REST […]

Testing Facebook OAuth Connectivity in SSIS (Use Graph API)

Get data from Facebook in SSIS using REST API

Introduction In this article you will learn how to get data from Facebook using Graph API (OAuth 2.0) using SSIS PowerPack REST api Connectors. Facebook provides rich set of REST API to access data. Their REST API is also known as Facebook Graph API and it uses OAuth 2.0 Authorization. Traditionally any REST API Integration scenarios […]

ZappySys Logo - SSIS, SQL Server, Big Data, Cloud Computing, NoSQL, Business Intelligence

Get data from QuickBooks online in SSIS using REST API

Full article coming soon. SSIS XML Source (FILE, SOAP, REST API Connector) SSIS JSON Source (File, REST Connector) Meanwhile check following similar articles : Read Zendesk data in SSIS using REST API Read Twitter data in SSIS using REST API Task and JSON Source – OAuth2 Protocol Marketo API Reference: QuickBooks Online REST API reference […]