Posts Tagged ‘data integration’

Traditionally, in our information architectures we have a number of staging or intermediate data storage areas / systems.   These have taken different forms over the years, publish directories on source systems, staging areas in data warehouses, data vaults, or most commonly, data file hubs.   In general, these data file staging solutions have suffered from two […]

IBM states, “The InfoSphere Platform provides all the foundational building blocks of trusted information, including data integration, data warehousing, master data management, big data and information governance.[1]”  They cannot be anymore right!  Managing data has been more complex through the years as companies are trying to bring in more data (Big Data) for their business […]

Without exception, every Salesforce project I’ve managed over the past several years has involved some data integration. Integration is the name of the game: providing more efficient, streamlined processes and better customer insight. This can translate into lower costs and higher sales so its well worth the investment. However, the majority of these projects experienced […]

On a recent project, I was faced with a requirement to scan the contents of a folder and load all the files into their respective staging tables. There were multiple file types – Customer file, Store file, Products file, Sales file, etc. Every day, we received zero to many files for each type of file. […]

Like my 1st grade teacher would tell me when I ended a sentence with this preposition……”It’s between the ‘A’ and the ‘T’”.  Well, in this situation, it’s between the “cloud” and the “on premise”. More and more companies are starting to explore and use Infrastructure as a Service (IaaS) as a viable option for developing […]

Several weeks ago, I was watching a cable network news channel and the news anchor was discussing what it will take to win the next presidential election. As he discussed it in more detail, he commented about how there will need to be much better analysis of data to pinpoint the right segment of the […]

SunGard has identified ten primary trends that have been shaping the financial services industry’s use of big data in 2012. These trends cover wide-ranging drivers such as predictive analytics, compliance, mobile and globalization. To accompany the list, Neil Palmer and Michael Versace (global research director at IDC Financial Insights) discuss these trends in more detail via webcast. Below is SunGard’s […]

The Sitecore Competency Center team at Perficient has worked on projects in the past where we needed to integrate data that would not be stored within Sitecore with items from Sitecore.  We’ve learned a few lessons from doing this, and I hope to share some with you in this post. The first lesson is to […]

In the closing weeks before the Christmas holiday, I made a whirlwind tour of several large integrated delivery networks (IDNs) in search of the newest Holy Grail in healthcare: Managing Population Health. The race to Accountable Care Organizations and Shared Savings performance contracts has resulted in a new level of enterprise data integration never imagined […]

There are many ETL (extract, transform and load) tools out there but Oracle Data Integrator (ODI) has gained a lot of ground because of its ability to perform event-driven, high-volume batch uploads from disparate data sources and to the variety of target applications/data storages.  Having worked on a recent implementation, I have come to appreciate […]

The healthcare world is in the middle of a data revolution of sorts. Both providers and payors are starting to realize that their transactional systems contain a wealth of data that can be used for strategic advantage. Many organizations are spending considerable time and resources in standardizing, cleansing and remediating data issues in their transactional […]