Category Archives: Data Migration

What Can Turnkey Manufacturing Software Do for You?

A manufacturing software solution is only as good as the data that fuels it.

Many implementations fail to connect existing production data to the new software. Once the system is installed, users are forced to fill the vast empty software space with data – planning, work instructions and production documents. There’s little forethought given to the migration process. This leaves gaps and errors the shop floor will continue to struggle with.

Missing Data Hurts Production

Without a strategy to migrate existing data, production will suffer even after implementation. Avoidable production errors and inefficiency will persist. Missing data forces the shop floor to rely on conjecture during production. Engineers must recreate files or leave holes in the planning if they can’t access critical data – creating production waste and mistakes.

Data silos are born in the gaps you leave in the new software. Users create disconnected and inefficient data sources to get the information they need and fill the information gaps. Rather than helping users work more efficiently, the new software has forced users to develop homegrown solutions to access critical data that didn’t fit the rigid requirements of their new system.

The Advantages of a Turnkey Manufacturing Solution

A turnkey manufacturing solution like the Quantum platform eliminates problems by intelligently migrating and linking all of the required production data to create a comprehensive source of workflow information. This process solves problems and provides proven production advantages:

  • Accelerate production, process improvement and user-acceptance with your critical production data pre-loaded into the system.
  • Retire expensive and disconnected databases, and eliminate production errors through Smart Manufacturing by transforming passive flat files into intelligently-linked active data.
  • Increase production output by accessing data through a comprehensive source of manufacturing information.

Quantum utilizes a Data Migration Engine (DME) with powerful ETL (Extract, Transform, Load) capability to extract data from any source system or file. Quantum applies correction algorithms to the data removing common errors before transforming the data and linking it to active objects. When complete, engineers and users have the data they need in a format ready for use in production or predictive analytics.

Since it’s the data they are already using, users immediately begin work without the errors and frustration that often accompany a new implementation. The company can focus on rapid process improvement rather than struggling to overcome problems.

Contact CIMx today to learn how the Data Migration Engine and Quantum will accelerate system implementation and provide a rapid ROI for businesses seeking a solution to their manufacturing problems.

The Curious State of the MES Industry

Manufacturers shouldn’t expect MES projects to be late and over-budget, but many do. They should expect exceptional customer service and successful data migration, but that’s not what many suppliers offer.

By Kristin McLane, President of CIMx Software

Recently, I was in a Verizon store trying to transfer information from my old phone to a new device.  This is not rocket science.  We should know – our software has helped put the space shuttles, the Delta Rocket, commercial aircraft and satellites into the air.

This is a simple data transfer, moving my applications, names, numbers and other information from an old device to a newer, smoother, faster device.  After a few minutes in the store, I began to doubt Verizon could finish the job.  Could I still use the new phone without my data?  Of course – I could also start over and just copy what I needed, one application or contact at a time, but I didn’t want to.

Computer devices around 3d small person.

Working with an MES supplier shouldn’t be confusing or frustrating. Illustration by http://www.colourbox.com

I know how easy the migration should be, because we’ve spent a lot of time, energy and brainpower working with data.  Last year, we introduced a new product offering that transfers data from any platform to any other platform.  We are using it to migrate, move and repair all kinds of data, including embedded data links and legacy databases that haven’t been updated for decades.

So why can’t Verizon move a few apps and files?  From what I can tell – they don’t want to.  They don’t feel it’s worth their time.  It’s an expensive use of their resources in an industry with consumers who have come to accept crappy customer service. For them, there is no value in offering the service.

And that’s when I started to think about the MES industry.

MES Suppliers versus Manufacturers

In 20 years in this business, I’ve never met a manufacturer that doesn’t have existing data they need to move to a new system.  Whether they have 20 years of data, or just 30 months, they need access in order to continue work. As a computer system ages, slowly drifting into obsolescence, access becomes difficult and the system starts holding back production.

Once they see the problem; most companies do nothing right away.  They take time (lots of it) to get everyone together to discuss what they need in their new system.  Prospects end up with requirements that read like a wish list for Santa.  Last year, we had a prospect tell us they had created a “very modest” list of requirements.  They wanted a quick ROI and were tightly controlling the project asks.  The sheet they sent had close to 250 line items (which make me wonder what the “not-modest” requirement list looked like).

Efficient Manufacturing

Are you letting MES expectations hold your project back? Illustration by http://www.colourbox.com

This has become an industry standard because, much like the ill-fated and poorly equipped smart phone service providers, people have come to expect expensive, overly complex and mostly late projects from the software suppliers in our industry.  They believe an incredibly long and maddeningly-detailed requirement list is a necessity to play the game.  Suppliers are happy to play along, especially since most providers can’t deliver a project on-time or on-budget.

It’s true.  We constantly hear horror stories of projects gone wrong – delivered, but phenomenally over-budget, with functionality missing and a system that leaves the users disappointed.

When working with MES providers, companies create a huge list of asks to help protect themselves and their project.  If they’re going to jump in and spend the time and the money, they figure they need to get the bang for the buck.  Plus, if the project is going to under-deliver, the customer assumes it is better to fill up the requirements.

A Better Way to Manage MES Projects

Bigger projects don’t mean better results.  More service charges won’t deliver more effective software.  Adding another report or another piece of esoteric functionality isn’t going to protect you from failure (in fact, it will add to the complexity, which is never a good idea).  A brand-name (large provider) also does not guarantee success; the delivery may eventually come, but long after your needs have changed.

3d small people with a checklist

Work collaboratively with your MES supplier, and expect them to work collaboratively with you. Image by http://www.colourbox.com

Back to Verizon, who broadcast on commercials non-stop how they’re the largest this, the best that.  Offering the largest data network in the world doesn’t do anything if you force the customer to move information from one phone to another.  All that network power does me no good if I can’t access my contacts.  They are making their product less accessible.

Eventually, I did solve the problem on my own.  Shortly after leaving the store, thoroughly disgusted with the time wasted, the service (lacking) and the attitude (the 20-something Verizon rep cited her years in the industry as proof she could get the job done – before she totally failed at it), I was able to move my applications over.  Today, my phone and I are operating smoothly, despite any help from the supplier.

It’s true… the promise of a better network doesn’t mean better customer service. Similarly, the promise of a more expensive and complex MES does not mean a better system or improved production.

Take the time to work with the MES supplier to understand your needs and develop a project plan and requirement list. Together, you can design a project that benefits production, rather than setting everyone up for failure. Develop trust with the supplier and work collaboratively. Want to see what working collaboratively can do for you?  Ask for a shop floor analysis – it’s the first step toward seeing how an MES can benefit you.

Honestly, not every MES supplier can work like this. The focus on massive, overly complex projects using software developed decades ago is so embedded in our industry; some companies see project overruns and missed deadlines as the cost of doing business.  The supplier relies on those expectations and the customer cringes and comes to expect it… which is too bad, because it shouldn’t be that way.

So as not to leave you thoroughly discouraged, there are vendors who do what they say, and companies who believe the status quo isn’t good enough.  We offer written guarantees on price, project and timeline, and we don’t overpromise just to get a sale.  I don’t know another provider that’s out there that does what we do, but surely we can’t be the only one in the industry who provides projects on-time and on-budget?

In the meantime, I’m still looking for an honest telecommunications company who can manage a simple migration between phones.  Let me know if you find anyone.

Data Migration

Delivering Solutions with a Data Migration Engine

The data migration engine gives companies a reliable and safe tool to transfer their critical data and content from one system to another.

By David Oeters, Corporate Communications with CIMx Software

Our goal with the CIMx Data Migration Engine is to give companies a reliable, safe, and cost-effective way to move their data and content. Data migration shouldn’t be a reason why a business clings to outdated, unreliable and inefficient software systems.

Unfortunately, data migration is a burden for many companies updating their internal software systems – a very expensive burden that can lead to future problems if it’s not done right.

The Value of Professional Data Migration

3d man in trouble

Do you have the right solution for your data migration? Illustration by http://www.colourbox.com

Data migration is a critical task when replacing older software with a newer system, consolidating information, or archiving and better utilizing content.

Companies limping by on old, error-prone legacy systems (you know the ones – ancient MS Access databases or software cobbled-together by a long-since retired co-worker) need a better solution if they want to grow. Outdated software will limit productivity and growth.

Data migration is a critical step in upgrade projects, but we’ve seen many companies roll out a new software system, with a foolproof implementation plan, only to have the project go off the rails when it comes time to move the content.

There are a lot of ways a migration project can go wrong:

  • The old data doesn’t work with the new system.
  • The content doesn’t transfer correctly, and you’re left with massive gaps in your database.
  • Lingering errors in the data, which past processes compensated for, render the new system useless.
  • The cost of the migration is so expensive; the decision is made to re-input everything and to keep the old system running for archive purposes.
  • Critical pieces of data have nowhere to go in the new system, and are either deleted or left in an old file that can’t be used.

The CIMx Data Migration Engine directly addresses these issues, delivering solutions rather than problems when it is time to move data.

Solutions for Data Migration

CIMx Software started more than 20 years ago as experts in managing manufacturing data. Many of the world’s largest manufacturers rely on CIMx database expertise through our CAPP (Computer-Aided Process Planning), advanced MES, and digital manufacturing solutions.

That expertise provided the foundation for the Data Migration Engine. Using the Engine, CIMx preserves the schema, organization and structure of a database throughout the transfer. Before beginning the actual migration, CIMx maps the data and structure to the new database or system, ensuring the schema is intact.

More advanced features of the Engine allow CIMx to work with end users to analyze and inspect the content and repair errors. Common errors, such as substitutions, are made automatically. Individual errors such as missing data and incorrect data values can be identified and then corrected. Flat files can also be converted to an accessible, object-oriented format ready for further use or even reporting.

The CIMx Data Migration Engine eliminates many of the risks and problems associated with standard data migration. In addition to ensuring a safe and reliable transfer, the Engine adds value by repairing many of the errors that limit the efficiency of older data – providing a solid foundation for modern, smart manufacturing solutions.

Want to learn more, or get an estimate on how the CIMx Data Migration Engine might help you? Then contact us today for a free shop floor analysis. We’re always happy to help.