Document Management and Integration with Business Applications

In the beginning, most of the Document Management and ECM solutions I sold were stand alone applications. Users would scan documents (say invoices) into the repository, and would use the search client to bring up documents by index field, or perhaps do a full-text search of the OCR'ed contents.

What I am finding today, as more and more IT folks get involved in the decision making process, is that integration is King. Applications must play well, and play easy with all other business applications within the organization. What does that mean? What does integration truly mean?

I have found that it means many things, to many different people. Below is a summary:

Basic Metadata Population
Wow, that is a mouthful. Basic Metadata Population, or BMP, involves the pulling of index field information from an existing source, and allowing the user to manually pick the information from a vendor field. The most common used case here is to present a popup list of information for the user to choose. Take for example, one of my customers that has PeopleSoft Financials. One of my engineers created a view within the PeopleSoft DB of all the vendors. When Purchasing is indexing their Purchase Orders, they see a listing of vendors directly from the financial system. This prevents rekeying of data that has already been keyed, prevents duplicate names or mispellings, and insures standardization.

Advanced Metadata Population
Another mouthful, but AMP takes population of index fields a step further, and provides autopopulation of fields based on a database lookup. For example, you might have a Vendor Number field that is entered, and the capture application will go and lookup all the information on that vendor and assign it to the document.

Screen Scraping
This technology is usually used to "scrape" information off the screen from an application, and use it to populate index fields, or to perform a search. Different functions can be tied to hotkeys, or some advanced applications can have a quicklaunch bar that will perform certain operations. For example, if you are in your financial software looking at a particular vendor, you can hit a hotkey and have all the documents for that particular vendor resented.

True Integration
True Integration requires application programming interfaces that will allow two applications to talk directly to each other. For instance, you can create a button in the tool bar of your financial application that will link to a function within your document management system, or ECM system. So with one quick click, you can find all the associated documents, or scan a document to a particular vendor file with all the fields populated.

Integrations always present some challenge, and it is important to make sure you are on the same page when talking to a customer or vendor to insure everyone is satisfied in the end.

For more info on Document Management and ECM, go to the following link:

ScanGuru Document Management/ECM Portal