Using KingswaySoft to Integrate with Couchbase Capella Managed Instances

28 February 2024
KingswaySoft Team

Connecting to Couchbase Capella presents challenges that require additional procedures outside SSIS. These can lead to connection errors and present a significant obstacle during setup. In this blog post, we'll guide you through the process of seamlessly integrating with Couchbase Capella's online managed instances using the Couchbase Connection Manager.

 About 

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 HubSpot CRM Associations with Ease Using KingswaySoft

31 January 2024
KingswaySoft Team

Associations are used in HubSpot to define a relationship between objects and activities. It is critical to have these properly defined to keep your data and relationships as intended. In this blog post, we will show you how to use KingswaySoft components to easily create and maintain HubSpot associations.


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.


Use Homogeneous Batch Operation Messages for Greater Dataverse/CRM Writing Performance

29 November 2023
Daniel Cai

Microsoft has recently announced the general availability of their xMultiple APIs, which can provide some substantial performance improvement. In this blog post, we will outline some of the details of using the new API.

 About 

Merge and Store XML Files Directly to Cloud Using KingswaySoft

27 October 2023
KingswaySoft Team

As an ETL Developer, you may have use cases where you would need to process tabular data in order to produce an XML/JSON file to be saved in a cloud location. Usually, this is done by first merging and creating an XML file in a local or network path and then, on a regular basis, moving it to the cloud storage. However, for users who are running their SSIS packages on the cloud via ADF and who do not wish to use local storage, this could be a roadblock. In this blog post, we will discuss a technique that facilitates direct file writing using KingswaySoft SSIS Productivity Pack components.

 About 

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.


Archive

Tags