Server - 5.2.5

Please note that support for Loome Integrate Server has ended. Updates and support for Loome Integrate Server ended on the 1st of March 2021. Please feel free to contact us at support@loomesoftware.com to help with the steps needed to move on to Loome Integrate Online.

Successful Business Intelligence is all about the data!

Loome software suite features a unique set of management tools that leverage the full power of the Microsoft Business Intelligence Platform. Loome provides your business user with friendly interfaces that allow uncomplicated access to information, so that it is easy to verify the accuracy and currency of data used for decision making.

You may have a number of ETL processes that run at various times to integrate your data from disparate Sources, into a single warehouse. To manage a few ETL packages may be achievable. However, when there are many, the task to control, maintain and schedule them becomes more arduous.

Loome Integrate empowers you to:

  • Provide transparency on the number of rows that have been loaded by each Task

  • Explicitly publish the currency of data to report consumers

  • Schedule dependant Jobs to run in sequence rather than guessing when each Job is due to complete

  • Quickly interrogate Task errors and Task duration

Our goal is to ensure that your Data Management Tasks are governed and achieved at the highest possible level, helping you get the most out of your Microsoft BI investment every step of the way.

The purpose of this user guide is to provide information to users on how to access and use the features of this tool. Detailed descriptions, step-by-step instructions, and examples are provided for a better understanding.

This is intended for the end users of Loome Integrate. Using this guide, they will get an understanding of the product and its related features.

The targeted audience of Loome Integrate can be broadly classified in two key areas:

  • ETL Developer - users that will configure the tool, define the steps for each of the Task Jobs and schedule the packages
  • DBA - users that monitor Loome Integrate logs and error reports to investigate potential package failures

Product Overview

Loome Integrate provides a central console to manage and audit data integration processes. It also provides visibility and control to ensure timely delivery of data for analysis and reporting. The process flow below provides a high level overview of how Loome Integrate features:

DGProcessFlow

Features

The core features of Loome Integrate can be summarized in the list below:

  • Central console to control all data integration processes
  • Flexible reordering of Job sequencing
  • Stores complete history of all ETL processes
  • Provision of alerts for failed Tasks
  • Reports on execution time and row statistics
  • Deploy Loome Integrate Tasks and Jobs between environments

Benefits

The key benefits of Loome Integrate include the following:

  • Eliminates the time required to build a logging framework for ETL processes
  • Simplifies the management of incremental processing to speed up data refreshes
  • Provides alerts of failed Tasks
  • Manages data processing dependencies
  • Automates reporting of Task execution time
  • Provides a complete auditable history of all ETL processes
  • Easily transfer Tasks and Jobs from a Development to Production environment