Definitions

The following table includes useful definitions of terms used within this document, and Loome Integrate:

Word/Phrase Description
SQL Server SQL Server is a relational database management system (RDBMS) and a suite of enterprise tools from Microsoft.
ELT Short for Extract, Load, Transform - three database functions that are combined into one tool to pull data out of one database in current state, load it into a Target staging database, then transform that data.
ETL Short for Extract, Transform, Load - three database functions that are combined into one tool to pull data out of one database, transform the data through the processing layer and load it into a Target data warehouse.
SSIS (Microsoft) SQL Server Integration Services. A tool from Microsoft for easing the integration, cleansing and analysis of data from multiple, heterogeneous information Sources.
SQL Agent Job The SQL Server Agent is a service that lets you configure scheduled Tasks and system alerts. SQL Server Agent runs continuously in the background as a Windows Service.
SQL Abbreviation of structured query language, and pronounced either see-kwell or as separate letters. SQL is a standardized query language for requesting information from a database.
Group A Loome Integrate term used to describe a series of Projects with Users given access to the Group and it’s subsequent Projects.
Project A Loome Integrate term used to describe a Loome Integrate solution. Connections, Datasets, File Definitions, Jobs and Tasks are created within a Project.
Task A Loome Integrate term used to group the variety of the ETL transformations that can be created and used within Loome Integrate.
Job A Loome Integrate term used to describe an overall container of Tasks within a Loome Integrate Project.
SSAS (Microsoft) SQL Server Analysis Services. A tool from Microsoft that is an online analytical processing (OLAP), data mining and reporting tool used by organisations.
SSMS (Microsoft) SQL Server Management Studio. It is an integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server.