Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Is it Possible to write plugin to get data from CRM 2015 Online and store it in SQL server....???? RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Please help me....!!!

    I have created dll file and registered in plugin,

    In that i have write to get connection from SQL but its not opening the SQL connection from CRM

    connection.Open();//its not working

    Is there any other way to create records in SQL whenever the record is getting create in CRM Online..?

    Thursday, February 26, 2015 10:48 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Jeeva,

    What SQL server are you trying to connect to?

    Regards

    Rickard Norström Developer CRM-Konsulterna
    http://www.crmkonsulterna.se
    Swedish Dynamics CRM Forum: http://www.crmforum.se
    My Blog: http://rickardnorstrom.blogspot.se

    Thursday, February 26, 2015 11:12 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Jeeva,

     CRM online only allows sandbox plugins - which may not allow you to open SQL Server connection from plugin.

    What you may have to do is use some kind of scheduled task that scans CRM online for new records created and update SQL Server - like pull operation from your side.

    You can also try to see if SSIS Integration tool from Kingswaysoft is of any help to you. There are other tools like scribe etc.

    You can also try to create a web service that writes into your SQL server and invoke this webservice from your plugin as per the following article?

    https://msdn.microsoft.com/en-us/library/gg509030.aspx

    Regards,

    Jithesh

    Thursday, February 26, 2015 11:23 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    MS SQL server...its in local system
    Thursday, February 26, 2015 11:39 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Is it even possible to reach the SQL server from the internet? I would say that Jithesh is on the right track. Set up some sort of proxy that connects to the SQL server, otherwise you will have quite a bit of security work to work with.

    Regards

    Rickard Norström Developer CRM-Konsulterna
    http://www.crmkonsulterna.se
    Swedish Dynamics CRM Forum: http://www.crmforum.se
    My Blog: http://rickardnorstrom.blogspot.se

    Thursday, February 26, 2015 9:05 PM