345
I faced little perplexed task that I should bring data from csv files(which is automatically and repeatedly made by other program).
I'm not going to use batch to get the files because batch will make performance issue.
Therefore I want to use a service to bring the csv files whenever the file is generated with minimal effect on AX performance.
Is there any useful service that I can use?
*This post is locked for comments
Hi Daniel,
Like Biztalk does for message processing, the AX batch service is polling for batch jobs to be executed. This polling is done by the kernel and has no impact on the performance for uses. When a batch job is executed, it can give issues, depending on the code used and table/record locks when inserting or updating records. If you import a CSV file or use a service to insert records, the impact is somehow the same.
Hi Daniel!
There is no difference using batch task or service if the logic of manipulation with csv file written in AX.
As example, you can put your file to specific path from where batch task can take it and after processing you can remove the file.
First of all, the minimum interval for running batches in AX is one minute.
Second, you can speficy the interval yourself. For example it could run once every hour. It depends completely on your business requirement - how often do you need it to check for new files?
The easiest solution - which doesn't even require coding - is to use DIXF (Data Import Export Framework). With it you can schedule a CSV import at your desired interval.
Hi, Andre,
I think, for example, if the batch will run every a few seconds, then it will call some specific queries or functions and will make performance issue.
Do you mean it won't? If so, could you please explain briefly about operation of batch?
Hi Daniel,
What makes you think that using the batch framework, you will get performance issues? In general this is not true.
You can use the Application Integration Framework, if you want to use services. You can find information on the next page: docs.microsoft.com/.../services-and-application-integration-framework-aif
Usually, another program is calling the service. If you have CSV files, the CSV files itself cannot call the service. So, try to see of your other program can also call the Dynamics AX 2012 services.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#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
Share
Report
All responses (
Answers (