Hi,
We're exporting D365 F&O data entities to an Azure SQL database BYOD for use in other processes and Power BI reporting, and currently have SQL stored procedures which run on a recurring schedule to ETL the D365 BYOD data to our main data warehouse reporting database.
This method currently causes us issues in terms of syncing the processes to get consistent results in terms of reliability and timing of data updates in the data warehouse.
We want to use the 'Enable triggers in target database' setting in the 'Configure entity export to database' to trigger these SQL stored procedures to run the ETL processes, but can't find any instructions of what this setting actually does and how it can be used to achieve our requirement. All the Microsoft documentation says, is to switch on this setting and then nothing else about what needs to be configured on the SQL side of things, as if it will all just magically happen by itself. Unfortunately it doesn't.
Is anyone else using this setting and could help us understand what config we need to do in SQL to use this functionality? Pointing us in the direction of any documentation on it would be extremely helpful, but please don't just send the link to the Microsoft BYOD document as its doesn't contain what we need. (https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/analytics/export-entities-to-your-own-database)
Many Thanks
Chris
