Top 10 Best Practices for Data Integration - Slide 3

Email     |     Share  
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
Next Data integration practices reach across both analytics and operations-3 Next

Data integration practices reach across both analytics and operations

Data integration techniques are practiced in support of a variety of business initiatives and technology implementations. Hence, in many ways, DI best practices are defined by their associated initiatives and implementations.

  • Analytic data integration (AnDI) is where one or more DI techniques are applied in the context of business intelligence (BI) or data warehousing.
  • Operational data integration (OpDI) involves the access and integration of data among operational applications and databases, whether within one organization or across multiple ones.
  • Hybrid data integration (HyDI) practices fall in the middle ground between AnDI and OpDI. Hybrid DI includes master data management (MDM) and similar practices like customer data integration and product information management.

The three practice areas of DI span analytics and operations, plus the overlap between them. Across these practices, any DI technique and tool type may be used and all practices assume core skills for databases, data models, interfaces, and transformations.

The data management discipline known as data integration (DI) has undergone an impressive expansion over the last decade. Today it has reached a critical mass of multiple techniques used in diverse applications and business contexts. Vendor products have achieved maturity; users have grown their DI teams to epic proportions; competency centers regularly staff DI work; and DI as a discipline has earned its autonomy from related practices like data warehousing and database administration.

Given all this change, it’s not surprising that people in the field might not be up to speed on the current incarnation of DI. Even DI specialists and the colleagues who depend on them sometimes forget the new techniques, diversity, independence, collaboration, and governance typical of modern DI practices. Many suffer misconceptions and out-of-date mindsets that need adjustment.

The 10 practices in this slideshow, from a TDWI report sponsored by SAS, paint a modern landscape of current DI practices. They also bust a few DI myths that are still too common. Moreover, they raise the bar on DI, showing how sophisticated and powerful a DI solution can be—at least when DI is driven by modern best practices using up-to-date tools.

If you let it all soak in, this checklist  will redefine DI for you and your peers. And it will help you set higher goals and aspirations for DI work and its outcome. The practices listed here can be the guidelines that help you achieve more modern, high-value, diverse, independent, well-designed, far-reaching, green, collaborative, and well-governed uses of DI tools and techniques.

More Slideshows:


Tips on Controlling Your E-mail So It Doesn't Control You Get a handle on frequent interruptions caused by incoming e-mail.

Restoring Files: A $9 Billion Waste of Time Survey finds that a staggering amount of IT personnel time is wasted on restoring files.


Top 10 Wireless Predictions for 2011 Juniper Research has drawn up a list of predictions for 2011.

 

Related Topics : Application Security, IT Process Management, Six Sigma

 
More Slideshows

Five9RemoteEmployees0x 5 Best Practices to Enable Remote Workers

Recent years have seen a significant increase in the remote workforce as developments in technology have given employees the freedom to work anywhere, anytime. ...  More >>

DataM62-190x128 10 Steps for a Proper Data Governance Plan

Establishing a digital governance plan can be a challenge, but with the right education and tools, the job can be made a lot simpler. ...  More >>

DynCloudInternetVisibility0x 8 Reasons the Enterprise Needs More Visibility into the Cloud

IT executives need the right tools to monitor and control their cloud infrastructure to maximize the positive impacts and mitigate security threats. ...  More >>

Subscribe to our Newsletters

Sign up now and get the best business technology insights direct to your inbox.