Using SSIS to Mask Data to Assist with GDPR Compliance
SSIS can be a useful tool in assisting with GDPR compliance. In this blog post we will demonstrate how to use SSIS to mask information in an environment so that the data structure remains intact but no sensitive information is stored on the environment.
How to Work with Different OAuth 2.0 Grants in SSIS
In this blog post we discuss how to work with OAuth 2.0 Password and Client Credentials grant types when working with web service endpoints in SSIS.
Running SSIS Integration Toolkit on the Cloud
In this blog post, we specifically discuss how you can deploy our software and run it in Azure SSIS Integration Runtime (IR) by leveraging our most recent Spring 2018 release.
The Center for Health Affairs uses SSIS Integration Toolkit for more efficient Microsoft Dynamics CRM Integrations
The Center for Health Affairs & CHAMPS Healthcare provide a variety of services oriented around healthcare. They rely on Microsoft technologies in order to increase business efficiency in improving the health of the community. They use SSIS Integration Toolkit to keep the data in those application up to date and drive their business processes.
Integrate Google Analytics with SQL Server Using SSIS
Looking to reduce the time spent creating our monthly Google Analytics reports, in this blog post we outline the steps we took to automate our Google Analytics to SQL Server integration using SSIS Productivity Pack.
Announcing Migration Starter Pack v3.0 for Microsoft Dynamics 365 Customer Engagement and CRM On-Premise
Our CRM migration starter pack has been widely used by many clients worldwide. We have just made some further enhancements to cover some important migration tasks.
How Better Bathrooms Uses SSIS Productivity Pack to Consume REST APIs in SSIS
In our recent case study we spoke with the team from Better Bathrooms to learn more about how they are using SSIS Productivity Pack in their data warehouse process to retrieve data from various REST APIs.
How to Work with RESTful Endpoints in your SSIS ETL Process
Connecting to an integrating with a REST API in SSIS can be a tricky process. In this blog post we will walk you through how our SSIS Productivity Pack can be used to simplify the development process. We will be working with ZenDesk as an example to demonstrate integration with a REST API feeding data in JSON format.