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. |