Prodiance Link Migration Manager:
Automating the Migration of Linked Spreadsheets into SharePoint
The adoption of Microsoft Office SharePoint Server 2007 and SharePoint Services has been growing leaps and bounds within the enterprise. In early 2008 Bill Gates announced that over 100 million licenses had been sold with over $1 billion in annual sales. With a rich set of features and capabilities spanning collaboration, document and records management, search, workflow management, and business intelligence, SharePoint is enabling companies to solve some of their most pressing information management needs while providing a cost effective and future proof alternative to traditional ECM systems.
SharePoint Migration Challenges With such rapid growth, SharePoint is transforming corporate IT infrastructures from simple file share environments into intelligent, metadata-driven web based architectures. Migration of many information assets - PDF files, presentations, Word documents, web pages, and images from corporate file shares into SharePoint is straight forward and built-in to SharePoint. However, complex, linked spreadsheets pose a unique and significant challenge because of their ability to link to other spreadsheets and data sources.
When migrating linked spreadsheets from corporate file share locations into SharePoint, several undesirable things are likely to happen, including broken links, data that is outdated or out of synch, and many frustrated users.
Prodiance Link Migration Manager When migrating linked spreadsheets from corporate file share locations into SharePoint, several undesirable things are likely to happen, including broken links, data that is outdated or out of synch, and many frustrated users.
Prodiance Link Migration Manager incorporates the following key features:
- Controlled and audited migration of spreadsheets
- Flexible migration options to meet a variety of disposition, retention and folder hierarchy requirements
- Simulation of migration prior to production
- Self-healing of links (post migration)
- Migration status and reporting
Controlled & Automated SharePoint Migration With Prodiance Link Migration Manager, any group of spreadsheets (or individual spreadsheets) can be migrated from a file share (or multiple file shares) to a new file share location(s) or SharePoint document library. There are several flexible configuration options supporting disposition of the original files (e.g. keep original copies, migrate, or rename) and migration (e.g. move source files only, move source files and subfolder files to new destination, or move to new destination and maintain current folder hierarchy). A simulation feature allows files and migration settings to be tested prior to migration.
Self-healing of Links During the migration process, Prodiance Link Migration Manager maintains a record of all spreadsheet links for (post migration) self-healing. Links for migrated spreadsheets are automatically updated the first time a user opens a spreadsheet from its new location in SharePoint, ensuring the seamless flow of data and automated link management.
Proven Return on Investment By leveraging Prodiance Link Migration Manager, organizations deploying SharePoint can protect valuable data while saving hundreds of man hours vs. manually re-establishing spreadsheet links or facing adoption issues. The savings are so significant the software often pays for itself within the first migration project!
Prodiance Link Migration Manager provides peace of mind during the migration process to ensure your organization’s critical spreadsheets are moved to secure repository where they can be managed with the highest level of security and integrity.
Ready to Take the Next Step? For more information on Prodiance Link Migration Manager and the Prodiance Enterprise Spreadsheet Manager system or to schedule a personalized demonstration, contact your Prodiance representative or visit us online today!