Blog

integration and implementation of technology-focused business solutions

February 2015

Intro to data integration – Part 2 of BI series

February 17th, 2015

Data integration buttonWhat 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.

The Reality

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.

View Part 3 – Data Integration

Comments: None

Our top 5 articles from 2014

February 3rd, 2015

Top 5Over 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.

5. Where does Oracle APEX fit into your business?

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.

Read More

4. Struggling to make sense of Oracle licensing?

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.

Read More

3. Three benefits of working with an Oracle Gold Partner

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.

Read More

2. How infrastructure as a service can help your business

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.

Read More

1. How we helped TBS Factoring leave Microsoft Access behind

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.

Read More

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.

Comments: None

CONTACT

501 E. 15th St., Suite 200B
Edmond, OK 73013
(405)285-2500
info@lsgsolutions.com