Data virtualization has proven to be beneficial to data integration, but it does have its limits, says new research from TDWI.
The report “Ten Mistakes to Avoid When Using Data Federation Technology” is co-authored by Claudia Imhoff, president of Intelligent Solutions, and Colin White, president of BI Research.
Data federation can combine data without having to move the data from the original sources, accelerating the data integration process.
“Data virtualization or federation has achieved a significant role in enterprise data management strategies because it allows data integration teams to quickly create virtually integrated data sets for many purposes – BI, CRM, MDM, etc.,” Imhoff explained in a release.
To ensure proper adoption, the authors warn about potential pitfalls such as insufficient monitoring of potential impact on source systems and not fully determining data virtualization infrastructure requirements. In addition, Imhoff and White caution against using data virtualization or federation for inappropriate scenarios such as the creation of virtual data warehouses, large-scale real-time analytics or where highly complex, multi-step transformations and aggregations are required.
Other mistakes to avoid include: failures such as not properly understanding the opportunities to gain value from data virtualization, including underutilizing it in data management architectures; not applying it to prototyping and other activities it does better than more traditional approaches; not defining shared business views of source data; and limiting its use to relational data only.
This story has been reprinted with permission from Information Management.
Register or login for access to this item and much more
All Digital Insurance content is archived after seven days.
Community members receive:
- All recent and archived articles
- Conference offers and updates
- A full menu of enewsletter options
- Web seminars, white papers, ebooks
Already have an account? Log In
Don't have an account? Register for Free Unlimited Access
Corrected December 9, 2010 at 10:07AM: yes