Introduction In our last post (Regex Cheat Sheet) we explained use cases of SSIS Regular Expression Parser Task . Now lets look at some real world usecase. Basically in this article we are going to Extract data from audit log using SSIS. For demo purpose we will use log generated by SSIS Export CSV File Task output. When […]
Monthly Archives: May 2020
How to read Salesforce Metadata in SSIS using REST API (JSON Source)
Introduction In our previous posts we saw how to read and write Salesforce Data using SSIS. In this post we will see how to read Salesforce Metadata in SSIS using JSON Source. Step-By-Step In this section you will learn how to use ZappySys JSON Source Adapter to extract data from Salesforce REST API (JSON Format). You […]
SSIS PowerPack v3.1.2 released
New Features/Improvements NEW: Dynamics CRM Destination – Allow to update OwnerID field in older CRM version (i.e. lower than v9) NEW: Dynamics CRM Destination – Use mapped type field in Update / Upsert operation to set EntityReference fields (e.g. ownerid ) – Right now system picks first type from Allowed LinkedEntity list (see Advanced Custom Properties) NEW: General […]
Using Custom Objects in ZappySys Drivers (Proc / View)
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). For more information you see here Custom Objects There are mainly […]
How to connect to MongoDB Atlas Replica Set Cluster in SSIS
Introduction In our previous post, we discovered how to read and write MongoDB data using ZappySys MongoDB Source and Destination SSIS connectors. However, it was all about connecting to the on-premises hosted version of MongoDB. In this post, we will focus on connecting specifically to the Replica Set Cluster in MongoDB Atlas (a cloud database service by MongoDB). After […]