As the market continues to consolidate and companies sell off assets, not only are the physical assets separated and sold, so are the digital assets – or liabilities. John Schmidt covered it in one of his recent blogs.
When the information to be separated and sold resides in a database, you need to understand the data model and determine what master data, or reference data, and transactions belong to the new company. In the case of separating master data this may involve understanding the relationships between multiple systems to make sure that when the data is moved into the new company, it maintains context, is accurate and complete. With transactional data, you need to know the tables and rows that comprise a complete transaction so that when data is moved, no orphaned rows are left behind.
When the data model is simple, this process can be fairly straight forward. If the system is complex, such as Oracle E-Business Suite or SAP, using a data separation product like Informatica’s Data Subset can speed the process and eliminate any risk of breaking master and transactional data relational integrity during the process.
In one project, we did the analysis and comparison of splitting a company’s data using a team of consultants versus using a packaged solution. It was impractical and nearly impossible to meet the deadline without having prebuilt templates for the master and transactional data available for use. Informatica’s Data Subset solution provides predefined templates for packaged applications that reduces the amount of time needed to set up the data separation tasks. Through the use of drop down boxes and wizards, the user can select the business organization and other criteria that would be used to select and separate the data. Additionally, the routines are prepackaged to move the data into a new system while deleting the data from the old. Logs and reports are available for auditing purposes to prove which data was moved, deleted and when. To do this job without an off-the-shelf solution, the time and cost would have been more than 300%.
We will continue to see mergers and acquisitions shape the market. Software solutions that are purpose built to create data subsets can significantly speed up and simplify the task of splitting those companies’ biggest asset – its data.
Julie Lockner, President & Founder, CentricInfo