37
Hello,
One of our customers need ETL jobs to be scheduled from Business Central to other applications , such as Salesforce. What is the best way to accomplish this task. Can we use job queues and web services to get this done.
Any suggestions would help.
Thank you.
Anjana
When it comes to Saleforce in specific it might be worth the time to evaluate some of the solutions that are available for this on AppSource.
appsource.microsoft.com/.../apps
For a more general approach I would say that it depends on what kind of integration platform the other application are providing.
If you can connect to the other application using API's writing AL code for that and run it on a schedule is in general a good approach.
And you have a http client available in AL to do that.
Some applications might also be able to consume the API's that Business Central publish and then that might be a good approach because then the other application can ask for the data when needed instead of having data pushed. That will probably reduce the "stress" on both applications.
If you have a more complex integration landscape maybe you would want to look into using Azure logic apps or Azure integration service.
Using Power Automate is also a popular approach - but i would not recommend that because the Power Automate flows are connected to a specific user and can be difficult to monitor on a solution level.
Please circle back if you need more details around specific aspects of this.
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,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (