In this blog, we share a lesson learned when using a Dynamics 365 Customer Engagement online data source connector, called Instance Web API, for Power BI reports.
In this blog, we walk through how to use Microsoft Flow to create Dynamics records using a scheduled Flow.
In today's blog, we'll walk you through the steps necessary to upload a file to Azure Blob from SSIS. Enjoy! 1. Open Visual Studio > New Project > Integration Services Project and click to create a new Integration Services Project. Rename the newly-created .dtsx file as needed. The initial screen will look like this: 2. […]
There is often confusion about how GUIDs work, how unique they are, and how they are generated in CRM. Read this blog to get some better insight into GUIDs!
Data integration and migration is a challenging tasks in any Dynamics 365 implementation - in this blog we share some ways to tackle performance issues.
Here's how to call a custom action in a SSIS Integration in Dynamics 365 in order to take advantage of advanced business logic during a data import.
A common request we see is the ability to extract and report on audit data gathered by CRM. If you have done any work or research around this topic, you may have found that it can be tricky. Lucky for you, today's blog will help you solve this issue by teaching you how to use KingswaySoft […]
When importing data into Dynamics CRM using SSIS, you also need to import your Created on/by and Modified on/by data. Previously, you could only import CreateOn fields by mapping the "overriddencreatedon" field with source data. We now have at least two supported options to update these fields, and in today's blog, we will show you […]
When you are building an integration using SSIS, chances are you will need to update or insert data that has been created or changed in the source system on a regular basis. The SSIS job must be able to identify the newly created records versus the changes to existing records and perform the updates and […]
When you are building a bi-directional integration between CRM and an external application using SSIS, chances are you will need to send data that has been changed by a user in CRM on a regular basis. There are a couple of key challenges with this approach, given the traditional mechanism to deal with changes by […]
If your SSIS project is deployed to SSIS catalog i.e. SSISDB and you lost your source project file, then you need to edit the SSIS packages in the deployed project. In this blog from PowerObjects, we will discuss how to retrieve your project/packages. Option 1: Integration Services Import Project Wizard Open a new project from […]
The use of SQL Server Integration Services (SSIS) for migrating and integrating data to Dynamics CRM allows for a level of adaptability and versatility that is unmatched in the right hands. Additionally, the customizability and versatility of SSIS allows for performance tweaking and enhancements to maximize data throughput. One of the most significant methods of […]
If you couldn't tell by the title, we're going to go beyond CRM 101 and get a little more technical in this post. Specifically, let's talk about a few important new features of SSIS 2012 that can help BI developers. SSIS 2012 introduced a new feature called Integration Services Catalogs, which means that now we […]
Almost every CRM implementation project has a data component, whether it is migrating data from your legacy system or integrating CRM to/from another database or application. Especially integrations have become more important, the user-friendly user interface of CRM is the preferred application for users and with good integration plan the users can drive their ERP, […]