Use Case
Migrate Legacy Data
Migrate data from your legacy systems to your new system
Vision
Is it for me?
For the Business Owner or Senior Leader
Who needs to migrate data from a legacy system to a new system
The AgileData “Migrate Legacy Data” is a service
That enables you to incrementally migrate your data, with reduced cost and reduced risk
Unlike a big bang manual migration process or paying your new systems vendor to learn the structure and intricacy of your legacy system
AgileData “Migrate Legacy Data” will:
- Provide multiple trial migration runs, using an iterative approach;
- Easily map to multiple new system environments, such as build, QA, UAT, training and production;
- Profile your legacy data to identify potential data quality issues early;
- Enable you to define repeatable data validation and quality rules to ensure data is not lost or corrupted during migration;
- Provide an ongoing data store for historical reporting of legacy data;
- Have no additional on-boarding, technology or ongoing maintenance costs;
- Provide a fully managed fractional data as a service, for a fixed fee.
Common business problems
And how the Data migration service solves them
Large upfront technology costs
You have been quoted a large amount of money to buy a myriad of data tools, but you only need these capabilities for the period of the data migration.
Example Technology Capabilities Needed
- Acquiring data from your legacy systems;
- Profiling legacy system data;
- Loading data into new systems;
- Creating data validation rules to identify missing or corrupt data during migration;
- Automated testing.
Typical Challenges
- You don’t want to pay for large upfront licenses that will have minimal value after the data migration is completed;
- Your new vendor only has experience wth a set of data tools for migration that are different to the current data tools your team use;
- You are capital funding constrained but operating funding rich;
- You have been offered a “special deal” on the tools to allow use for 3 month period, but you are worried about the risk the project will take more than three months and you will need to pay additional license costs.
The AgileData.io Data Migration service provies all the technology needed as part of the subscription. You only pay for the subscription while the Data migration work is underway, no large upfront costs, no ongoing costs once the migration is complete.
Legacy systems complexity
Your legacy system has a large amount of inherent complexity in the way it stores its data, which your new systems vendor might struggle with.
Typical Challenges
- ???
New systems vendor lack of data migration experience
Your new system is the perfect fit for your requirements and the new vendor are experts in their system, but they have minimal data migration experience.
Typical Challenges
- The data required to answer the OIA is stored in multiple data sources.
- Your information technology or data teams are too busy to respond to your data request in the timeframe you need.
- You do not have visibility of the questions that have been asked in the past or the answers that have been provided.
Your company is the projects systems integrator
Your new system is the perfect fit for your requirements and the new vendor are experts in their system, but they have minimal data migration experience.
Typical Challenges
- The data required to answer the OIA is stored in multiple data sources.
- Your information technology or data teams are too busy to respond to your data request in the timeframe you need.
- You do not have visibility of the questions that have been asked in the past or the answers that have been provided.
How it works
Discover your core business questions and processes
Using our magical “who does what” discovery workshop we work with you to quickly identify and agree the core business questions you want to be answered. For example “How many customers do we have”, “Where are they located”, “How much revenue did we make for each customer”.
In the same workshop we gather an understanding of your key business events and concepts, using our Natural Language approach. For example, “Customers Buy Products from an Employee at a Store on any given Weekday”.
This discovery workshop is undertaken remotely and typically involves a couple of hours of your time.
Collect organisational knowledge
You provide us access to the detailed data needed to answer these questions. We have a number of patterns to help make it easy to collect your data in a secure way.
We use AgileData.io to harvest meaning from your data and we have a quick look to gain an understanding of what it contains and how it is structured.
The time it takes to collect this data varies with every customer and source system, as it’s based on the flexibility of your systems and your organisation.
Define business rules
We define data rules using our natural language approach to transform the data from the raw state you provided, to a format that can be used to easily and repeatably answer your question. This may include simple rules such as which data identifies a unique customer, or complex rules, for example, deriving a single (golden) customer record from multiple disparate sets of customer data.
We map your legacy systems to your core business concepts and events, then sync data from those systems to AgileData.io. We then map these concepts and events to your new system and iteratively load data into it from AgileData.io.
We do the majority of the effort defining these, but your time is needed to help us confirm the rules.
Consume your data
Consume your data using your favourite BI or AI tools, without the need to write complex code or join hundreds of tables
You view the answers to your questions. We iterate on the rules until you are happy with the answer that are being provided by your data.
Your data is updated on a regular basis providing an immediate answer to your business questions.
How it works
A simple process to reduce the complexity of answering your most important questions
Discover your core business questions and processes
Using our magical “who does what” discovery workshop we work with you to quickly identify and agree the core business questions you want to be answered. For example “How many customers do we have”, “Where are they located”, “How much revenue did we make for each customer”.
In the same workshop we gather an understanding of your key business events and concepts, using our Natural Language approach. For example, “Customers Buy Products from an Employee at a Store on any given Weekday”.
This discovery workshop is undertaken remotely and typically involves a couple of hours of your time.
Collect organisational knowledge
You provide us access to the detailed data needed to answer these questions. We have a number of patterns to help make it easy to collect your data in a secure way.
We use AgileData.io to harvest meaning from your data and we have a quick look to gain an understanding of what it contains and how it is structured.
The time it takes to collect this data varies with every customer and source system, as it’s based on the flexibility of your systems and your organisation.
Define business rules
We define data rules using our natural language approach to transform the data from the raw state you provided, to a format that can be used to easily and repeatably answer your question. This may include simple rules such as which data identifies a unique customer, or complex rules, for example, deriving a single (golden) customer record from multiple disparate sets of customer data.
We do the majority of the effort defining these, but your time is needed to help us confirm the rules.
Consume your data
Consume your data using your favourite BI or AI tools, without the need to write complex code or join hundreds of tables
You view the answers to your questions. We iterate on the rules until you are happy with the answer that are being provided by your data.
Your data is updated on a regular basis providing an immediate answer to your business questions.
F.A.Q.
How many users can access the answers?
If you are using your own Business Intelligence, Visualisation or Reporting tool to access the answers, then you can have as many users as your tool can support.
If we are providing easy access to the answers via your web browser then we leverage Google Data Studio which is available to as many users as you require at no additional costs.
If you need advanced BI capabilities, we can recommend a number of cost-effective cloud BI options, such as QlikSense, Tableau and PowerBI that enable multiple users to access the answers. However, these will involve additional costs, to purchase the multi-user licenses of those tools, in addition to our fixed price.
What happens if we want to stop?
If you want to stop using the AgileData.io service at any time, we will decommission your access and permanently delete your data.
We suggest you extract all your data from the consume area before we decommission your access, as once we have deleted it we cannot recover it.
Can we get copies of all your code, so we can replicate it on our platform?
No.
One of the reasons we are able to deliver answers to your questions using your data so quickly is due to the magic we have built under the covers on our platform. As you would expect this is the value of AgileData.io and it would be remiss of us to give this magic away.
However, we will always provide you with copies of your event, concept and detail definitions and the Natural Language change rules we configure for you. With these you could build your own data platform and replicate the data you consume from AgileData.io if you desired.