Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
henrikop
Constraint Violating Yak Guru
280 Posts |
 Posted - 2007-03-17 : 04:32:52
|
| Some questions:Do you think there's a generic datamodel possible for CRM? If not do you think there's a generic datamodel possible for CRM for business to business?I'm searching for some example CRM datamodels, prefferably ones that already proved their wordth. I have made a generic application for HRM and I want to add CRM to the solution. Some things I come across are these:I have organisations and contact persons. A contact person can be a relation to one or more organisations with relation types.One of the issues is that if you link contactmoments to contact persons and the contact person is no longer a relation to an organisation then I "lose" the contacts I had with that organisation. Or when User A has right to organisation X and their contact persons have links to organisation Y, then when I look at organisation Y, I don't want to see the contactmoments made with organisation X. (A contactmoment should have a link to ContactPerson and Organisation). But I have some other issues as well. Why put a lot of time in inventing the wheel?I want to develop a CRM which holds leads, but also customers and suppliers.Thx for your time!Henri~~~~There's no place like 127.0.0.1 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-03-17 : 10:25:12
|
| take a look here:http://www.databaseanswers.org/data_models/you might find something that's usefull for your problem.in crm there's only a core that can be modelled as general.because every crm has different business requirements the model usually changes with them.also take a look at MS CRM 3.0 it's pretty close to a generic as you'll get._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
henrikop
Constraint Violating Yak Guru
280 Posts |
Posted - 2007-03-17 : 10:50:09
|
| Thx,databaseanswers can be a nice starter, but did not ever give me something useful. I can make zillion models like that.I will look deeper into MS CRM 3.0 . I've worked with older versions and that was really a waste of time.If anyone came accros a nice model or good CRM resources, or white papers or datamodels, please!Henri~~~~There's no place like 127.0.0.1 |
|
|
|
|
|
|
CRM Datamodel