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.