SQL Triggers / Write access to database ?

(0) Share

Report

Posted on by Nikos06

Hi, I have an online dynamics crm application (xxxx.crm4.dynamics.com) and I'd like to monitor changes (insert, update and delete) on some entities and record those changes into a custom table.

With an SQL trigger it would be very easy to do so but I'm afraid the feature is not supported.

I can connect to the DB using sqlcmd or SSMS but the database is read-only.
Is there a way to gain write access to the database ?
Is it possible to create SQL triggers on the database ?
If not, are a plugin or an action from workflow the only ways to create SQL like triggers ?

Best regards,
Nicolas.

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Wahaj Rashid 11,321 on at

Like (1)

Report
Hi,

Thank you for your query.

Write access on Database is not supported for online version. Even for on-premise it is not recommended.

To track changes, you can enable Auditing, which will record any changes made to the records (CRUD) for the configured entities and fields.

Audit data and user activity for security and compliance - Power Platform | Microsoft Docs

Please note, there following levels of Auditing:

Global Auditing Settings: Go to Advanced Settings -> Auditing -> Global Audit Settings.

Entity Level: you can turn on or off Auditing for an entity.

Field Level: when auditing is enabled for an entity, you can choose fields to be audited.

Here is an article on how to enable auditing:

Enabling Auditing of Dynamics 365 Entities (coveo.com)

Once, Auditing is enabled, you can see the Auditing Log in:

Audit Summary View: Go to Advanced Settings -> Auditing -> Audit Summary View.

Entity: open a record to see its Audit Log (Related -> Audit History).

You can extract Audit Data using:

Audit History Extractor · XrmToolBox

Was this reply helpful? Yes No
Nikos06 5 on at

Like (0)

Report

Thank you very much Wahaj !

Was this reply helpful? Yes No

Join the conversation

Community site session details

SQL Triggers / Write access to database ?

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates

Community site session details

SQL Triggers / Write access to database ?

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates