Скачать или смотреть ETL Introduction | SSIS Installation

Hello Guys!
in this session we will discuss about ETL intro and SSIS intro , Installation of SQL Server Services.

ETL : (EXTRACT TRANFORM LOAD)

EXTRACT : Data from different sources and load to staging area
it may be single source or multiple sources (i.e excel/csv/flatfiles/.dat/json OR rdms systems (SQL Server/Oracle/My SQL/Postgre)

Transform :Perform set of fuctions on extracted data to load it into the Target/Destination system.
Cleanse the data to improve data quality and establish consistency

Load : Data is loaded into taget systems it could be Flat files or DWH systems.


Purpose of ETL tools/ Usages of ETL :

1. Data Cleansing
2. More Readable format
3. Perform Analytics (summarized data)
4. DWH (CENTRAL REPOSITORY)
5. Data Mining / Data Modeling

Types of ETL tools available in market :

SSIS
INFORMATICA DATA CENTER
TALEND
PENTAHO
ABINTIO
DATASTAGE
Oracale Data Interchange

Cloud ETL Tools:

ADF (AZURE DATA FACTORY)
AMAZON Glue

WHY WE CHOOSE SSIS ?

1. Microsoft Tool, wizrd base
2. Cheaper compare to other available ETL
3. If you take Visual Studio Licence all SQL Server Tools will be free of cost.
4. Robust/ easy to schedules the jobs


Topics we will cover:

How to create SSIS Packages

-- Data Flow
-- Control Flow
-- Transformations
-- lOGGING
-- Error Handling

How to Deploy

How to Execute

How to Secured the SSIS Packages

How to Scheduled the Jobs


#ssis #ssrs #sqlserver #sqlservertutorial #dataanalytics #etl #bigdata