Effective Use of KingswaySoft Email Destination to Send Emails with Attachments

23 February 2024
KingswaySoft Team

Sending emails is a common scenario in integrations, whether for logging a process status, sending a periodic report, job monitoring, etc. Handling this within the SSIS package can be advantageous in many ways, and with KingswaySoft's Email Destination Component, we make it as easy as possible.


Working with Email Attachments for Your Dynamics CRM Integration

30 January 2024
KingswaySoft Team

Moving emails across Dataverse or Dynamics 365 environments, especially handling email attachment records, poses unique challenges due to the specific behaviors of the Dataverse/CRM email attachment entity. In this blog post, we will demonstrate how to work with the ActivityMimeAttachment entity in Microsoft Dynamics CRM for accurate data migration, using the CDS/CRM Destination components available in our Dynamics 365 Toolkit.


Using KingswaySoft to Secure and Use Secrets from Azure Key Vault

21 December 2023
KingswaySoft Team

Azure Key Vault is a popular key and secrets management solution from Microsoft, and it can be beneficial to use it for storing your sensitive SSIS connection credentials for runtime job execution. In this blog post, we will see how KingswaySoft can be used to store and retrieve such sensitive connection information from Azure Key Vault to facilitate a secure connection seamlessly.


Advanced Use of Custom Access Token in HTTP Requests

26 October 2023
KingswaySoft Team

Custom access tokens are commonly used to obtain authorization tokens. Sometimes, they process requires using one of the parsing and extraction strategies. In this blog post we will illustrate some advanced use cases for this feature when using the HTTP connection manager offered in our SSIS Productivity Pack product.


Precisely Managing Metadata Changes in KingswaySoft Components

31 August 2023
KingswaySoft Team

The components we developed at KingswaySoft generally discover metadata automatically whenever possible - That is, our software retrieves metadata information made available by the API itself in order to properly populate our ETL components. In most cases, the metadata in our components is generally accurate, provided the target system has a reliable metadata API. This includes services like Dataverse/Dynamics 365 CE, Salesforce, SharePoint, etc. Accurate metadata is vital for data integrity in ETL processes. However, there are occasional cases where some ETL metadata fine-tuning may be necessary due to unique situations. For instance, you might encounter cases where a text field contains more data than what is indicated by its metadata, potentially causing the source extraction to fail. In such instances, manual editing of the metadata will be required in order for the ETL process to work. In this blog post, we will show you how such changes can be made properly for your ETL components.


Setting Up an OAuth Connection to Business Central Online

26 June 2023
KingswaySoft Team

OAuth offers clear advantages over basic authentication, establishing it as the superior choice for data integration projects that involve processing or consuming your Dynamics 365 Business Central data. In this blog post, we will explore the secure and flexible nature of OAuth, its advantages over basic authentication, and its role in data integration projects. By following the steps outlined in this concise guideline, you will be able to create a connection manager using OAuth authentication for integration with Dynamics 365 Business Central online.


Periodically Clean Up File Folders Using SSIS Productivity Pack

29 May 2023
KingswaySoft Team

Applications and processes often rely on external resources, which can be expensive to retrieve or obtain. Therefore, modern applications often employ cache strategies to save these external resources in the local file system and achieve improved performance. In some other cases, you might have an application that keeps creating random temporary files to facilitate certain system requirements which cannot be achieved otherwise. However, as every coin has two sides, these caches or temporary files, in the long run, can build up in the system and occupy large disk space, which could have adverse effects and result in volume deficiency in the system. Implementing a scheduled cleanup of the cache folder by removing those files that are older than a certain age can become necessary in your ETL process.


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.


Archive

Tags