locked
can we RRS feed

  • Question

  •  

    Can we develop a tool which can access Microsoft Dynamics CRM database?
    Friday, July 18, 2008 7:58 AM

Answers

  • Why can't you use SQL Server Management Studio?

    Directly access sql database is not supported, you may break the database.

    However, you could access FilteredView of CRM database to query things.

     

    Cheers,

    Jim

    Friday, July 18, 2008 8:25 AM
    Moderator

All replies

  • Why can't you use SQL Server Management Studio?

    Directly access sql database is not supported, you may break the database.

    However, you could access FilteredView of CRM database to query things.

     

    Cheers,

    Jim

    Friday, July 18, 2008 8:25 AM
    Moderator
  •  

    We had a developer who never had the patience to access the database and tables through the application server.

     

    You may or may not know that when you customize an entity the table for that entity get's a dual nature or split in the table to define or rather redefine the customization of the entity. Given the complexity from making small changes to the system it would be a good Idea NOT to Work around the arrangement.  

    If upgrades or server moves are involved it's a reall nightmare.

     

    Friday, July 18, 2008 8:56 AM
    Moderator
  •  

    You can query from the database, but if you want to write directly to the database you need to use web service.
    Saturday, July 19, 2008 5:56 PM
    Moderator
  • concerning crm 2011 in the cloud.

    1 ) is it safe to say you cannot hit it from sql server mgt studio, correct ?

    2) can you add tables up there for custom work ? create stored procs, etc ?

    3) is the user interface extendable such that i can add a new page up there when run from a browser ? if so can you use standard markup so that an embedded flash or silverlight application can be housed in that new page ?

     

    basically trying to integrate dynamics with other back end systems without having the user jump from one website to the next. i can do this with salesforce.com by adding a new tab in their interface, and uploading a swf which calls my other systems without leaving salesforce.com

     

    but would rather leverage my msft skills and use dynamics.

     

    thx

    Wednesday, August 3, 2011 2:11 PM