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 in SSIS (Replica Set)
Introduction In our previous post we saw how to read / write MongoDB data using ZappySys MongoDB Source and Destination. However it was all about connecting to On Premises hosted version of MongoDB. In this post you will focus on specifically on how to connect to MongoDB Atlas in SSIS (MongoDB Hosted in Cloud). MongoDB Atlas […]