What are DynaProcs?
Fusion DynaProcs provide a simple method to import and manipulate data in
Microsoft Dynamics CRM 4.0. The product is designed to migrate data from existing
data sources into Dynamics CRM, or to manipulate Dynamics CRM data on an ongoing
basis.
Who uses DynaProcs?
DynaProcs are used by developers, DBA's and technical personnel with good SQL
skills.
How are they used?
The DynaProcs are a set of .Net CLR Stored Procedures that can
be used like any other stored procedures from within SQL Server Management Studio
or SSIS. Unlike regular stored procedures, they call the Microsoft Dynamics CRM
web services and so ensure data integrity is maintained.
Features:
-
Create, read, update, delete, set state, change ownership, and create many-to-many
relations regarding any entity in CRM including custom entities.
-
Can be used in SQL Server Management Studio and SSIS.
-
No .Net or web service skills required, just a basic knowledge of the CRM and T-SQL.
-
Wizard generates stored procedures for specific entities
Benefits:
-
Utilize the existing skill sets in your organization - no need to re-train
-
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.
|