News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Limitations to the dat...

Microsoft Dynamics AX (Archived)

Limitations to the data import into AX 2012

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

Hi,

We are planning to use SSIS or the a custom service endpoint to import data into several tables in AX 2012, every 2 hours.

I want to ask whether there are any limitations to the amount of data that can be imported at once, as we may rarely have cases where we would need to import 50 000 - 100 000 rows of data into AX 2012, and we want to know whether that is possible?

I read through some of the questions here and didn't find any limitations myself, but suggestions that the data should be split into chunks of up to 10 000 rows in order to manage the import better.

Thanks.

Best Regards,

Evgeni Dyulgerov

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at

Like (2)

Report

RE: Limitations to the data import into AX 2012

Hi Evgeni,

There are no limitations in the number of rows. However like Crispin mentioned, hardware and sizing is important. You need to see if the custom service can handle it correctly. So do good full load tests. You can also have a lok at the data import export framework. This is using a two step strategy where initially data is loaded in staging tables. This process is very fast. Then the staging to target can be scaled using the batch framework and multiple threads to divide the workload.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,235 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans