The other issue with Assentor is that they do not allow anyone to look at the design of their database. There is no way to run custom queries directly on it. At least that was the case a few years ago.
WorldTalk on the other hand let us play with the DB and write customer queries and stored procedures. We knew exactly what each table and query and stored procedure was. We were able to go and fix something in the DB if it was not working right or did not address OUR needs correctly. Maybe that was the case because they were using us as their testing grounds :) But we contributed a lot to their design and both benefited from it. -----Original Message----- From: Tony Hlabse [mailto:[EMAIL PROTECTED]] Sent: Friday, October 11, 2002 9:54 AM To: Exchange Discussions Subject: Re: advice for archiving email into a DB from a gateway server One thing about Assentor that I do remember, the company I was working for had a major hardware failure. That was before I got there. At the time there was no easy way to backup the Assentor database from what I was told. It was a nightmare because as the person responsible for it had to rebuild all the manager accounts and stuff. Ended up one person having to approve all messages until the accounts were set back up. Nothing like coming in the morning and seeing hundreds if not thousands of messages in queue waiting to be released. Ugh. ----- Original Message ----- From: "Andrey Fyodorov" <[EMAIL PROTECTED]> To: "Exchange Discussions" <[EMAIL PROTECTED]> Sent: Friday, October 11, 2002 8:43 AM Subject: RE: advice for archiving email into a DB from a gateway server Assentor is based on SQL. All messages are indexed into a SQL database as they are written onto a magneto-optical drive. We at Credit Suisse evaluated Assentor and had some issues with it. But that was 3-4 years ago. Instead we chose WorldTalk WorldSecure Server with the SEC Content Scanning and Archiving component. WorldTalk has since been acquired by TumbleWeed, but I think they still make that archiving product, albeit under a different name. Check http://www.tumbleweed.com That software has its own multithreaded SMTP gateway. You can define various policies. The policy wizard looks very similar to Rules Wizard interface. You can check all messages for various conditions and define the message disposition rules (pass, quarantine, archive, forward a copy, etc). You can archive all messages unconditionally. It also scans for words and phrases, with weight associated with each word or phrase. You could define various dictionnaries for content scanning (insider trading, porn, etc) When messages are archived, they are zipped up and written onto into a SQL database *in their entirety* AND also are written onto a magneto-optical drive in a jukebox. The messages are also indexed in the SQL database. After a predefined age, the message bodies are purged from SQL database (but remain on the jukebox platters). The SQL indexes contain such info as the common message fields, whether the body is still in SQL or already aged, what jukebox platter the message is on and what zip file it is in. Also the indexes contain the info about the policy that got the message archived (general or porn or insider trading) For message review, they have a web-based interface. It reads the SQL indexes and retrieved messages based on search criteria. When message is opened for reading, there are indicators that highlight suspect words (porn, insider trading, etc) so that a reviewer can easily determine if message has any bad content. -----Original Message----- From: Tony Hlabse [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 10, 2002 9:42 PM To: Exchange Discussions Subject: Re: advice for archiving email into a DB from a gateway server You also might want to look at www.assentor.com I used it once for a financial firm. I think all/most SEC type must use a type like this. That was 2 years ago but remember that they said they can port out to a database. Might worth a call. ----- Original Message ----- From: "Ed Crowley" <[EMAIL PROTECTED]> To: "Exchange Discussions" <[EMAIL PROTECTED]> Sent: Thursday, October 10, 2002 4:15 PM Subject: RE: advice for archiving email into a DB from a gateway server KVS Enterprise Vault (http://www.kvsinc.com/) is arguably the leader in this field. I don't know that they write to SQL, though, but their product has indexing and searching capabilities. Ed Crowley MCSE+I MVP Technical Consultant hp Services "There are seldom good technological solutions to behavioral problems." -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Frédéric Médery Sent: Tuesday, October 08, 2002 6:54 AM To: Exchange Discussions Subject: advice for archiving email into a DB from a gateway server Hello everybody, I'm using the "archive all email" feature from exchange 2000. My client wants more :-) do you have any advice for a gateway product that can archive all email inside a database (SQL) ? There're gonna be a lot of traffic so we need a very robust product. Thanks for your advice, -- Best regards, Frédéric mailto:[EMAIL PROTECTED] _________________________________________________________________ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin: [EMAIL PROTECTED] _________________________________________________________________ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin: [EMAIL PROTECTED] _________________________________________________________________ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin: [EMAIL PROTECTED] _________________________________________________________________ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin: [EMAIL PROTECTED] _________________________________________________________________ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin: [EMAIL PROTECTED] _________________________________________________________________ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin: [EMAIL PROTECTED]