has anyone build a client using bcm's backend?

  • Thread starter Thread starter James
  • Start date Start date
J

James

has anyone built a client using bcm's backend. is there any documentation? i
basicly just want to create accounts and contacts. anyone know off hand of
which stored procedures etc i need to run? any special keys that i need to
insert. i don't want to corupt the database :)
 
That's gotten trickier. V1 made extensive use of stored procs but it
appears that in v2 some of the logic has moved to the client. There's a
SQL Server tool that lets you capture all the traffic to the database
and from that output BCM doesn't appear to be simple to emulate. There
are several columns in the db that appear to be keys that are
referenced in other tables, plus additional columns that need to be
kept in sync; dates, parent references, items with the word MAPI in
them.

To get changes into the db, a better approach might be to have your
client generate BCM export files, and then have a bcm client import
them. Reading data from the database views appears to be fairly
straightforward compared to updating.
 
Back
Top