Extracting CRM entity metadata using KingswaySoft JSON Components
In this blog, we are trying to get the metadata information from Dynamics 365 CRM API and save the entities and attributes in different tables. This is useful in many use cases where you wish to get a list of all the entities that are present, and its corresponding metadata as a part of your integration - Especially for further parameterization plans.
Action Required for HubSpot Connections to Stay Compliant with Contacts Scope Updates
HubSpot has announced some recent security enhancements in their APIs which now provide more granular CRM scopes. With this change, you will need to update your HubSpot connections in order to stay compliant.
Read and Load Data Files Iteratively from a Storage Location
There are cases where we would need to retrieve a set of files from a storage location, which are dropped on the same day, and read them one by one, to then store them into a database table. We can easily achieve this using KingswaySoft components and the SSIS Foreach loop container.
Working with QuickBooks Desktop Custom Fields in SSIS
Custom fields have some special behaviors in the QuickBooks desktop application, which makes them to some degree difficult to work with if we don't know exactly how to work with them. This can create some substantial challenges for any integration projects that you might be working on. In this blog post, we will explain how to work with custom fields using our SSIS Integration Toolkit for QuickBooks by giving you some detailed instructions which we hope you may leverage in your integration projects.
Construct ActivityParty JSON Values for Dataverse Activity Entity Migration
In this blog post, we will show a simple solution that can be used to generate the JSON structure from database tables which can be sent to CDS/CRM destination components for writing, we demonstrate the use of SQL FOR JSON clause to achieve the purpose.
Executing Snowflake Functions in SSIS ETL Processes
The Snowflake command task that is a control flow level task can be used to easily execute functions in Snowflake and use it for further data flow executions.
Convert Word documents to PDF Leveraging Google Drive Platform
It is a very common business requirement that in our job we may receive documents in some particular formats, which the business team would like to have them converted into PDF files. Such requirements arise from many of the advantages when using PDF formats for file exchanges, such as portability, universal compatibility, reliability, security, size reduction, versatility, professionalism, etc. Given such common requirement, it would be highly useful to have a tool that can pick up documents from a specific location and have them converted to a PDF files in an automated manner, such as an automated ETL process. In this blog post, we will show you how to easily achieve this using components from our SSIS Productivity Pack product offering.
Working with Business Central/NAV REST API v2 in SSIS
This post will walk you through how to query the Dynamics Business Central/NAV REST API data by using the Premium OData Source component.