Version Comparison

Loome Integrate Online vs. Loome Integrate V5/Server

Feature Support Matrix

V5/Server Exclusive Task Types

The following task types are currently supported only in Loome Integrate 5/Server. Please note that this doesn’t mean that they will never be supported in Online and it is worth contacting Loome if you have any queries about certain task types support.

  • Master Data Services (MDS)
  • SQL Server Integration Services (SSIS)
  • Reconciliation
  • XMLA Command
  • Similarity
  • Persist

Online Exclusive Task Types

The following task types are only supported in Loome Integrate Online and will not be developed for Loome Integrate V5/Server.

  • Hive
  • Spark
  • Azure Data Factory
  • Azure Batch
  • Shipyard HPC
  • Microsoft Genomics Service

Data Migration Version Comparison

Feature V5/Server Online
SQL Server Source & Target Supported Supported
ODBC Source Supported Supported
Flat File Source & Target Supported Supported
Azure Blob Source & Target Supported Supported
Amazon S3 Source & Target Not Supported Supported
Google Cloud Bucket Source & Target Not Supported Supported
HDFS Target Not Supported Supported
DBFS Target Not Supported Supported
Parquet File Target Not Supported Supported
Xero Source Not Supported Supported
Google & Youtube Analytics as Source Supported Supported
CRM Applications Source Supported Partially Supported *
Incremental Configuration Supported Supported
Import Indexes & Keys Supported Supported
Query as Source Supported Supported
Column Level Migrations Partially Supported ** Supported
Parallel Data Migration Partially Supported *** Supported

* Some CRM sources may not be fully supported yet, please contact Loome if you have a question about a CRM source’s availability in Loome Integrate Online.

** Can be achieved using query as source, not supported through the Migration UI.

*** Parallel Data Migration in V5/Server can only be configured at the global level as opposed to Online where it is configured per-task.

Stored Procedure Version Comparison

Feature V5/Server Online
Execution of Stored Procedures Supported Supported
Manual Input of Stored Proc Name Supported Supported
Loading of available Stored Procs Supported Supported
In/Out Parameters Supported Supported
Incremental Config Supported Not Supported

SQL Statement Version Comparison

Feature V5/Server Online
Execution of SQL Statements Supported Supported
Execution of .sql files Supported Supported
In/Out Parameters Supported Supported

OS Command Version Comparison

Feature V5/Server Online
Execution of Shell Commands Supported Supported
Piping of Standard Output & Error Supported Supported
Cross Platform Not Supported * Supported

* Loome Integrate V5/Server only runs on Windows based operating systems.

PowerShell Version Comparison

Feature V5/Server Online
Write & Execute Powershell in Loome Integrate Supported Supported
Execution of .ps1 files Supported Supported
Script Parameters Supported Supported
Source & Target Connections Not Supported Supported
Autocompletion for params in Loome Integrate Not Supported Supported
Windows Powershell Module Support Supported Partially Supported *
Powershell Core Module Support Not Supported Supported
Cross Platform Not Supported Supported

* Only works when using the Windows Powershell task type, uses PSRemoting.