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