Photo appears courtesy of Kevin Dooley. “You’re gonna need a bigger boat,” is what Roy Scheider famously said in the 1975 film Jaws. Of course, this is now a well-known euphemism for “we’re going to need more resources,” which brings us to a meeting three decades later.
Photo appears courtesy of ITU Pictures. Recently I was reading a white paper about how Advanced Vehicle Technology is changing the Transportation Industry. They were talking about "connected trucks" equipped with IOT (Internet of Things) devices (devices with sensors that can communicate with other devices) that can monitor things like temperature, location and speed and produce data that can be used to drive predictive analytics for companies. I started thinking about how we can leverage the EDI software we use (Liaison's Delta/ECS) to get this data from carriers to the senders and receivers of the goods.
This blog was written by Jim Gonzalez. Over the last 20 years I have been asked a lot of questions by customers and fellow peers about data integration. What I have found is that there are five questions that need to be answered and these are in no particular order. Of course, these questions can and often do lead to new questions. But if you can answer the following initial questions, you will may just stop going in circles and start on a path to success.
File Formats/Layouts to be Integrated:
Are you looking to deal with EDI, XML, CSV, Pipe delimited etc..? A lot of times you will just need to start off handling one format based on your initial engagement. It could be an internal engagement between one department or another. It could be an engagement between your company and a buyer. As I said earlier answering one question can lead into a lot of other questions. Please try to keep your focus on what is right in front of you or upcoming in the next couple of months, not what could be many years away. Long term goals need to be kept in mind while constructing a solution, but it’s easy to get sidetracked so it’s important to prioritize: now, one year from now, five years from now, etc.
How much can you afford to spend? Truly analyze that question and know your answer. You will need to have your software costs locked down and not variable. A huge piece that most people don’t take into full consideration is professional services. Professional services covers billable hours for software installation, map development, consulting and training. Don’t allow a company or consultant to give you a range of hours they don’t commit too. If you allow them to change the hour range when there is no increase in workload it can ruin the entire project. All companies and individuals need to be held accountable to the Statement of Work. You can’t change your mind and then expect the consultants to not change the hours required. Just as a consultant can’t change the hours required to complete a project because they didn’t account for all of your upfront requirements.
ROI (Return on Investment):
How many work hours are you saving? This can be hard to quantify but see this blog for more info on that. Also, would you be increasing revenue with customers? You have to factor in every value-add that data integration will bring. If you can pull it all together and effectively present to the upper level management, it will further your cause and help get your project approved. The more headaches that can be resolved and the less human intervention required will allow your company to accomplish its business goals.
Goals to be accomplished:
Was this mandated by a customer to continue doing business by using EDI or another format? Are you simply doing this to appease a disgruntled employee? Did upper level management hear of this new thing while at the latest conference? No matter how it came about, the bottom line is that you need to move forward with data integration. Keep a record of the successes you have accomplished as each process gets done. It will allow for a time line of events and can lead to more opportunities for data integration that you never even considered. I have implemented many systems over the years and resolved issues for clients who didn’t realize the issues existed.
On Premise or Hosted:
Can your current network handle the data integration? Do you need to purchase additional hardware? Do you have the staff to handle the support? How do you feel about another company hosting the hardware and software for you? Have you weighed the costs? The question of whether you’re better off with hosted or on-premise never has an easy answer and you will find everyone has an opinion. This usually is all preference based. My preference is to control the hardware and software in house. It is an investment that will pay off in the long run. Never allow yourself to get stuck in a short term solution that can’t grow with your organization.
My conclusion for all of this, is that you need to know what you want or at least have an idea. If you can come up with answers to the above questions, with proper guidance you will be able to construct an appropriate solution to meet your business objectives. Since you are reading this, rest assured you have found yourself the right group of partners that you can trust. A good consultant can bring his or her years of knowledge and experience to help you succeed. When I finish an implementation I feel an accomplishment that is unmatched. Reach out and let us know the pitfalls you have going on with your company! Take advantage of our no cost, no obligation consultation.
Picture appears courtesy of Christian Witte. It’s getting hot out there…and I’m not talking about climate change. Our garden is not doing well, but that’s a topic for another day.
Photo appears courtesy of brownpau. This blog was written by Kim Zajehowski, Aurora's Manager of EDI Hosting. How many times have you scheduled to do an EDI application upgrade only to find out you have not met all of the requirements the day of the upgrade or that users were not informed that the system would be unavailable during upgrade time? The objective is to eliminate surprises during the upgrade process and reduce stress when you have to shut down your EDI functionality while you are upgrading your EDI system. Your EDI system is probably one of the most critical applications in your environment.
Photo appears courtesy of Tom Childers. This blog was written by Art Douglas from the Aurora EDI Alliance. As an EDI consultant, every day I search for new clients. Yesterday I once again saw an ad that had frequently presented itself over the past six months. It advertised for an EDI SPECIALIST. In the ad, it described the job as a customer service position, and one of the requirements was, “Must be experienced in entering the EDI orders.”
I get many calls each month from suppliers who have been told by their customer that they need to be EDI capable. And their first question is, "What is EDI capable?" Simply stated, being EDI capable is the capability to send and receive electronic business documents in a specific format based on established standards. There are essentially two ways to accomplish EDI capability: Outsource or buy your own software.
Photo appears courtesy of JD Hancock. I would have to say implementing and running a successful EDI system is 35% exceptional EDI software, 55% experienced EDI consultants and 10% good old fashioned luck. So what can happen when you DON'T have the luck o' the Irish? Bad things, very bad things. Here's a list of some of those nightmares. Watch out for those leprechauns - they can be very mischievous!
For your reading pleasure, we are reprinting our Thanksgiving blog. Enjoy and Happy Thanksgiving from the Aurora EDI Alliance!
Photo appears courtesy of Phill Dolby. I spend a lot of time each summer trying to streamline and automate as many of our processes and procedures as I can. It saves time and, if done correctly, makes our data more accurate and timely. I feel taking the time to do this is well worth the effort and it makes us more profitable in the long run as it frees me up to do other things.