Introduction This release had many bug fixes. To see full release notes click here New Features/Improvements NEW: JDBC Bridge Driver – Prefix schema name to table when you select it from table dropdown and default query is generated (by default schema is not prefixed) Bug fixes FIX: All API Drivers – Add support for Page End Indicator / […]
Introduction This was a minor update release. It fixes important issues with API Source, API Destination, DynamoDB, Export XML Task, JSON Source, CSV Source, XML Source, Upsert Destination and Salesforce Source. To see full release notes click here New Features/Improvements NEW: API Connector – SharePoint Online – Add new endpoint get_list_items_dynamic to read complex datatypes (e.g. Lookup, […]
Introduction This was a minor update release. It have added a new API Connectors for Google Drive, SharePoint Online & Zoho. Also, It fixes important issues with API Source, API Destination, Salesforce Source and Web API Destination. To see full release notes click here New Features/Improvements NEW: API Connector – Google Drive – Add support for very […]
Introduction In this post, we will cover how to connect ADP API using HTTP connection manager over OAuth connection manager with JSON Source. ADP API works a bit differently with the OAuth connection manager. Let’s take a look at it… Prerequisites Before we perform the steps listed in this article, you will need to make sure the […]
Introduction In our previous post we saw how to read API data in SSIS. This post we will cover how to call NetSuite RESTlet to read / write data in SSIS or ODBC Apps. For demo purpose we will use SSIS PowerPack REST API Task but concepts and many UI elements remain same for ODBC […]
Introduction In this post, you will learn how to read / write ManageEngine ServiceDesk data in SSIS (Drag and drop approach without any coding). We will use SSIS JSON/ REST API Source to extract data from Servicedesk API and use SSIS Web API Destination to write data to Zoho. We will look at step-by-step instructions to read ServiceDesk data […]
Introduction In this article, we will show you steps to register OAuth App for Zoho API and use it ZappySys Product. The steps listed here can be used for Zoho Products like CRM or ManagedEngine Products like ServiceDesk (ManageEngine is Zoho’s subsidary). For detailed steps check Zoho’s link here. Register OAuth App in Zoho Go to […]
Introduction In our earlier blog post, we have seen some of the wonderful features of ZappySys Data Gateway. Now, we are exploring in this blog more about How to Secure ZappySys Data Gateway? Some of the new features have been introduced in Network Settings tab of ZappySys Data Gateway. Network Settings On this tab we […]
Introduction This was a minor update release. It fixes important issues with DynamoDB and Salesforce Source. To see full release notes click here New Features/Improvements NEW: Add SiteId parameter to Sharepoint connector, Upload file endpoint NEW: API Connector – JIRA – Add columns to display custom fields with multi select values NEW: API Connector – Zendesk – Added Retry […]
Introduction In this article, we learn how to call SharePoint (on-premises) SOAP API Service in SSIS. If you intend to call SharePoint Online (part of Office 365), we suggest reading SSIS SharePoint Online Connector article. Using SOAP API with SharePoint in SSIS is a common requirement to Administer SharePoint. SharePoint on-premises is a nice Microsoft […]