Best Practice for Logging Third-Party Integration Transactions in D365 FO

(0) Share

Report

Posted on by D365FO Junior-Dev

455

Hello everyone,

I need your recommendation on the best approach for storing and maintaining integration logs between a third-party application and D365 FO
Is it acceptable to store custom API service logs and batch job logs in a custom table inside the D365 FO database or is it better to use external resources such as Azure SQL Database or Azure Table Storage?
My main concern with using a custom table inside D365 FO is the potential performance impact especially as the volume of transactions grows and slowness.
For more infromation:
- A third-party application sends Sales Orders daily to D365 FO.

- D365 FO batch jobs then generate the Sales Order, Packing Slip, and Invoice.

- After invoicing, D365 FO triggers Business Events (for example, when a Sales Order is invoiced for certain customers) and sends updates back to the third-party application.

I would really appreciate your suggestions.
Thanks in advance!

Categories:

Dynamics 365 Finance

Microsoft Dynamics AX

I have the same question (0)

All responses (2)

Answers (0)

Martin Dráb 238,324 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Any reason not to use Application Insights?

It's designed for logging, the data is stored outside F&O, it's integrated with F&O (and you can let errors, for example, log automatically), it's supported by many other things you may be using for your integration, such as Azure API Management or Azure Functions.

Was this reply helpful? Yes No
Suggested answer

Komi Siabi 13,148 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

You can store the logs in D365FO database. But you should have a batch Job that auto deletes old logs ( for example , all success log records GreaterThanDate(30)). This can be predefined or users defined.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Best Practice for Logging Third-Party Integration Transactions in D365 FO

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the December Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Best Practice for Logging Third-Party Integration Transactions in D365 FO

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the December Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates