Data Manipulation Framework

Description

Data Manipulation Framework strengthens the benefits of Dynamics CRM with the ability to automate repetitive data intensive and complex data manipulation. With Data Manipulation Framework you can configure calculation expressions that determine the value of entity attributes in Dynamics CRM. The expressions allow the use of other Dynamics CRM attributes or even external database fields as expression variables. The calculation expressions can be triggered in every layer of Dynamics CRM being : adhoc, time scheduled, workflow, on every form event and in plugins. Data Manipulation Framework offers consistent data manipulation throughout Dynamics CRM without the complexity of Javascript or .NET coding and with the advantage of build in scheduling, monitoring, testing/debugging, versioning and redeployment. Data Manipulation Framework offers expression building for three expertise and complexity levels, being Form based; Excel formulas or Transact SQL. The possibilities are endless:

Customer segmentation and customer value calculations
Relation-roles
Task driven customer management
Service planning
Marketing Automation
Customer reports
Performance Management
One to one marketing
Event Driven marketing
International address lines
Business rules
Service Level management and contract management

Basically everything that needs calculation or a business rule can now be configured. This will reduce .NET programming in Dynamics CRM for more than 50%. Data Manipulation Framework turns Dynamics CRM into an intelligent flexible business application and lowers the total cost of ownership.

Features

Data Manipulation Framework offers the following features:

The abilibty to calculate attributes of the following datatypes:

Integer like how many orders did this customer do in this year
Float like what's the average score this customer gives us in the enquiry
Decimal like how many hours did our engineer spend doing the service activity
Money like how much do we need to invoice on this case
Datetime like what's the exact due date of this case related to the type of contract
NVarchar like what's the full name including titles based on the prefix, firstname, middle name, last name and suffix.
Boolean like is this a returning customer
Picklist like is this a regular or a big customer
Lookup like what is the most recent complaint of this customer

The ability to perform the following types of relational calculation:

Currenty entity calculation like profit is turnover minus cost on the order.
Aggregated calculation with downstream 1:N or N:N entities like customer value is the sum of all order amounts belonging to that customer.
Upstream entity calculation like a copy of the phone number on every open opportunity belonging to a customer when the phone number changes.
Calculations with entities without relation or more than one level removed from the target entity like global settings
Calculations with unairy relationships like parent account
Calculations with special system one to any relationships like regarding, resources or customer.

The ability to filter:

Filter the destination attribute on returning customer only for example
Filter the source of an aggregation on only orders made in the current year

The ability to perform calculations on the following events:

Manual to set some default values of new attributes for example
In scheduled batches to calculate values things like age or customer value over night
In workflow to refresh the values like number of leads after import
In workflow combined with entity context like calculate the case invoice amount on closure of a new service activity
On form, for example to enforce the formatting of phone numbers and zip codes.
In your custom plugin using our SDK, to enforce consistent automatic data manipulation, validation or formatting independant of the imput channel (form, import wizard or web service)

The ability to check your calculations:

A test result window with the options to preview total result or only changes
A sql preview windows that support the configuration of advanced calculations
Logging
Schedules
Disablement of calculation for scheduling upon error

The ability to re-use your calculation configurations:

An export option for one, some or all configured calculations
An import option for one, some or all configured calculations
A copy calculation option to re-use common calculations

Documents

Documents for Data Manipulation Framework Version 4.0

Adobe Acrobat PDF	Microsoft Office XPS
Installation & Operations Guide (1.10 MB)	Installation & Operations Guide (1.22 MB)
Basic User Guide (1.80 MB)	Basic User Guide (2.30 MB)
Advanced User Guide (1.81 MB)	Advanced User Guide (2.34 MB)

Data Manipulation Framework SDK: Download (1.41MB).

Documents for Data Manipulation Framework Version 2011

Adobe Acrobat PDF	Microsoft Office XPS
Installation & Operations Guide (1.30 MB)
Basic User Guide (2.30 MB)	Basic User Guide (3.10 MB)

Pricing

Wavextend Data Manipulation Framework

The pricing of the Wavextend Data Manipulation Framework. All Prices are excluding tax.

		Subscription	Buy	Yearly Support fee
User License	Server license	€ 703,50	€ 2.000,00	€ 200,00
	Per user	€ 34,65	€ 99,00	€ 9,90
Or Organization	Per organization	€ 14.563,50	€ 41.160,00	€ 3.861,00

Suite

When buying both the Wavextend Data Manipulation Framework and Wavextend Listmanager in one Suite.

		Subscription	Buy	Yearly Support fee
User License	Server license	€ 1053,50	€ 3.000,00	€ 300,00
	Per user	€ 52,15	€ 149,00	€ 14,90
Or organization	Per organization	€ 20.338,50	€ 58.110,00	€ 3.861,00

To order the suite (includes List Manager) click here.

Number of users
Buy
Subscription per year