Wednesday, January 30, 2008

11 Million Records Integrated HOORAY

We just did a partial but still significant data load for a client. About a million accounts, two million contacts, and about eight million custom objects (spread across three types). About 36 hours into sandbox.

Yes, that explains my lack of posts. It's been a busy couple of weeks.

Anyway, here's the question: why are we moving all this data? Is it worth the effort? Couldn't we just use some kind of mash up?

Short version: yes it was worth it and no we couldn't use a mashup. The move allows the users to see the data in a new, more meaningful way. And by using the master-detail relationships combined with some roll up summary and formula fields, users can now do their own searches for prospects, etc. (I was going to say data mining, but that's too much hype.)

The process wasn't completely perfect or stress free, but, at the risk of sounding more fan boy than curmudgeon, I LOVE IT WHEN THIS SHIT WORKS!!!!!

No comments: