Where can I get a database layout for the BCM database?

[Guest]

Is Business Contact Manager documented? I would like to find a “database
layout†so I know which fields are already there and what causes them to be
updated on a field by field basis. Obviously some fields are updated by
user input, but others are triggered by some other event. Heck, I don’t even
know what fields exist at this point.

Maybe we don't need that kind of information. Your thought?

Ed

 

[Alex]

Ed,

i am looking for the same information. I am working in a way to identify the
ID of projects, because i have to show it and BCM do not show in forms.

You can create a Database Diagram using this tool on SQL Server Management
Studio. You will get a snapshot of all tables and fields and relations about
that.

You said about updating fields... well.. the BCM database is very strange...
many data are updated by a sequence of triggers.. and some critical data,
such as name of projects, for example, are encoded. You cannot read this
fields directly in SQL Server.

Maybe we can exchange informations about BCM database. I really need to find
a way to show, in Project Forms, the ID of the projects. I already
discovered many fields and the relations about them.

Alex

 

[cschneid4]

Is Business Contact Manager documented? I would like to find a "database
layout" so I know which fields are already there and what causes them to be
updated on a field by field basis. Obviously some fields are updated by
user input, but others are triggered by some other event. Heck, I don't even
know what fields exist at this point.

Maybe we don't need that kind of information. Your thought?

Ed

Ed,
Did you ever find any Business Contact Manager documentation? I'm
looking to build a couple custom reports but haven't had any luck
figuring out the database scheme. Thanks...

Craig

 

[Luther]

Ed,
Did you ever find any Business Contact Manager documentation? I'm
looking to build a couple custom reports but haven't had any luck
figuring out the database scheme. Thanks...

Craig

The BCM database is intentionally undocumented. The only available
documentation is for the Public Accounts and Contacts Views. Those are
there for other apps to have access to some of the contact fields.
However, there's been a fair amount of discussion of the database
tables here over the years.

I've been told there a bcm developer's newsgroup but I haven't been
able to find it publically--i.e. on Google Groups.

Most of the encoded binary fields contain Outlook data that BCM is
required to store by Outlook, but BCM doesn't use it apart from saving
those fields when Outlook asks it to and returning the data when
Outlook requests it.