web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance forum / How BYOD works when ex...
Finance forum

How BYOD works when export data to database(commit transaction)

(1) ShareShare
ReportReport
Posted on by Shinji Hoang 237

I have one question about the Bring Your Own Database(BYOD).

When I run exports data from D365 for FO using BYOD.

How it works when I click the Export button.

For example, I export 1000 records,

1. BYOD commit one time with 1000 records to BYOD database.

OR

2. BYOD commit one by one record to BYOD database?

How to verify this case?

I am waiting for your answer.

Thanks in advance.

Categories:
Data Integration
Development / Customization / SDK
I have the same question (0)
  • Blue Wang Profile Picture
    Blue Wang on at
    RE: How BYOD works when export data to database(commit transaction)

    Hi Kaneko,

    This process executes batch processing through entity export.

    You can get some information you need by threading and tracking threads.

    https://stoneridgesoftware.com/how-to-multi-thread-your-imports-in-dynamics-365-for-finance-operations/

    I hope it will help you.

  • Shinji Hoang Profile Picture
    Shinji Hoang 237 on at
    RE: How BYOD works when export data to database(commit transaction)

    Hi Blue Wang,

    Thank you for your answer.

    Does it mean this process exported one time with all records to the BYOD database?

    Regards,

    Kaneko

  • Verified answer
    Blue Wang Profile Picture
    Blue Wang on at
    RE: How BYOD works when export data to database(commit transaction)

    Hi Kaneko,

    Sorry, I am late.

    On Data entities form there is a column called "Set-based processing" that can be used to enable that functionality on entity level. It means that instead of iterating the staging table and inserting records one by one to the target table, D365O gathers everything in one bunch and inserts it in one SQL statement. 

    About performance tuning, you can refer this: https://community.dynamics.com/365/financeandoperations/b/365foroperationstechnical/archive/2017/06/06/dynamics-365-for-operations-integration-performance-tuning-tips

    I hope it will help you.

  • Shinji Hoang Profile Picture
    Shinji Hoang 237 on at
    RE: How BYOD works when export data to database(commit transaction)

    Hi Blue Wang,

    Thank you very much for your help.

    "Set-based processing" is useful for import/export with a large amount of data.

    Some data entity does not support "Set-based processing" function.

    If I do not check "Set-based processing", when I export data by using BYOD, how its work? (export one by one to BYOD database)

    How to export in D365 for FO standard?

    Appreciate any more ideas.

    Many Thanks.

    Kaneko.

  • Suggested answer
    Sheikh Sohail Profile Picture
    Sheikh Sohail 6,125 on at
    RE: How BYOD works when export data to database(commit transaction)

    Hi Kaneko

    I haven't use Set-Based processing feature, but for testing purpose I executed the export project and found its committing data randomly.

    Important one

    My entity was custom and during export it was not using staging table.

  • Blue Wang Profile Picture
    Blue Wang on at
    RE: How BYOD works when export data to database(commit transaction)

    Hi Kaneko,

    Yes

    Just like the thread I mentioned to you earlier,

    They always compete.

  • Shinji Hoang Profile Picture
    Shinji Hoang 237 on at
    RE: How BYOD works when export data to database(commit transaction)

    Hi Sheikh Sohail Hussain

    Thank you for your answer.

    Currently, I export data from D365 to the external database using BYOD.

    I think D365 use the staging table to export data.

    Can you tell me detail about your case?

    Are you using data management to export data?

    Are you export data to file or other databases?

    Appreciate any more ideas.

    Thank you and best regards.

    Kaneko.

  • Shinji Hoang Profile Picture
    Shinji Hoang 237 on at
    RE: How BYOD works when export data to database(commit transaction)

    Hi Blue Wang,

    Thank you so much for your help.

    I will check again in my D365.

    I try to export data to the external database using BYOD,

    the SyncStartDateTime field of the external database has the same value as all records.

    So, I confuse that it exports one time in batch? (Now I have not to check set-based processing)

    Thank you and best regards,

    Kaneko.

  • Suggested answer
    Sukrut Parab Profile Picture
    Sukrut Parab 71,699 Moderator on at
    RE: How BYOD works when export data to database(commit transaction)

    As far as I know , data is Import/export was done using SSIS packages  in earlier versions and all must be inserted using bulk operation, so it must be true for D365 as well. Set based processing is used to insert data in D365  and skips all validations on the table.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Finance

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans