Limitations to the data import into AX 2012

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

André Arnaud de Cal... 301,049 Super User 2025 Season 2 on at

Like (2)

Report

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.

Was this reply helpful? Yes No