Periodically Clean Up File Folders Using SSIS Productivity Pack

29 May 2023
KingswaySoft Team

Applications and processes create local caches in the hard drive folder that require periodic cleanups. The Team foundation Server builds the cache on the client machine, which in the long run may create space or volume issues in the machine. A purge of these caches would be needed in this scenario. However, deleting recent caches as soon as it builds may not be a good idea too. Therefore, periodic deletion of historic caches could be a feasible approach. We will show you how this can be achieved using KingswaySoft.


Using Premium File Watcher Task to Monitor File Changes in an ETL Process

30 March 2023
KingswaySoft Team

In the general integration practice, it is a very common use case to monitor a folder path for any file changes, and as soon as a file with certain criteria lands in the folder or gets modified, a process should kick off or otherwise, an email notification should be sent via email. With the new Premium File Watcher Task added to our SSIS Productivity Pack in our most recent v23.1 release, this can be easily achievable in an automated fashion. In this blog post, we will demonstrate the design and configurations required to watch a file path on a continuous basis and send an email notification when a specific change happens in it.


Working with Embedded XML Content in an ETL Process

23 February 2023
KingswaySoft Team

In some unique cases, we may receive an XML document that needs to be processed in the ETL process, which might contain general XML content but includes some embedded XML content made of escaped characters. The integration requires the embedded XML content to be fully parsed and processed. In this blog post, we will show you how to properly handle and transform mixed XML content with escaped characters to ensure the successful parsing of API responses and files.


Manage Unlicensed Users in CRM Using KingswaySoft

24 January 2023
KingswaySoft Team

While migrating from CRM to CRM, or any other Source system to CRM, in an ETL, records will need to be associated with users. And since the Source and Target Systems are different, there may not be a guarantee that some users may still exist in the organization. And in such cases, such users become either unlicensed, or stub users. These type of users have restrictions when it comes to being set as an owner of records, and in this blog post, we will see how this can be handled efficiently.


Preserving Sensitive Properties in SSIS Packages

19 December 2022
KingswaySoft Team

In SSIS, the sensitive credentials have to be handled in a special way to ensure that they get preserved and decrypted while the packages run in an unattended way. There are a few means to do this, and in this blog post, we will discuss some popular ways this can be done.


Implementing Retry Logic in Custom HTTP Requests Using KingswaySoft

09 November 2022
KingswaySoft Team

There are many reasons you might need to send retries on failed HTTP-based service requests, particularly when you are working with API integration in an ETL process. Now, a simple retry can easily be done in the HTTP Connection Manager using its built-in Retry on Intermittent Errors option. In addition, there might be cases in which you would want to implement a more customized retry on additional HTTP errors to facilitate a more resilient integration process. In this blog post, we will see how KingswaySoft can help in both scenarios.


Split and Parse Through JSON Structures using KingswaySoft

30 September 2022
KingswaySoft Team

Having a JSON response that needs to be properly parsed is a very common use case. This can be an advanced JSON structure like arrays, key-value pairs, etc. Our KingswaySoft JSON components can easily parse through them using the various settings and options available. However, there could be cases in which a JSON design is such that it could have records that need to be handled separately. In this blog post, we will discuss such a case.


Using KingswaySoft to Work with Salesforce Bulk API

26 September 2022
KingswaySoft Team

If you have a large number of records, you need to read and the process is taking longer than anticipated you may benefit from using Salesforce’s Bulk API. Salesforce Bulk API benefits you when you have many records (Salesforce states data operations with 2000+ records make a good candidate) in the Salesforce system and these records are being read synchronously. Today we will look at the features in Salesforce Bulk API and how KingswaySoft components make Bulk jobs easier.


Archive

Tags