Identifying & Analyzing Security Vulnerabilities While Integration of Data from Cloud to SQL DBMS An Industrial Case Study

Abstract

Data integration defines propulsion of data from numerous sources into a database system in a way that yields the information representing powerful analytics. Various industries are always working towards keeping their data confidential and in a manner that will let them mine it later & retrieve strong statistics out of it for procuring future profits. This research will discuss about using SaaS (Software as a service) and SQL (Structured Query Language) as a combined model for storing inspections data to achieve the above-mentioned goals that the companies are on the road to. Since SaaS and SQL comes into play, a major part of the research automatically pops up, i.e. security vulnerabilities. Hence, this study details about various security threats while using Cloud storage, SQL database and during the ETL (Extraction, Transformation & Loading) from former to latter, in addition to connecting these database systems to produce an overall secure system.