ETL TOOL ANALYSIS WITH DATA WAREHOUSE EXAMPLE - MICROSOFT SSIS

U ovom diplomskom radu izvršiti će se analiza ETL alat Microsoft SQL Server 2012 SSIS. Microsoft SQL Server Integration Service Microsoftova je platforma koja omogućuje poslovnim sustavima integraciju i transformiranje podataka u svoju poslovnu okolinu. Microsoft SSIS omogućuje nam rješavanje kompleksnih poslovnih problematika poput kopiranja i preuzimanja podataka iz različitih izvora, izgradnju i nadogradnju skladišta podataka i njegovo popunjavanje, operacije nad podatcima poput filtriranja, pročišćavanja, rudarenja podataka, upravljanje podatcima te njihovo prilagođavanje, analizu i pohranu. SSIS platforma dio je Microsoftove široke ponude alata poslovne inteligencije, te je unatoč jakoj konkurenciji koju ima u IBM-u, Oracle i Informatica PowerCenter-u našao svoje mjesto među vodećim na ovom području. Prilikom rada i analize karakteristika SSIS alata koje dolaze uz Microsoft SQL Server 2012 Bussines Inteligence alata iznesene činjenice prikazati će se primjerima. Pojašnjenje kroz praktični primjer bit će prikazano koristeći se Microsoftovim SQL Server Data Tool alatom te SQL Server Management Studio, alatom za upravljanje bazama podataka. ETL alati neizostavno su sredstvo primjenjivano prilikom rada sa skladištima podataka. Svrhu pronalaze prilikom procesa ekstrahiranja ( eng. Extract ), transformiranja ( eng. Transform ) i punjenja odnosno unošenja ( eng. Load ) podataka iz jednog ili više transakcijskih baza podataka u skladište podataka koje namijenjeno poslovnom sustavu. U uvodnom dijelu diplomskog rada pojasnit će se osnove ETL procesa. Nadalje će se opisati pojedine faze operacija unutar procesa ETL-a, faze ekstrahiranja, transformiranja i punjenja podataka. Svi postupci bit će prikazani koristeći se isključivo Microsoft SSIS platformom za integraciju podataka. Pritom će se dati uvid i u brojne alate za manipulaciju podataka.In this master thesis the main focus will be the analysis of Microsoft's SQL Server 2012 SSIS ETL tool. Microsoft Integration Service is Microsoft's a platform which provides business solutions for data integration an data transformation processes into their business envieroment. Microsoft SSIS also allows us the solving of complex business tasks like data extraction and copying data from different sources, the process of building data warehouses, their maintenance and data loading processes as well as various data operations like data cleaning and filtering, data mining, data adjustment, analysis and storage. The SSIS platform is a part of Microsofts wide selection of business inteligence tools, and although it has a strong competition found in IBM, Oracle and Informatica PowerCenter it has earned his place on top of the list. While working and analyzing the characteristics of the SSIS tool which comes as a part of the Microsoft SQL Server 2012 Business intelligence, the facts which will be told are going to be shown and explained with proper examples. The examples will be demonstrated using the SQL Server Data Tool and SQL Server Management Studio, a tool which is used for database management. ETL tools are a must have while working with data warehouses. Their usage can be found while performing data extractions, data transformations and data loading processes from one or multiple source databases into our data warehouse which is meant for a specific business purpose. In the introduction part of this master thesis, the main parts of the ETL processes will be explained. The other part is going to be about the three main ETL processes, extracting, transforming and loading of data. All steps will be shown by using only the Microsoft SSIS platform for data integration. A look into the many different tools for data manipulations will be given as well