Connections

As the name implies, Connections are used by Loome Integrate Online 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.

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 ✔ 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 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 ❌ Not 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
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
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