Microsoft client-relationship-management-system (Microsoft CRM) and Microsoft RMS are both Microsoft SQL Server-based applications, but historically industry-leading Microsoft software applications, such as package options is now was Microsoft RMS purchase. RMS design fundamentals were so long before Microsoft CRM coined. But, even integration between the two is straightforward, and what you need, systems, structures and customization scenarios is familiar. Microsoft CRM with Microsoft Great Plains is currently integrated and is integrated in the near future with Microsoft Navision, RMS integrate our knowledge is not planned, so that you are looking for third-party solutions or create your own integration. We see the need for such integration, if you sell to account in RMS and have automated call center for customer support with Microsoft CRM. We give you highlights:o Microsoft CRM custom search. Rather you will nee lookup to your RMS Headquarters or memory records for the accounts receivable postings by account screen. Microsoft CRM can custom navigation bar on the account screen you your custom Web might call by clicking on this bar.NET application, call Microsoft RMS database and return to the grid of the customer bookings
o RMS architecture digression. Microsoft RMS has central and information store databases. The exchange between the two databases based on the worksheet. Most of the nature of the transaction are initiated at the storage level and transferred to the central database (except some global data is global clients such as at HQ level and then passed to the business).
o request and update data. The MS RMS architecture proposes you modified queries in particular central database and data in the HQ database. If you change the data at the storage level of Microsoft CRM custom screen - should to take on the SQL Server hardware in the store, placing Web service transaction initiated the memory
o Microsoft CRM programming. Microsoft CRM has MS CRM Software Development Kit (SDK). This is an open source tool, you can use it from the Microsoft site and it's description of Microsoft CRM classes and methods with sample code in c# and VB.NET. Microsoft product support services recommends using Microsoft CRM SDK objects and discouraged direct SQL Server programming. If you want to query MS CRM database - create your custom database, and your belongings: are SQL views and stored procedures. Insert user-defined object in MS CRM databases