255
Hi
I'm extracting data from multiple CRM entities when the modified date changes using Fetch XML.
This seems OK and I've populated my vars ready to process the data.
Next step is to export that data to an external SQLserver instance.
Can I use a simple SqlConnection and SqlCommand inside the Plugin to do this?
Please say yes :)
*This post is locked for comments
OK so if i use the following to connect o the webservice from the plugin.
What is the syntax for passing multiple parameters to the service? (data for the sql insert)
method name is UpdateApplication
Share
Report
All responses (
Answers (
tracingService.Trace("Start DB insert.");
BasicHttpBinding myBinding = new BasicHttpBinding();
myBinding.Name = "BasicHttpBinding_ICrmDataInsert";
myBinding.Security.Mode = BasicHttpSecurityMode.None;
myBinding.Security.Transport.ClientCredentialType = HttpClientCredentialType.None;
myBinding.Security.Transport.ProxyCredentialType = HttpProxyCredentialType.None;
myBinding.Security.Message.ClientCredentialType = BasicHttpMessageCredentialType.UserName;
EndpointAddress endPointAddress = new EndpointAddress("http://xxxxxx.com/Service.asmx");
CrmDataInsertClient client = new CrmDataInsertClient(myBinding, endPointAddress);
..... etc
Many thanks
That cannot be done, but you should be able to use access the web services/api of the SQL Server in order to access data.
This way you should still be able to use this functionality, but just not ADO/OLEDB.
Hope this helps.
Yes ..If you are using On Premise ,Database call is just a .NET code for you :-) but for on-line either you should go with WebService Option or using some data integration tools like Scribe Insight ,Kingsway ,MuleSoft ,LogicApps etc.For Online deployment of Dynamics CRM ,plugins must be registered in Sandbox mode and it will not allow you to communicate with Database directly.
IP and address make difference in case of Sandbox Plugins .
Hi
Thank you both for the comments.
My db is on AWS so I have a string rather than an IP address.
Does this make any difference here?
using (SqlConnection myConnection = new SqlConnection("Data Source=xxxxx.eu-west-1.rds.amazonaws.com;Initial Catalog=APPLICATIONS;User ID=xxxxx;Password=xxxxxxx;Integrated Security=false"))
Hi Stuie,
Are you using CRM Online or CRM OnPremise? If you are using CRM Online, then you can only use Sandboxed Plug-ins. With those there are some limitations. See msdn.microsoft.com/.../gg334752.aspx :
"Sandboxed plug-ins and custom workflow activities can access the network through the HTTP and HTTPS protocols. This capability provides support for accessing popular web resources like social sites, news feeds, web services, and more. The following web access restrictions apply to this sandbox capability."
So i don't think this is possible.
If the Plug-in doesn't run in Sandboxed mode (onpremise only) - i don't know if this will work or not.
Maybe it would be worth considering that you have an webservice interface between CRM and your SQL DB. Then CRM can send data to that webservice and the webservice, do the SQL Operations.
Hope this helps
Regards,
Radu
as far as I know, the reply is no :)
due to the limits of the partial trust of the assembly you will not be able to connect directly to an internet exposed sql server.
However as always you can create and call a webservice and the webservice will take care of doing the updates of your sql server.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156