What is Data Integration?

1
What is Data Integration?
2
More...
Combination of data from several different
sources is called data integration that is sored
using lots of technologies and give a unified
view of th data. There is an increasing
significance in cases of merging systems of two
companies or integrating applications within an
organization for providing unique view of the
companys data assets. Data warehouse is the
later initiative. The most famous application of
data integration is building an enterprises Data
Warehouse. In the source system , this would not
be feasible on the data available.
Stay Connected For More Updates
3
More...

• Data Integration Areas
• It covers several distinct sub-areas like
• Data Warehousing
• Data Migration
• Enterprise application/ information integration
• Master data management

Stay Connected For More Updates
4

• Difficulties in Data Integration
• The biggest difficulty is the technical
  implementation of integrating data from different
  and incompatible sources. A much difficult
  challenge is the data integration. These are the
  following phases

• Design
• The data integration should be an initiative of a
  business and not IT. There is a need of a
  professional for understanding the assets of the
  data for leading the discussion about the
  long-term data integration initiative for making
  int consistent, beneficial, successful.

More...
Stay Connected For More Updates
5

• Implementation
• A feasibility study is performed based on the SRS
  and BRS for selecting the tools and implementing
  the data integration system. There are some small
  companies and enterprises that start with
  warehousing the data and faces the decision
  making about the set of tools they require for
  implementing the solution. The enterprise which
  all already initiated the projects of data
  integration in easier position they already
  experience the extended existing system and
  exploit the knowledge present for implementing
  the system more effectively.

More...
Stay Connected For More Updates
6

• Testing
• A proper testing strategy is required along with
  the implementation for ensuring the correctness
  of the unified data, up-to-date, and complete.
  Both organizational requirements and technical IT
  participate in the testing for ensuring that the
  results are expected/required. For incorporating
  the testing Performance Stress test, Technical
  Acceptance Testing, and User Acceptance Testing
  is required at the least. 

More...
Stay Connected For More Updates
7
Thank You

• To know more join the DBA institute in Pune to
  make a successful career as a DBA Professional in
  this field. Hurry up, dont miss!

• Stay connected to CRB Tech for more technical
  optimization and other updates and information.

Stay Connected For More Updates