February 17th, 2015
What do we do with all this data? It seems to be coming from everywhere and there's more of it than ever before. Each day we're making thousands of terabytes of new data. If only integrating it all was as easy as pushing a button! But it isn't.
Let’s take a look at where this new data comes from and some of the problems it causes.
The Driving Force of Data
Organizations continue to collect more and more data. Whether it's from internal systems such as core operating systems, users, external digital marketing sources, or ERP - there is more data now than ever. As executive-level initiatives create more data collection points, data silos need to be built to hold said data. The problem arises when the executives still want quick answers from all of this data regarding their business performance, which means data has to reside in the mission critical systems for quick access.
What executives don't always understand is the reality - that this data is from heterogeneous sources and it's located in different places. From core operational sources, to ERP, to supply chain, to social media and even places as simple as Excel, Access and SQL server - it's sometimes a fragmented mess!
Some organizations will still perform a few or all of these archaic and so-called data integration methods.
- Copying production databases or large database subsets is cumbersome and maintenance intensive.
- FTP is extremely maintenance intensive and antiquated. I.T. personnel, in job security mode, sometimes manually move data on a daily basis which is impractical in the 21st century and not to mention expensive.
- I.T. personnel creating scripts using rudimentary batch scripting languages at the operating system level is not a feasible solution either.
- Some organizations still maintain redundant sources of data essentially eroding any single source of truth.
With all these fragmented systems, businesses eventually figure out how to survive via survival systems and begin extracting data into more data sources such as Excel spreadsheets just so they can achieve somewhat of a consolidated view for identifying trends in business performance. All that effort is rarely a repeatable process for the next business cycle. If the organization doesn’t have the computer-savvy staff that can download and extract data, then pull it into Excel or Access, they have no other option but to live with partial chunks of data that cannot be related or integrated.
Fortunately, there are options available to help with these types of situations. If you’d like to talk more about what’s available, feel free to contact us for more information, and to answer any questions you have.
February 3rd, 2015
Over the last year we’ve published a number of great articles on our blog. We realize that you may not have been a reader the entire time so we’d like to share our top 5 articles from 2014.
The best technologies help businesses grow. But sometimes great technology doesn’t age well, and years later what was once a great solution feels more like a burden. In this article we explore Oracle APEX and what it can do for your business.
Software licenses can be a pain to manage. When you’re working on a new project, it’s often hard to determine which licenses you actually need. And as product names and licensing programs change over time, many companies struggle to keep up with what needs to be renewed and what can be left behind. This article takes a look at how to get help with Oracle licensing.
Feel like you don’t have time to build a relationship with your local resale partner? You’re not alone – you and many others prefer to avoid the work and go straight to an Oracle vendor looking for a sure and safe bet. While that isn’t a bad choice, this article dives in the benefits of working with an Oracle Gold Partner like LSG.
It takes a lot of time and money to build a great technology infrastructure. That’s one of the reasons many businesses struggle with infrastructure issues. This article takes a look at what IaaS is and how it can help your business.
This article tells the story of how a customer of ours outgrew their outdated access database solution and how we helped them overcome the challenges of moving to a new solution.
This is just a sampling of the articles we had last year – feel free to browse through the rest of our blog for anything of interest and always feel free to contact us at (405) 285-2500 if you have any questions.