Connections

Connections are used by Loome Integrate within tasks to facilitate the successful execution of jobs.

The purpose of connections can vary drastically, often being something as simple as a data source or target but also allowing for more specific uses such as creating high performance computing clusters, submitting Hadoop scripts and manipulating unstructured blob data in the cloud to name a few.

Our Supported Connections

This is a list of our supported connections and whether they can be used as a source, target or incrementally in data migrations.

Note

Please note that this is only a summary. Please read about each connection on their linked pages for important notes, their other task types, guides and further information. You can find each connection here.

Connection	Source	Target	Incremental Source	Incremental Target
Access	✔ Supported	❌ Not Supported	✔ Supported	❌ Not Supported
Aconex Application	✔ Supported	❌ Not Supported	✔ Supported	❌ Not Supported
Aconex V2 Application	✔ Supported	❌ Not Supported	✔ Supported	❌ Not Supported
Amazon DynamoDB	✔ Supported	✔ Supported	✔ Supported	❌ Not Supported
Amazon S3 Account	✔ Supported	✔ Supported	❌ Not Supported	❌ Not Supported
Azure Batch Account	Azure Batch Task Type
Azure Blob Storage	✔ Supported	✔ Supported	❌ Not Supported	❌ Not Supported
Azure Active Directory Application	Azure Data Factory Task Type
Azure Data Lake Storage Gen2	✔ Supported	✔ Supported	❌ Not Supported	✔ Supported
Azure Synapse SQL	✔ Supported	✔ Supported	✔ Supported	✔ Supported
Azure Synapse Spark Pool	Spark SQL Task Type
Azure Table Storage	✔ Supported	✔ Supported	❌ Not Supported	❌ Not Supported
Bing Ads	✔ Supported	❌ Not Supported	❌ Not Supported	❌ Not Supported
Bing Search	✔ Supported	❌ Not Supported	❌ Not Supported	❌ Not Supported
Cassandra	✔ Supported	❌ Not Supported	✔ Supported	❌ Not Supported
Couchbase	✔ Supported	❌ Not Supported	✔ Supported	❌ Not Supported
DataBricks	❌ Not Supported	✔ Supported	❌ Not Supported	❌ Not Supported
Dynamics CRM	✔ Supported	❌ Not Supported	✔ Supported	❌ Not Supported
Excel	✔ Supported	❌ Not Supported	❌ Not Supported	❌ Not Supported
Facebook	✔ Supported	❌ Not Supported	❌ Not Supported	❌ Not Supported
FTP	✔ Supported	❌ Not Supported	❌ Not Supported	❌ Not Supported
Git Repository	✔ Supported	✔ Supported	❌ Not Supported	❌ Not Supported
Google Adwords	✔ Supported	❌ Not Supported	❌ Not Supported	❌ Not Supported
Google Analytics	✔ Supported	❌ Not Supported	❌ Not Supported	❌ Not Supported
Google BigQuery	✔ Supported	✔ Supported	❌ Not Supported	❌ Not Supported
Google Cloud Storage Bucket	✔ Supported	✔ Supported	❌ Not Supported	❌ Not Supported
HBase	✔ Supported	❌ Not Supported	✔ Supported	❌ Not Supported
HDFS	❌ Not Supported	✔ Supported	❌ Not Supported	❌ Not Supported
Hive	Hive Task Type
HPCC	✔ Supported	❌ Not Supported	❌ Not Supported	❌ Not Supported
HubSpot	✔ Supported	❌ Not Supported	❌ Not Supported	❌ Not Supported
JSON	✔ Supported	❌ Not Supported	❌ Not Supported	❌ Not Supported
JIRA	✔ Supported	✔ Supported	❌ Not Supported	❌ Not Supported
Livy	Spark Task Type
MailChimp	✔ Supported	❌ Not Supported	❌ Not Supported	❌ Not Supported
Marketo	✔ Supported	❌ Not Supported	✔ Supported	❌ Not Supported
Microfocus ALM	✔ Supported	❌ Not Supported	✔ Supported	❌ Not Supported
Microsoft Dataverse	✔ Supported	❌ Not Supported	✔ Supported	❌ Not Supported
Microsoft Genomics Service	MSGen Task Type
Microsoft Graph	✔ Supported	❌ Not Supported	❌ Not Supported	❌ Not Supported
Microsoft SQL Server	✔ Supported	✔ Supported	✔ Supported	✔ Supported
MongoDB	✔ Supported	✔ Supported	❌ Not Supported	❌ Not Supported
MYOB AccountRight	✔ Supported	❌ Not Supported	❌ Not Supported	❌ Not Supported
MySQL	✔ Supported	❌ Not Supported	✔ Supported	❌ Not Supported
NationBuilder	✔ Supported	❌ Not Supported	❌ Not Supported	❌ Not Supported
OData	✔ Supported	❌ Not Supported	❌ Not Supported	❌ Not Supported
ODBC	✔ Supported	❌ Not Supported	✔ Supported	❌ Not Supported
PostgreSQL	✔ Supported	❌ Not Supported	✔ Supported	❌ Not Supported
SAGE 50 UK	✔ Supported	❌ Not Supported	❌ Not Supported	❌ Not Supported
Salesforce	✔ Supported	❌ Not Supported	❌ Not Supported	❌ Not Supported
Salesforce Chatter	✔ Supported	❌ Not Supported	❌ Not Supported	❌ Not Supported
Salesforce Marketing Cloud	✔ Supported	❌ Not Supported	❌ Not Supported	❌ Not Supported
SAP	✔ Supported	❌ Not Supported	❌ Not Supported	❌ Not Supported
SharePoint	✔ Supported	❌ Not Supported	❌ Not Supported	❌ Not Supported
Snowflake Data Warehouse	✔ Supported	✔ Supported	✔ Supported	✔ Supported
SFTP	✔ Supported	❌ Not Supported	❌ Not Supported	❌ Not Supported
Sugar CRM	✔ Supported	❌ Not Supported	❌ Not Supported	❌ Not Supported
Square	✔ Supported	❌ Not Supported	❌ Not Supported	❌ Not Supported
RSS	✔ Supported	❌ Not Supported	❌ Not Supported	❌ Not Supported
xBase	✔ Supported	❌ Not Supported	❌ Not Supported	❌ Not Supported
XERO	✔ Supported	❌ Not Supported	❌ Not Supported	❌ Not Supported
XML	✔ Supported	❌ Not Supported	❌ Not Supported	❌ Not Supported
YouTube Analytics	✔ Supported	❌ Not Supported	❌ Not Supported	❌ Not Supported
YouTube Data	✔ Supported	❌ Not Supported	❌ Not Supported	❌ Not Supported
Zoho CRM	✔ Supported	❌ Not Supported	❌ Not Supported	❌ Not Supported
Zuora	✔ Supported	❌ Not Supported	✔ Supported	❌ Not Supported

Beta Connections

These are connection types in Loome Integrate that we are still working on, you may experience some issues.

These connections can be used as a source in your data migrations.

To use beta connections, a group admin will need to enable “Beta Tenant” in the Manage Tenant page of Loome Integrate.

OLEDB
Master Data Services
QuickBooks
QuickBooks Online
Exact Online
Intacct
Freshbooks
Reckon
Office365
Basecamp
Smartsheet
Dynamics NAV
XMLA
NetSuite
ServiceNow
Google BigQuery
Active Directory
Google Spreadsheets
CSV
Twitter
Facebook
LDAP
OFX
SharePoint
Email
EBay
PayPal
Stripe
Quandl
Twilio
Gmail
Exchange
Google Search
Microsoft Project
Flat Files
Amazon Redshift
Authorize.Net
Bing Ads
Box
Cloudant
CosmosDB
DoubleClick CM
DoubleClick FP
Dynamics 365 Business Central
Dynamics 365 Finance and Operations
Highrise
Dynamics 365 Sales
Elasticsearch
ETrade
Google Calendar
Google Contacts
Google Directory
Google Drive
Kintone
Open Exchange Rates
Oracle SalesCloud
Eloqua
QB POS
Redis
REST
SparkSQL
SuiteCRM
Google BigQuery
SendGrid
Magento
Dynamics GP