javascript - Extracting SQL Server Value from CRM 2011 - How do I do this? -


ok in crm 2011 have field called contract expiry date , want populate value external sql server database...basically need grab value, nothing fancy start?

i familiar javascript , how use in crm 2011, however, connecting database not recommended use javascript. start this? run query on load of form in crm. ideas, start .net?

thanks help! tudor

it depends want, think have 2 options: plugin or batch process.

a plugin reacts event (create, update, delete, ...) of entity. if want in of event best solution you. in plugin need connect external database , affect field of entity (you have persist value in 1 entity).

if don't have event put code can command line application (batch), can put schedule task, same behavior of plugin (connects external database , affect 1 entity in crm). see here example of plugin.


Comments

Popular posts from this blog

java - Jmockit String final length method mocking Issue -

asp.net - Razor Page Hosted on IIS 6 Fails Every Morning -

c++ - wxwidget compiling on windows command prompt -