Commerce Server 2007 Data Warehouse Analytics Physical Schema

posted by  hjwin (10)  12 months ago (blogs.msdn.com)

I get this question fairly often: "Can you provide us with Commerce Server 2007 physical & logical schema?"

I ask "What is the scenario/need you are trying to address?" and invariably I get something to the effect of "So we can manipulate the data directly for various purposes"

For backup purposes (i.e. IT Admin Operations) we provide a list of databases and tables the systems use. However, we do not provide details beyond that.

The reason is we do not support direct data manipulation of the databases/tables. I have had the personal opportunity to interact with a cu