Access to CRM Online source database RRS feed

  • Question

  • Hi all,


    Do you know if it is possible to access the database CRM views in an Online scenario for information retrieving? Is there any kind of guide/sample/best practice I should check for that?

    If it is not possible, is there any other option to export data out of CRM?


    Thanks in advance



    • Moved by Xiaopeng Wu Tuesday, March 8, 2011 9:28 PM Forum consolidation (From:CRM Online)
    Friday, February 11, 2011 1:31 PM


All replies

  • There is no direct access to MSCRM database.  You can retrieve data using export to Excel from any view or report.  Fetch XML Reports and export.  There are also 3rd party import/export tools.  Finally there is the SDK option.
    Follow Workopia on Twitter

    Good CRM Links: http://www.workopia.com/Links.htm
    My CRM Blog: http://microsoft-crm.spaces.live.com

    Friday, February 11, 2011 2:34 PM
  • Is there any other automated tool/procedure for backing up CRM data? I think that  I can invoke the web services to retrieve all the information needed programaticall, but I was thinking that another (automated) option could exist. Am I wrong?
    Monday, February 14, 2011 9:10 AM
  • There is no standard feature for providing an automated backup option. As Frank mentioned, you need to develop something using the SDK, or buy a third-party tool that provides this feature.

    Regards, Neil

    Neil Benson, CRM Addict and MVP at Customery Ltd. You can reach me on LinkedIn or Twitter. Join over 10,000 other CRM professionals on the Microsoft Dynamics CRM group on LinkedIn.

    Monday, February 14, 2011 11:11 AM