Use KingswaySoft Components as the Replacement of the Deprecated DES Service

27 July 2022
KingswaySoft Team

As you all know, Microsoft is deprecating their Data Export Service (DES), which has been used by many enterprise clients for data archiving purposes. There isn't a proper replacement option offered by Microsoft after the deprecation. In this blog post, we will discuss how you can use our SSIS Components to achieve the same purposes.

 About 

Working with Concur API to Close Batches and Retrieve Report Files using KingswaySoft Components

28 June 2022
KingswaySoft Team

SAP Concur is a widely popular service for travel, expense, and invoice management, and there are many use cases in which you would need to access the endpoints to process a request and get the response back. One such business case would be finding and closing batches based on processed batch numbers, downloading a report, and storing the data in a database system. We will see how this can be done using KingswaySoft components.


Download Document Version History from SharePoint in SSIS

27 June 2022
KingswaySoft Team

SharePoint Document Library supports version histories, so you can store and track different versions of each document file within the library as changes are made to the file. Such version control infrastructure provides many unique benefits. For instance, if something went wrong with one of the files because of a recent accidental/unintended change, you can easily restore it to a prior version as needed. Also, in your ETL development, you might often run into the requirements that you need to extract all previous versions of a file. In this blog post, we will show how to achieve this using our SharePoint Source component to download document library file versions and using the Premium File System Destination component (offered in SSIS Productivity Pack) to save them to a local file system in SSIS.


Working with NetSuite Custom Fields using KingswaySoft SSIS Components

31 May 2022
KingswaySoft Team

NetSuite Custom fields are fields that you can add to records and transactions which can be used to save some additional information. This provides quite some flexibility when working with the NetSuite application if we have some special business requirements which cannot be accomplished using those out-of-box fields. Once added, those fields require some special attention in order to use use them in SSIS ETL data flows. In this blog post, we will show you how this can be done easily by using KingswaySoft components.


Extracting CRM entity metadata using KingswaySoft JSON Components

30 May 2022
KingswaySoft Support

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

28 April 2022
KingswaySoft Team

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

13 April 2022
KingswaySoft Team

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

12 April 2022
KingswaySoft Team

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.


Archive

Tags