Tables of BCM

[Heinz-Dieter Janzen]

Hello,

A client of mine wants to have a summarized view of data of BCM users.

A SBS server with a central SQL database will be used.

I managed to link an access mdb to a BCM Database and found more than 100
tables. Does there any documentation exist about these tables?

Thanks and Regards
Dieter

 

[Luther]

Hello,

A client of mine wants to have a summarized view of data of BCM users.

A SBS server with a central SQL database will be used.

I managed to link an access mdb to a BCM Database and found more than 100
tables. Does there any documentation exist about these tables?

Thanks and Regards
Dieter

I'm not aware of any official docs on the database schema. There are
software tools that will automatically map out the relationships
between the tables in a relational database.

I would suggest using the sql views which join multiple tables (e.g.
OpportunityFullView), instead of the tables directly.