Smart ETL Tool Design Phase
Get Smart ETL Tool Design Phase at very low cost. Also get complete trialing providing by IT experts. Following is the sample design phase.
Smart ETL Tool
Design Document
Version 1.0
Group Id: <Mention your group id>
Supervisor Name :< >
Revision History
| Date (dd/mm/yyyy) | Version | Description | Author |
| Current date
|
Introduction of the project
|
||
Table of Contents
- Introduction of Design Document
- Entity Relationship Diagram (ERD)
- Sequence Diagrams
- Architecture Design Diagram
- Class Diagram
- Database Design
- Interface Design
- Test Cases
- Introduction of Design Document
It is a desktop application which enables the user to map multiple databases to a DWH in a DBMS. Extract, Transform and Load (ETL) is a process used in Data Warehouse. This process Extracts the data from multiple sources, Transforms the data for storing it in proper format/structure andthen Load in to DWH.
Requirements:
- The user will first select the database/databases and DWH for mapping.
- The software will show the summery to the user regarding the structure and metadata of the databases as well as of the DWH.
- The software will provide the facility to the user to map the different tables and columns of database (s) to the tables and columns of DWH.
- The software should provide the facility to extract the data from multiple databases.
- Extraction can be of the following types.
- Full Extraction
- Incremental Extraction
- The software should provide the facility to transform the data.
- The user can select any type of transformation from the following (one or more)
- Splitting/Joining
- Conversion
- Summarization
- Enrichment
- The software should provide the facility to load the data in to DWH.
- The user can select any type of loading from the following
- Full data refresh
- Incremental data refresh
- Trickle/continuous feed
- Entity Relationship Diagram (ERD) (To be developed using Microsoft Visio or any other drawing software of your choice)
- Sequence Diagrams (To be developed using Rational Rose or any other drawing software of your choice)
3.1 Add Executive
Admin
Add ()
Save ()
Process ()
Response
Updated
3.2 Remove Executive
Admin
Remove ()
Check ()
Process ()
Response
Updated
3.3 Load Data:
Admin
Load ()
Save ()
Process ()
Response
Updated
3.4 Transform Data
Admin
Transform ()
Check ()
Process ()
Response
Transformed
3.5 Extract Data
Admin
Extract ()
Check ()
Process ()
Response
Extracted
- Generate Report
Executive
Generate ()
Contents()
Process ()
Response
Save
- Architecture Design Diagram
- Class Diagram
- Database Design
Star schema is provided.
- Interface Design
Add data:
Extract Data:
Report:
- Test Cases
Test Case Title: Add Database
| Preconditions | Admin will be able to add data in database from different sources. |
| Actions |
Click add data Enter Db details Press connect System will check the details After connecting create new database Create new table Enter the data for the table Press Go
|
| Expected Results | If there is an error at any stage system will display it. |
| Tested By: | |
| Result: | Tested |
Test Case Title: Extract Data
| Preconditions | Admin will be able to extract data in database from different sources. |
| Actions |
Click add data Enter Db details Press connect Smart ETL Tool Design Phase System will check the details After connecting create new database Click import data Select db file Press Go
|
| Expected Results | If there is an error at any stage system will display it. |
| Tested By: | |
| Result: | Tested |
Test Case Title: Transform Data
| Preconditions | Admin will be able to transform data in database from different sources. |
| Actions |
Click add data Enter Db details Press connect System will check the details After connecting create new database Click import/export data Select db file Press Go
|
| Expected Results | If there is an error at any stage system will display it. |
| Tested By: | |
| Result: | Tested |
Test Case Title: Add executive
| Preconditions | Admin will be able to add an executive account on the application. |
| Actions |
Click create new account Smart ETL Tool Design Phase Add details Add account role Hit enter
|
| Expected Results | If there is an error at any stage system will display it. |
| Tested By: | |
| Result: | Tested |
Test Case Title: Remove executive
| Preconditions | Admin will be able to remove an executive account on the application. |
| Actions |
Click remove new account Hit confirm System will remove the account
|
| Expected Results | If there is an error at any stage system will display it. |
| Tested By: | |
| Result: | Tested |
Test Case Title: Create Report
| Preconditions | Executive will be able to create report of database using the application |
| Actions |
Hit create report Enter the data Hit enter
|
| Expected Results | If there is an error at any stage system will display it. |
| Tested By: | |
| Result: | Tested Smart ETL Tool Design Phase |
