ssis – Temmy Wahyu Raharjo

Dataverse: SSIS vs. ExecuteMultipleRequest

I am always curious to try SSIS (as mostly my experience is on customizing CRM CE/Dataverse side) as people are always telling me how fast it is to process large data. So today, we will learn and compare ExecuteMultipleRequest vs. SSIS. In the SSIS part, we will be using KingswaySoft for the SSIS Integration toolkit.

For the scenario, I have the Contact records (88606) that we will retrieve and then create a Demo record based on that data.

Dataverse: Update Time zone adjustment from Time zone Independent to User Local and Date time BehaviorMay 18, 2024
Hello everyone! I’m sharing my observation regarding Dataverse Date time (again). Previously, I updated several DateTime attributes from Time zone adjustment “User Local” (which is the default value) to “Time zone independent“. Then, my functional reported that the Date Time seemed weird as the Created On of the record vs … Continue reading "Dataverse: Update Time zone adjustment from Time zone Independent to User Local and Date time Behavior"
Low + Pro Code: Create Dataverse Invoice Record based on Power Automate Extract Invoice InformationMay 12, 2024
Hello! For today’s scenario, we will learn how to automate the process of creating a Vendor Invoice record in Dataverse using an uploaded Vendor Invoice PDF file that comes to OneDrive’s company folder. To be exact, we will learn how to utilize Power Automate to simplify the trigger point, supply … Continue reading "Low + Pro Code: Create Dataverse Invoice Record based on Power Automate Extract Invoice Information"
Dataverse – Convert UTC Time to User Timezone in PluginMay 4, 2024
Today, I’ll share a quick tip on converting the UTC date to the User’s Timezone settings in the Plugin (once you read the logic, you can also implement this logic into Power Automate/Custom API). In Dataverse, we can set our timezone in the below UI (go to Settings > Personalized … Continue reading "Dataverse – Convert UTC Time to User Timezone in Plugin"
[Low Code] Send Translated Message to User using App NotificationApril 27, 2024
Today we will learn how to create a Dataverse Instant plug-in using the AITranslate function. The purpose of AITranslate is to translate a message to the targeted language. For today’s scenario, we will learn how to query the selected Dataverse User’s UI Language and send the translated message using XSendAppNotification. … Continue reading "[Low Code] Send Translated Message to User using App Notification"
Build a Dataverse Plugin and use AIClassify to simplify business processApril 20, 2024
For those who don’t know, now we can call AI functions within Dataverse which helps to simplify lots of business processes. One of the scenarios that we will learn today is regarding Case/Feedback/Incident creation where users can just put minimal information such as “Title“, “Description“, and “Customer” and let the … Continue reading "Build a Dataverse Plugin and use AIClassify to simplify business process"
Dataverse: Implement Pre-lock in a plug-in transactionApril 6, 2024
Lately, my mind has traveled a lot on designing a plugin that can handle concurrency issues. Even though the framework itself has UpdateRequest and we can pass the RowVersion, I found the implementation does not always fit with some of the scenarios especially if you want to avoid throwing “Error” … Continue reading "Dataverse: Implement Pre-lock in a plug-in transaction"
Dataverse: Create an API to update Base CurrencyMarch 23, 2024
This time, I’ve got a request from Trung Dũng Nguyễn where he wants to update the base currency based on the updated Currency inputted into the Transaction Currency table. When I check on the system behavior, the Currency (Base) information will be updated as long as we update at least … Continue reading "Dataverse: Create an API to update Base Currency"
MDA: Learn Xrm.WebApi.executeMultipleMarch 17, 2024
Back again with a deep dive series where we will learn about Xrm.WebApi.executeMultiple. The purpose of the function is to make batch requests (the real-world scenario is to make a bunch of CUD – Create/Update/Delete operations). Because this is a batch scenario, the performance will be faster than the individual … Continue reading "MDA: Learn Xrm.WebApi.executeMultiple"
Dataverse: How the RelatedEntities Plugin WorksMarch 9, 2024
Last week we learned how the RelatedEntity’s performance compares to normal creation. We will create plugins for today’s blog post and inspect how it works. For the side topic, we will also cover CreateMultiple and see if we can make the customizations better in terms of performance. Let’s go!
Dataverse: Performance Benchmark Create Related Entity via a chain of Create vs RelatedEntities propertyMarch 3, 2024
Today’s blog post will be very technical, comparing creating a chain of related entities vs using RelatedEntities properties. Demo’s Relationship As you can see in the above image, Contact can have multiple Parents. And each of the Parents can have multiple Children. For our demo today, we will create 1 … Continue reading "Dataverse: Performance Benchmark Create Related Entity via a chain of Create vs RelatedEntities property"