I assume that one can store an MS Word document as a LOB (BLOB? CLOB?). But how do you get it back out? If we use Teradata to store MS Word documents, what sort of application would we need to deploy to allow users to easily retrieve and view these documents? SQL Assistant wouldn't cut it for our user base.
We haven't actually started loading documents into Teradata; I had just read a white paper from Teradata which talked about LOB's which implied that a Word document is one of the types of files that can be stored in this datatype.
What about MS Access? Can it present a LOB? SQL Assistant is NOT an option for the user base I have in mind.
Currently, support for importing or exporting LOB data via the client utilities is very limited. The best-supported interfaces are the ODBC and JDBC APIs. I am not knowledgeable about MS Access, but I do know that it is an ODBC client, so if it does have LOB support it should work with Teradata.