Integrated SQL

Why Trust Techopedia

What Does Integrated SQL Mean?

SQL is a solution that performs a wide range of tasks related to data
migration. It is also a platform for data integration and various workflow
applications, and it can automate standard extraction, transformation and loading (ETL). It can also automate the maintenance of updating
multidimensional cube data and SQL Server databases.


Techopedia Explains Integrated SQL

The main characteristics of integrated SQL solutions are:

  • Moving data from a
    single source to the destination with no transformation applied on the data
  • Moving a
    variety of data types such as text files and data files to a variety of
  • Coding environment for coders
  • Built-in capacity to create a variety
    of workflows for a variety of purposes

The solution provides a connection which
provides the information for moving data from source to destination, event
handlers to handle the different events designed as part of the workflows which
are defined within the platform, and parameters that allow the passing of values to the
different properties located inside the packages when the packages are
executed. An integrated SQL solution also lets the user define atomic tasks
which are programmed to complete different actions, for example, the data
transformation task copies data and also implements the ETL features of a
product. The user can assign variables which can store a number of results,
provide data to make decisions and help make configurations.


Related Terms

Margaret Rouse
Technology Expert
Margaret Rouse
Technology Expert

Margaret is an award-winning technical writer and teacher known for her ability to explain complex technical subjects to a non-technical business audience. Over the past twenty years, her IT definitions have been published by Que in an encyclopedia of technology terms and cited in articles by the New York Times, Time Magazine, USA Today, ZDNet, PC Magazine, and Discovery Magazine. She joined Techopedia in 2011. Margaret's idea of a fun day is helping IT and business professionals learn to speak each other’s highly specialized languages.