• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
TSB Alfresco Cobrand White tagline

Technology Services Group

  • Home
  • Products
    • Alfresco Enterprise Viewer
    • OpenContent Search
    • OpenContent Case
    • OpenContent Forms
    • OpenMigrate
    • OpenContent Web Services
    • OpenCapture
    • OpenOverlay
  • Solutions
    • Alfresco Content Accelerator for Claims Management
      • Claims Demo Series
    • Alfresco Content Accelerator for Policy & Procedure Management
      • Compliance Demo Series
    • OpenContent Accounts Payable
    • OpenContent Contract Management
    • OpenContent Batch Records
    • OpenContent Government
    • OpenContent Corporate Forms
    • OpenContent Construction Management
    • OpenContent Digital Archive
    • OpenContent Human Resources
    • OpenContent Patient Records
  • Platforms
    • Alfresco Consulting
      • Alfresco Case Study – Canadian Museum of Human Rights
      • Alfresco Case Study – New York Philharmonic
      • Alfresco Case Study – New York Property Insurance Underwriting Association
      • Alfresco Case Study – American Society for Clinical Pathology
      • Alfresco Case Study – American Association of Insurance Services
      • Alfresco Case Study – United Cerebral Palsy
    • HBase
    • DynamoDB
    • OpenText & Documentum Consulting
      • Upgrades – A Well Documented Approach
      • Life Science Solutions
        • Life Sciences Project Sampling
    • Veeva Consulting
    • Ephesoft
    • Workshare
  • Case Studies
    • White Papers
    • 11 Billion Document Migration
    • Learning Zone
    • Digital Asset Collection – Canadian Museum of Human Rights
    • Digital Archive and Retrieval – ASCP
    • Digital Archives – New York Philharmonic
    • Insurance Claim Processing – New York Property Insurance
    • Policy Forms Management with Machine Learning – AAIS
    • Liferay and Alfresco Portal – United Cerebral Palsy of Greater Chicago
  • About
    • Contact Us
  • Blog

DocFinity – Migrating to Amazon S3

You are here: Home / Alfresco / DocFinity – Migrating to Amazon S3

October 11, 2018

TSG is currently working with an insurance client migrating from DocFinity to the Amazon cloud.  This post will describe how TSG is assisting the client move to a more modern solution with Amazon Web Services and specifically Amazon S3 leveraging our OpenMigrate migration framework.

DocFinity Background and Architecture

Owned by Optical Image Technology, a name reminiscent of older scanning and imaging technology of the late 80’s and 90’s, DocFinity has evolved over the years but still has some basic old-school components.  Like most legacy ECM solutions, DocFinity has a two distinct components for their meta-data and content store.  The first component is for meta-data is where attributes, security and data about the document is stored.  Like FileNet or other old repositories, the DocFinity database only has one table where our client is currently storing the document with approximately 10 attributes.  (DocFinity provides for up to 20 attributes)

For example – Table optimg01 includes

  • user_key_1 – client is using this column for claim #
  • user _key_2 – client is using this column for policy #
  • ….
  • user_key_20
  • pg_id – unique id of the document
  • pg_pgtp_id – Page Type (ex PDF, TIF)

Clients would access the application data as part of searches to return a listing of documents to view. Our client had built a custom web application to search against the (add table) to retrieve the results to their claim management system.

The second component is the storage of the document itself.  Within the Application Data, DocFinity will store hash reference of the document id to give a pointer to the folder that stores the document itself.  The name of the document is the pg_id + any extension from the  pg_pgtp_id – (PDF, PNG…..)

From the client’s claim management system, if a user wanted to view a document, the system would query the database to return a list of documents that satisfied that query.  Our client did not rely on any viewer but instead would download the document from the file store if selected.

Replacing DocFinity with AWS

TSG has been moving customers from Legacy ECM systems for over 20 years.  Typical smaller migration involve moving both the application data and the object at the same time.  For large scale migrations particularly to the cloud (this client has over 15 million documents), TSG recommends a two step migration where the documents are moved and later linked to either the new ECM repository or other locations.

For the DocFinity migration, TSG relied on the database mapping portion of OpenMigrate.  We are currently retrieving the meta-data to store in Alfresco with the document storage being stored directly in S3.  Client is planning on using a combination of either Amazon Snowball and Amazon Direct Connect to move the content.

One interesting newer feature of Amazon S3 is the ability to store information about the object in an S3 bucket.  See the complete list of Amazon S3 features on the AWS website as well as specifics on Object Tagging (often called MetaData).   For may migrations, TSG advises clients to consider adding both content and meta-data in S3 for both redundancy as well as to allow for access to documents outside of the Alfresco ECM content store.

While the client will be replacing their existing custom integration from DocFinity to leverage a combination of OpenContent as well as the OpenContent Management Suite specifically tailored for Insurance Claim and Policy Case Management.

Summary

For DocFinity or other legacy ECM implementations, Amazon S3 offers basic object storage with attributes along with the benefits of modern document formats and viewers at a cost effective price in the cloud.  With an innovative approach, some clients may be able to move quickly with TSG’s OpenMigrate to Amazon cloud based storage and move away from an expensive and legacy on-premise DocFinity installation.

If you are interested in learning more about how to migrate from DocFinity, please contact us at https://tsgrp.wpengine.com/about/contact-us/.

Filed Under: Alfresco, Amazon, Cloud Computing, ECM Landscape, Migrations, OpenMigrate

Reader Interactions

Leave a Reply Cancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Search

Related Posts

  • Redaction for AWS, Alfresco, Documentum and Hadoop – Bulk Redaction upon Ingestion or Migration
  • Alfresco Solutions of the Year 2017 – TSG wins Alfresco award for sixth year in a row
  • ECM Roadmap – Thoughts on Planning for the Future
  • Third Annual TSG Client Briefing – June 3rd – 2010
  • Claims Documentation – Modernizing Insurance Platforms
  • ImageWare from Cannon – Migration to Alfresco in the Cloud
  • Alfresco DevCon Wrap Up
  • Alfresco Consulting – Documentum Disruptor #2
  • Alfresco – Do More with OpenMigrate Services
  • FileNet AWS Cloud Native? Thoughts on recent announcement

Recent Posts

  • Alfresco Content Accelerator and Alfresco Enterprise Viewer – Improving User Collaboration Efficiency
  • Alfresco Content Accelerator – Document Notification Distribution Lists
  • Alfresco Webinar – Productivity Anywhere: How modern claim and policy document processing can help the new work-from-home normal succeed
  • Alfresco – Viewing Annotations on Versions
  • Alfresco Content Accelerator – Collaboration Enhancements
stacks-of-paper

11 BILLION DOCUMENT
BENCHMARK
OVERVIEW

Learn how TSG was able to leverage DynamoDB, S3, ElasticSearch & AWS to successfully migrate 11 Billion documents.

Download White Paper

Footer

Search

Contact

22 West Washington St
5th Floor
Chicago, IL 60602

inquiry@tsgrp.com

312.372.7777

Copyright © 2023 · Technology Services Group, Inc. · Log in

This website uses cookies to improve your experience. Please accept this site's cookies, but you can opt-out if you wish. Privacy Policy ACCEPT | Cookie settings
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT