News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Intergration Manager

Finance | Project Operations, Human Resources, ...

Suggested answer

Intergration Manager

(2) Share

Report

Report

Posted on by Kelly Moss

97

When I upload my data to Dynamics GP the first batch is quick to upload, but each one I do get slower. Example I had one today that was 1183 lines that took 51 minutes then the second batch I uploaded was 469 lines and it took 41 minutes. I restarted Dynamics and uploaded another batch of 750 lines, and it took 23 minutes. Does anyone have any ideals that will help? Thank you.

Categories:

Microsoft Dynamics GP

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Lisa at AonC.com 3,120 on at

Like (0)

Report

Intergration Manager

Without knowing the integration source, integration destination, or your installation environment/version, it is hard to have specific answers.
Here are a few possible areas to explore:
-Does your integration require multiple sources?
-What is the query relationship between the sources?

-How many rows are in your source files? (The more data you are reading the slower, it will go.)

-What are the integration INI settings?

-Are there network/security issues with the location of the IMD file and the sources?

For large integrations, it can be faster to break the integration into smaller pieces (for example 10 integrations with a tenth of the data lines in each integration than 1 large integration).

[Watch the Progress window to see how fast the first records import compared to later in the integration.]

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 290,990 Super User 2024 Season 2

#2

Martin Dráb 229,656 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans