By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
SmartData Collective
  • Analytics
    AnalyticsShow More
    predictive analytics in dropshipping
    Predictive Analytics Helps New Dropshipping Businesses Thrive
    12 Min Read
    data-driven approach in healthcare
    The Importance of Data-Driven Approaches to Improving Healthcare in Rural Areas
    6 Min Read
    analytics for tax compliance
    Analytics Changes the Calculus of Business Tax Compliance
    8 Min Read
    big data analytics in gaming
    The Role of Big Data Analytics in Gaming
    10 Min Read
    analyst,women,looking,at,kpi,data,on,computer,screen
    Promising Benefits of Predictive Analytics in Asset Management
    11 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-23 SmartData Collective. All Rights Reserved.
Reading: Data Transfer From Legacy to the Cloud
Share
Notification Show More
Latest News
ai software development
Key Strategies to Develop AI Software Cost-Effectively
Artificial Intelligence
ai in omnichannel marketing
AI is Driving Huge Changes in Omnichannel Marketing
Artificial Intelligence
ai for small business tax planning
Maximize Tax Deductions as a Business Owner with AI
Artificial Intelligence
ai in marketing with 3D rendering
Marketers Use AI to Take Advantage of 3D Rendering
Artificial Intelligence
How Big Data Is Transforming the Maritime Industry
How Big Data Is Transforming the Maritime Industry
Big Data
Aa
SmartData Collective
Aa
Search
  • About
  • Help
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
SmartData Collective > IT > Cloud Computing > Data Transfer From Legacy to the Cloud
Cloud ComputingSecurity

Data Transfer From Legacy to the Cloud

EphraimCohen
Last updated: 2012/11/20 at 10:53 AM
EphraimCohen
5 Min Read
SHARE

The transformation to the cloud is taking everything – and everyone — by storm. In spite of the earlier security issues and ever-present power-on power-off, surprises, the economies-to-scale are so low that it is almost guaranteed to be around for quite a while.

Contents
The Cloud has an Achilles HeelOnce a Database, Always a DatabaseRebuilding Your Data Integrity

The transformation to the cloud is taking everything – and everyone — by storm. In spite of the earlier security issues and ever-present power-on power-off, surprises, the economies-to-scale are so low that it is almost guaranteed to be around for quite a while.

The Cloud has an Achilles Heel

Some believe there are still some bastions that are holding onto the past, mostly due to their inherent characteristics. But if it is their inherent characteristic, then they are not holding onto the past and the same characteristics have been transferred into the present. An ERP system, whether cloud, in-house, or on-premise is still a relational database. There are some that promising changes happening with unstructured data, such as OpenText, but for now however, the majority of systems are still using relational databases. Remember, what has been changed is only the system. You have only performed a system transformation to the cloud — data management is not part of this transformation.

Once a Database, Always a Database

Unless the end-users have been thoroughly educated to the details of how data is stored, updated, deleted, as well as how to perform regular audits in relational databases then there are going to be problems. Most likely, whatever data challenges were experienced with the old database had little to do with how the system operated but more with how it was entered. Hopefully, you had someone very knowledgeable with not only data management but had been familiar with your business and business processes also.

More Read

cloud data security in 2023

Top Tools for Your Cloud Data Security Stack in 2023

Combat AI-Powered Threats with Cybersecurity Simulations & Other Practices
A Guide to Using XDR Threat Protection to Stop Data Breaches
Businesses Must Cope with the Benefits and Risks of Cloud Computing
Anti-Spoofing is Crucial for Data-Driven Businesses

Such a trained eye would pick up more problems than someone who knows the system very well and has absolutely no idea if some of your data is sitting in the wrong field in either your legacy system and/or on the data maps to be used for the implementation. In the end, all you are doing is transferring the problem from one system to another — and probably blaming both systems as well.

Rebuilding Your Data Integrity

With the advent of everything becoming easier, and faster, it escalates the need to be sure your data is being entered and maintained correctly. So what do you need to do?

Before the data mapping even starts, print or capture every report – including the ad hoc reports generated within the past year (most of us save these things). Distribute these to the supervisors and/or department managers to note errors such as information that is missing, in the wrong place, or calculated incorrectly. And be sure to require a sign-off on these reports!

Needless to say, you will need to move the data from the old field to the correct field. Run the reports again, visually ascertain that everything has been corrected – then distribute the reports again, and again with a signature. Once the old system has had the database ‘cleansed’ then you can be sure that if there are any problems in the implementation, you can isolate it to the data mapping and not consider if the data integrity is questionable.

What has been your experience in data migration from the legacy system to the Cloud? In 10 words or less, please let us know what data management needs required your attention or what you discovered was a problem with your data integrity AFTER the data had been migrated.

EphraimCohen November 20, 2012
Share this Article
Facebook Twitter Pinterest LinkedIn
Share

Follow us on Facebook

Latest News

ai software development
Key Strategies to Develop AI Software Cost-Effectively
Artificial Intelligence
ai in omnichannel marketing
AI is Driving Huge Changes in Omnichannel Marketing
Artificial Intelligence
ai for small business tax planning
Maximize Tax Deductions as a Business Owner with AI
Artificial Intelligence
ai in marketing with 3D rendering
Marketers Use AI to Take Advantage of 3D Rendering
Artificial Intelligence

Stay Connected

1.2k Followers Like
33.7k Followers Follow
222 Followers Pin

You Might also Like

cloud data security in 2023
Cloud Computing

Top Tools for Your Cloud Data Security Stack in 2023

7 Min Read
cybersecurity simulations
Artificial IntelligenceExclusiveITSecurity

Combat AI-Powered Threats with Cybersecurity Simulations & Other Practices

7 Min Read
data breach issues
Security

A Guide to Using XDR Threat Protection to Stop Data Breaches

6 Min Read
cloud computing benefits and risks
Cloud Computing

Businesses Must Cope with the Benefits and Risks of Cloud Computing

9 Min Read

SmartData Collective is one of the largest & trusted community covering technical content about Big Data, BI, Cloud, Analytics, Artificial Intelligence, IoT & more.

ai is improving the safety of cars
From Bolts to Bots: How AI Is Fortifying the Automotive Industry
Artificial Intelligence
giveaway chatbots
How To Get An Award Winning Giveaway Bot
Big Data Chatbots Exclusive

Quick Link

  • About
  • Contact
  • Privacy
Follow US

© 2008-23 SmartData Collective. All Rights Reserved.

Removed from reading list

Undo
Go to mobile version
Welcome Back!

Sign in to your account

Lost your password?