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.
The following task types are only supported in Loome Integrate Online and will not be developed for Loome Integrate V5/Server.
| 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.
| 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 |
| Feature | V5/Server | Online |
|---|---|---|
| Execution of SQL Statements | Supported | Supported |
Execution of .sql files |
Supported | Supported |
| In/Out Parameters | Supported | Supported |
| 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.
| 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.