Hello All,
The purpose of my project is to create a trigger that will execute whenever a specific CRM task is made. For this example, lets say whenever the user adds a new contact into CRM. So whenever the user adds a new contact into CRM, I want the trigger to just add some credentials of that contact into a company spreadsheet that is located on the company network OR open a MySQL connection and then write these credentials into a separate MySQL database. The reason I am being so vague about the end goal of my project is because we do not neccessarily know what we want this trigger to do yet, but it will lay within the realm of: accessing a MySQL db, opening and writing to a excel file, or opening a console application (located on our network).
Question 1) Is it possible to use a plugin or an Extension to achieve my purpose?
Question 2) I have already made a Sample plugin, attempted to simply open a MySQL connection when debugging but will always receive a MySQL permissions error, similarly to the one shown here https://stackoverflow.com/questions/5212973/request-for-the-permission-of-type-system-data-sqlclient-sqlclientpermission-s , except I do not have access to these settings as a plugin is a class library and the example shown in the link is a web app.
I am using Dynamics CRM and not 365.
*This post is locked for comments