Loome Integrate Documentation
Online
Getting Started
Version Comparison
Supported Login Providers
Integrate Server & Online Interoperability
Knowledge Base
Batch task is not updating the container image from the cluster definition
Connect to Azure Batch via Managed Identity
Connect to Fabric Lakehouse SQL Endpoint
How to configure custom DNS in a Loome Container Instance
Power BI Dataset Refresh
System.OutOfMemoryException when extracting a JSON file
How to Change the Timezone in Parquet
Loome Agent may not start on Azure Container Instances
Project Not Found Error Message
The agent service intermittently stops unexpectedly
Token Refresh for 'connection name' failed
Unable to Access Loome Integrate
Unable to clone the repository
Tenants
Creating a Tenant
Managing a Tenant
Agents
Deployment Scenarios
Installing an Agent
Updating an Agent
Additional Agent Configuration
Agent Level Settings
Agent FAQ
August 2020 Update
Contacting Support for an Agent
Application Roles
Connections
Add Connections
Manage Connections
Connection Type Reference
Access
Aconex Application
Aconex V2 Application
Amazon DynamoDB
Amazon S3 Account
Azure Batch Account
Azure Blob Storage
Azure Active Directory Application
Azure Data Lake Storage Gen2
Azure File Share Storage
Azure Synapse SQL
Azure Table Storage
Azure Synapse Spark Pool
Bing Ads
Bing Search
Cassandra
Couchbase
DataBricks
Dynamics CRM
Excel
Facebook
FTP
Git Repository
Google Adwords
Google Analytics
Google BigQuery
Google Cloud Storage Bucket
HBase
HDFS
Hive
HPCC
HubSpot 2018
JSON
JIRA
Livy
Loome Monitor
MailChimp
Marketo
Microfocus ALM
Microsoft Dataverse
Microsoft Graph
Microsoft SQL Server
Microsoft Genomics Service
MongoDB
MYOB AccountRight
MYOB AccountRight Online
MySQL
NationBuilder
OData
ODBC
Using ODBC with Linux/Containers
Oracle ODBC on Containers
Oracle Data Provider
PostgreSQL
SAGE 50 UK
Salesforce
Salesforce Chatter
Salesforce Marketing Cloud
SAP
SharePoint
Snowflake Data Warehouse
Sugar CRM
Square
RSS
xBase
XERO
XML
YouTube Analytics
YouTube Data 2018
Zoho CRM 2018
Zuora
Additional Connection Security
File Definitions
File Definition Concepts
Add a File Definition
Manage File Definitions
Troubleshooting
Cluster Definitions
Cluster Definition Concepts
Adding a Cluster Definition
Editing Cluster Definitions
Projects
Adding a Project
Managing a Project
Project Roles
Jobs
Adding a New Job
Running & Managing Jobs
Editing a Job
Managing a Job's Tasks
Schedules
Creating Job Schedules
Managing Job Schedules
Tasks
Adding a New Task
Execute a Script in a Git Repository
Running Scripts in Parallel
Task Types
Azure Batch
Azure Data Factory
Azure Function
Data Migration
Kepion Migration
Azure Data Lake Storage
Databricks
Loome Monitor Rule
MS Genomics
OS Command
Persistent Staging
PowerShell
Python
Shipyard HPC Script
Spark
Spark SQL Statement
SQL Statement
SQL Server Integration Services
Stored Procedure
Editing a Task
Deleting a Task
Cloning a Task
Running a Task in Parallel
Task Settings
Managing Tasks
Notifications
Developers
How to run Jobs Programmatically
Import/Export
Import Types
Export and Import Connections
Tenant to Tenant Import
Git Repository Import
Setup Guides
Import/Export & Azure DevOps
Import/Export & Github Actions
Release Notes
10th of December, 2024
28th of May, 2024
30th of November, 2023
26th of September, 2023
13th of April, 2023
21st of November, 2022
17th of May, 2022
3rd of February, 2022
7th of October, 2021
22nd of June, 2021
13th of May, 2021
18th of March, 2021
10th of November, 2020
15th of May, 2020
30th of March, 2020
23rd of December, 2019
21st of November, 2019
8th of October, 2019
24th of September, 2019
5th of September, 2019
5th of August, 2019
2nd of July, 2019
11th of June, 2019
21st of May, 2019
18th of April, 2019
4th of April, 2019
21st of March, 2019
3rd of March, 2019
27th of February, 2019
20th of February, 2019
13th of February, 2019
Security Considerations
Support
Server
End of Support for Loome Integrate Server
Definitions
Installation
Back End Prerequisites
Web Interface Prerequisites
Install Back End Engine
Install Web Interface
Soraco License Activation
Configuration
Getting Started
Accessing Loome Integrate
Navigating the user interface
Kepion Quick Setup Check List
Building a Loome Integrate Solution
Adding Groups and Projects
Groups
Projects
Adding Connections, Data Sets, and File Definitions
Add Connections
Connectors Help
Active Directory
Azure Blob Storage
Azure Storage
Excel Files
Facebook
Freshbooks
Google Adwords
Google Analytics
Google Big Query
Hubspot
JIRA
Kepion
Magento
MailChimp
Master Data Services
Microsoft Dynamics 365
Microsoft Dynamics CRM
Microsoft SQL Server
MySQL
ODBC
ODP
OLEDB
Quick Books Online
Sales Force
Send Grid
Service Now
Twitter
XMLA
YouTube
YouTube Analytics
Zuora
Add Data Sets
Add File Definitions
Adding a new Job
Adding a new Task
Data Migration task
Kepion Data Migration task
Load Dim Member List
Load Dim Hierarchy
Load Static Partition Table
Export from Kepion task
MDS task
Export from MDS task
SSIS Package task
Reconciliation task
Stored Procedure task
XMLA Command task
SQL Statement task
PowerShell task
Operating System task
Similarity task
Persist task
Managing a Loome Integrate Solution
Managing a Job
Editing a Job
Job Tasks Lists
Modifying Task Order
Removing a Task
Parameters & Dependency
Incremental Settings
Additional Parameters
Execution History
Logging Details
Reconciliation Results
Scheduling
Managing a Task
Editing a Task
Deleting a Task
Cloning a Task
Tasks Menu Items
Connections
Data Sets
File Definitions
Admin Menu Items
Users
Adding a new user
Editing an existing user
Deleting a user
Subject Areas
Adding a New Subject Area
Using a Subject Area
Editing a Subject Area
Deleting a Subject Area
System Settings
Loome Integrate Deployment
Exporting Jobs
Importing Jobs
Deployment Log
Verification
User Option Menu Items
Configuring Email
Release Notes
Version 5.2.8
Version 5.2.7
Version 5.2.5
Version 5.2.4
Version 5.2.3
Version 5.2.2
Version 5.2.1
Version 5.2
Version 5.1
Version 5.0
Version 4.0
Version 3.0
Version 2.0 (ETL Manager)
Version 1.0 (ETL Manager)
Renewing Your License
Loome Integrate
>
Online
>
Tasks
> Task Types
Task Types
In this section is a description of each task type available in Loome Integrate.
Task Types:
Azure Batch
Azure Data Factory
Azure Function
Data Migration
Databricks
Loome Monitor Rule
MS Genomics
OS Command
Persistent Staging
PowerShell
Python
Shipyard HPC Script
Spark
Spark SQL Statement
SQL Statement
SSIS, SQL Server Integration Services
Stored Procedure