Saul Ewing’s iManage Cloud Database Consolidation a Successful Industry First

[fusion_builder_container hundred_percent=”no” equal_height_columns=”no” menu_anchor=”” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” class=”” id=”” background_color=”” background_image=”” background_position=”center center” background_repeat=”no-repeat” fade=”no” background_parallax=”none” parallax_speed=”0.3″ video_mp4=”” video_webm=”” video_ogv=”” video_url=”” video_aspect_ratio=”16:9″ video_loop=”yes” video_mute=”yes” overlay_color=”” video_preview_image=”” border_size=”” border_color=”” border_style=”solid” padding_top=”” padding_bottom=”” padding_left=”” padding_right=””][fusion_builder_row][fusion_builder_column type=”2_3″ layout=”2_3″ spacing=”” center_content=”no” link=”” target=”_self” min_height=”” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” class=”” id=”” background_color=”” background_image=”” background_image_id=”” background_position=”left top” background_repeat=”no-repeat” hover_type=”none” border_size=”0″ border_color=”” border_style=”solid” border_position=”all” border_radius=”” box_shadow=”no” dimension_box_shadow=”” box_shadow_blur=”0″ box_shadow_spread=”0″ box_shadow_color=”” box_shadow_style=”” padding_top=”” padding_right=”” padding_bottom=”” padding_left=”” margin_top=”” margin_bottom=”” animation_type=”” animation_direction=”left” animation_speed=”0.3″ animation_offset=”” last=”no”][fusion_text columns=”” column_min_width=”” column_spacing=”” rule_style=”default” rule_size=”” rule_color=”” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” class=”” id=””]

Saul Ewing Arnstein & Lehr LLP is a full-service law firm that offers clients the national reach and sophisticated experience of a large firm and the local connections and value of a boutique firm. This combination of reach and local autonomy supports our clients with the clout of a megafirm and the service hallmarks of a boutique. With one firm, our clients get a macro view of the law with a micro focus on their unique legal needs. With 16 offices in Delaware, the District of Columbia, Florida, Illinois, Maryland, Massachusetts, Minnesota, New Jersey, New York and Pennsylvania, Saul Ewing Arnstein & Lehr serves businesses throughout the United States and internationally. We represent recognizable names in corporate America, exciting start-ups and an array of closely held and privately held companies, as well as nonprofits, governmental and educational entities.

Challenges

With a client-centric commitment to excellence in mind, Saul Ewing LLP merged with Arnstein & Lehr LLP in September of 2017, providing their clients with expanded capabilities and greater depth in key practice areas. The merger happened to take place in the middle of Saul Ewing’s DMS deployment to the iManage Cloud. For efficiency and productivity’s sake, Saul Ewing Arnstein & Lehr LLP (Saul Ewing) found they needed to consolidate all of their databases into one primary database. As a trusted integrated service provider, Cornerstone Information Technologies, LLC had been assisting with the project. Due to the timing of the merger, Arnstein & Lehr LLP databases were wholesale lifted directly to the iManage Cloud as is, causing the need for the consolidation to take place within the cloud environment. This presented significant challenges, as cloud environments require API access. There is no access to SQL or SQL tools. A database consolidation within the cloud had never been done before. Additionally, the firm requested no down time for its users during the project in order to maintain productivity.

Solutions

Lisa Stone, Client Systems Architect, and Suzanna Wilson, Systems Integrator, were tasked with finding a way to make this all possible. Lisa contacted SeeUnity to ask if the Velocity Content Migration product (Velocity) was capable of performing this type of migration within the cloud. SeeUnity verified the possibility but had never done one before. This would be a first.

“We’ve been doing integrations API to API for years, so we are in a good position to handle these migrations. Because our products are API-based, our processes have always been through the API versus the database level whenever possible,” said Dan Hunsinger, CTO, SeeUnity.

Under Lisa Stone’s leadership, and working closely with SeeUnity, the team worked to develop a plan to tackle the complex migration. The project entailed merging four databases and over eight million documents into one efficiently organized and user friendly primary database. “We crunched some numbers and figured out that we could bring over the last 350,000 documents recently edited by the users over a single weekend without shutting the system down. This would move the bulk of the current documents to the firm’s primary database,” explained Lisa Stone, Client Systems Architect. Velocity’s migration process includes validating the source system data in preparation for the move. During this discovery stage, it was clear that the source databases needed clean-up. In addition, data transformation would be necessary to merge documents of the same type with different classifications, combine client matter numbers that didn’t correspond with each other, and make other adjustments to create a cohesive database. Using delta syncs, over 358,000 documents were merged to the new database over a weekend without shutting down the system for users. The old main database was then made read-only so that all documents could only be saved to the new database. The rest of the documents were transferred during regular business hours over the next few days.

Benefits

This ground breaking project took a tremendous amount of innovation. With collaboration from the client, the iManage team, and SeeUnity, Lisa and Suzanna were able to accomplish a new content migration first, paving the path for future cloud consolidations. Lessons learned will contribute to best practices for the next migrations. By utilizing SeeUnity’s Velocity product with its deep set of features and tools, a consolidation of cloud-based databases was possible. Data validation and transformation ensured that the new environment was ready to go for users and did not need further configuration or clean-up. The impact to user productivity was minimal and information governance was maintained with the delta syncs. “This was an exciting first for everyone. It wasn’t easy, and it wasn’t flawless, but we figured things out along the way, and the client is satisfied. We were able to accomplish a successful cloud consolidation by utilizing the Velocity tool’s API to API capabilities. With lessons learned, we’ve paved the way for future cloud consolidations.” – Suzanna Wilson, Systems Integrator

[/fusion_text][/fusion_builder_column][fusion_builder_column type=”1_3″ layout=”1_3″ spacing=”” center_content=”no” link=”” target=”_self” min_height=”” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” class=”” id=”” background_color=”” background_image=”” background_image_id=”” background_position=”left top” background_repeat=”no-repeat” hover_type=”none” border_size=”0″ border_color=”” border_style=”solid” border_position=”all” border_radius=”” box_shadow=”no” dimension_box_shadow=”” box_shadow_blur=”0″ box_shadow_spread=”0″ box_shadow_color=”” box_shadow_style=”” padding_top=”” padding_right=”” padding_bottom=”” padding_left=”” margin_top=”” margin_bottom=”” animation_type=”” animation_direction=”left” animation_speed=”0.3″ animation_offset=”” last=”no”][fusion_text columns=”” column_min_width=”” column_spacing=”” rule_style=”default” rule_size=”” rule_color=”” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” class=”” id=””]

Industry
Legal

About the Project

Challenges

Cornerstone-Logo-No-Branded-Line

“Integrating systems in M&A situations can be quite complex and slow down productivity during the transition. Because this process required no down time, our users were able remain productive. Data transformation during the consolidation delivered an environment that was ready to go, allowing users to quickly come together to function efficiently as one unified organization.” – Leonard Oliveri, Director of Information Systems, Saul Ewing

iManage logo

iManage is the leading provider of work product management solutions for legal, accounting and financial services firms and the corporate departments they serve worldwide. Every day, iManage helps professionals streamline the creation, sharing, governance and security of their work product.

Solution Velocity Content Migration

Benefits

[/fusion_text][/fusion_builder_column][/fusion_builder_row][/fusion_builder_container][fusion_builder_container hundred_percent=”no” hundred_percent_height=”no” hundred_percent_height_scroll=”no” hundred_percent_height_center_content=”yes” equal_height_columns=”no” menu_anchor=”” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” status=”published” publish_date=”” class=”” id=”” background_color=”” background_image=”” background_position=”center center” background_repeat=”no-repeat” fade=”no” background_parallax=”none” enable_mobile=”no” parallax_speed=”0.3″ video_mp4=”” video_webm=”” video_ogv=”” video_url=”” video_aspect_ratio=”16:9″ video_loop=”yes” video_mute=”yes” video_preview_image=”” border_size=”” border_color=”” border_style=”solid” margin_top=”” margin_bottom=”” padding_top=”” padding_right=”” padding_bottom=”” padding_left=””][fusion_builder_row][fusion_builder_column type=”1_1″ layout=”1_1″ spacing=”” center_content=”no” link=”” target=”_self” min_height=”” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” class=”” id=”” background_color=”” background_image=”” background_image_id=”” background_position=”left top” background_repeat=”no-repeat” hover_type=”none” border_size=”0″ border_color=”” border_style=”solid” border_position=”all” border_radius=”” box_shadow=”no” dimension_box_shadow=”” box_shadow_blur=”0″ box_shadow_spread=”0″ box_shadow_color=”” box_shadow_style=”” padding_top=”” padding_right=”” padding_bottom=”” padding_left=”” margin_top=”” margin_bottom=”” animation_type=”” animation_direction=”left” animation_speed=”0.3″ animation_offset=”” last=”no”][fusion_text columns=”” column_min_width=”” column_spacing=”” rule_style=”default” rule_size=”” rule_color=”” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” class=”” id=””]

We are content integration experts providing in-depth solutions to connect, sync, or migrate data across on-premise or cloud-based ECM solutions with external business applications. We’re dedicated to improving workflow and business processes by extending applications and connecting people with content. SeeUnity supports a growing list of 20 connectors and provides comprehensive migration and synchronization tools to 500+ customers and 30+ partners worldwide. We proudly serve customers of all sizes, including Fortune 500 businesses, Am Law 100 and 200 firms, and government entities.
sales@seeunity.com | +1 970.776.8300 | www.seeunity.com 

© Copyright 2019 SeeUnity, Inc. | All rights reserved

May 2019

[/fusion_text][/fusion_builder_column][/fusion_builder_row][/fusion_builder_container]

Cornerstone.IT