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.

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.

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.

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.

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.

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.

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.

Discover how to handle unique client cases that require both authentication and payload data sent in the body using the x-www-form-urlencoded format. Set up authentication in Postman, configure the SSIS data flow, and utilize the XML Source component for parsing out data efficiently. In this blog post, we'll show you step-by-step how to achieve this seamlessly using KingswaySoft's SSIS Productivity Pack.