SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data integration and data transformation tasks. It is basically an ETL tool part of the Microsoft Business Intelligence suit that is mainly used to achieve Data Integration.
What is Data Integration ?
Data integration is a process in which heterogeneous data is retrieved and combined as an incorporated form and structure. There are various ways to achieve data integration and below are some of the most popular methods to achieve data integration.
Integration image
Among all these available processes, ETL remains the most suitable and trusted methodology to achieve data integration.
How does SSIS work?
The below flow diagram will give you an idea on how SSIS works:
Operational Data:An operational data store (ODS) is a database designed to integrate data from multiple sources for additional operations on the data. This is the place where most of the data used in current operation is housed before it’s transferred to the data warehouse for longer term storage or archiving.
Extract, Transform and Load (ETL) is the process of extracting the data from various sources, transforming this data to meet your requirement and then loading into a target data warehouse.
Datawarehouse captures the data from diverse sources for useful analysis and access.
Datawarehousingis a large set of data accumulated which is used for assembling and managing data from various sources for the purpose of answering business questions. Hence, helps in making decisions.
To understand more about SSIS with an example, check out this video on SSIS :
BI Developer specialized in SQL Query Development/ SSIS/ SSAS/ SSRS /Power BI/ MS Office. Enjoy working in data analysis and presentation, challenging projects where I can uncover valuable business insights for an organization from previously under-utilized data sources and creating custom made reports and interactive dashboards
