CRM CLR Stored Procedures

What are CRM CLR Stored Procedures?

Fusion CRM CLR Stored Procedures provide a simple and easy method to create, update and delete data in Microsoft CRM 4.0. The product is designed for migrating data from an existing system or for simply updating CRM Data safely and easily.

CRM CLR Stored Procedures provide tools that will be easy to use by anybody familiar with SQL Server development. The .Net CLR stored procedures use the CRM web service API to provide a fully supported method of data manipulation that guarantees the integrity of your data.

Features:

Create, Read, Update and Delete any entity in CRM, including custom entities.
Set state, ownership and create many-to-many relationships between entities.
Familiar development environment can be used within SQL Server Management Studio and SSIS.
No .Net or web service skills required, just a basic knowledge of the CRM.
Can be used with multiple CRM Servers and multiple CRM organisations.
Simple installation and profile wizard
Generate stored procedures for specific entities to update one or more attributes

Benefits:

Simple and efficient method of manipulating data in Microsoft CRM
Utilise the existing skillsets in your organization - no need to retrain or rely on specific skillsets in your team.
Deliver results quicker - developers have less of a learning curve.
Safe and fully supported method of manipulating data in MS CRM without breaking data integrity
Can be used with multiple CRM servers and multiple CRM organisations.

How does it work?

The CRM CLR .Net Stored Procecdures are deployed to a seperate SQL Server database to the CRM Dynamics database. Typically this database is the staging or landing database that contains the logic to identify if there are any inserts or updates in CRM. The CLR stored procedures do not connect to the CRM directly - instead all communication is done through the CRM web services.

How CRM CLR .Net Stored Procedures integrate with Dynamics CRM

More information:

Click here to view the comprehensive FAQ

Click here to view an example of a stored procedure that was generated using the generation wizard specifically for to insert a few attributes for a contact entity.

Click here to download a 30 day trial copy

Click here to view screenshots of the application

For more information please contact us at crmclr@fusionsoftware.com