Who Builds the Image Warehouse

In my last post, I explained in detail what an Image Warehouse is. I have repeated my definition here as a starting point.



"An Image Warehouse is a central repository of scanned image files that are support for transactional data, process data and organizational data. The warehouse supports the collection of files, storage of files and retrieval of files in an organized and structured way - much like a physical warehouse. It is all about tying data to image files."



Who builds this warehouse? Of course, at Millennia Group we think we are very good at it since we have been doing it for 13+ years. The key is getting someone to understand your data sources and data needs. Then that knowledge and information can be used to build or integrate the document repository with the underlying and supporting data or integrating the images with other applications - ETL layer (Exchange, Translate and Load).

When determining if you are going to do this in-house or use a third party, make sure everyone has a chance to get sample data exports from all applications that will be involved. One of the most complicated parts of the process is normalizing the data that is coming from different sources that maybe is not consistent. For instance, in the accounting application your job code starts with two zero's ("00") followed by 5 digit numeric code. Unfortunately, your reporting or job tracking database drops the zeros or uses the Job name instead of the code. A process must be devised to ensure that the warehouse always communicates with the other applications in a perfectly matched environment, ensuring data integrity.

If you are going to use an existing document management application to act as the storage and retrieval portion of your warehouse, you have to consider whether you have the in-house programming skills to make the necessary changes in that application or if you need to use a consultant. In addition, make sure the application has the flexibility to support the various different input requirements and data delivery requirements. For instance, not all document management applications come with barcode reading capability or PDF + Text conversion out of the box. Or maybe the application doesn't have web capabilities and you need the information to be easily accesible to users outside your firewall. If you have an existing document management system that is working for the most part but does not provide some of these features, Millennia Group can create a web based warehouse that will pull the image files from the EDM and the data from other sources and create a single unified input, viewing and distribution application.

Regardless of who builds your Image Warehouse, there will be a requirement for internal resources. Internal resources like the database manager, EDM manager and others will need to provide support in this process in order to pull all the pieces together.

So to summarize, to build your warehouse you will need internal resources, possibly outside application specific consulants and also possibly a data and process consultant like Millennia Group. Once you have the Image Warehouse built and users can search and find information that they struggled to pull together in the past, then everyone will forget who built it, they will just be glad it Was built.

Please visit us at www.mgdocs.com