What Is Data Integration With Consultation Of SAS DI Studio

Hi All,

We are familiar with all the definition of Data warehouse and the four important words which could define the characteristics of data. We can use the data of the data warehouse to perform various things like: Data mining, Business Intelligence and various types of reporting.

We know it, If we want to perform any operation with the data, We have to have fetch the data from the data ware house. It means firstly we need to collect the data from various sources to create in a unified view for a business purpose.

SAS DI or SAS Data Integration is a ETL (Extract, Transform, Loading) tool. It means we can use SAS DI to create the data warehouse or to fetch the data from it to perform various things and again can upload the data to DW.

Four magical key words to define the Data ware house are Subject oriented, Time-Variant, Integrated and Non-volatile. Which are defined in the definition given by Ralph Kimball.

We are not going currently deeper inside the Data warehouse or it's contents.

Here we go for Data Integration and SAS Data Integration Tool :

•  Unified solution to support all project from building data warehouses to migrate to new ERP System and everything in between


•  Process of actively managing all of our organizational data


• Data Integration is the process of consolidating of data from variety of sources to produce unified view


• Can read data from all available and relevant sources


• To clean the data from point of entry to the point of delivery or every touch point in between


• Consolidated view from many operation system to create Data Warehouse and Data mart to support BI and Analytics


• To Support BI, Analytics program and to store business historical data


• Business gets data from many sources and from many vendors, which contain same information (Changes made in one system would get reflect in all system)


•  To load or Migrate the data from any system


• To consolidate multiple databases into one


• To migrate data from legacy system to reduce cost or to upgrade to latest release of critical application


• Provide integrated solution builds from the ground up solution for all need of data integration


• Solutions are time proven to be rock solid and stable


• It requires from simple and one time migration to complex and real time solutions


• ETL from across the enterprise to create consistent and accurate information


• Data quality (Consistent and reliable data)


• Supports impact and change analysis


• Data synchronization


• Metadata Management


• Can read data from any source including : unstructured data, message cube and legacy systems


• SAS DI Studio not only Extract, transform and load the data, it also perform data cleansing and dimension conforming


• Remove mistakes and corrects data, Captures the flow of transitional data and gives a structure to data to be used by BI tools


• Useful in every sector like : Public Sector, Life Science, Manufacturing, Financial …


• SAS DI is a bridge for BI – Directional flow


• Data migration, Data consolidation, Master data Management, Data Synchronization


• Extensibility with custom connection


• User friendly GUI, Metadata capture and less training time


• Allows integration with existing infrastructure


• Secure communication between Server and client

These notes could be useful for SAS Consultation of SAS DI Studio.