Connectors for Connected Apps

Etlworks includes a wide range of connectors for Connected Apps—cloud-based platforms such as Salesforce, HubSpot, Marketo, and many others. These connectors allow you to work with third-party SaaS platforms as if they were relational databases, making integration fast, consistent, and intuitive.

How Connected App Connectors Work

While these platforms are accessed internally via their APIs, Etlworks abstracts away the complexity by exposing them as:

• Tables

• Views

• Stored procedures

This means you can use the same flows, and SQL92 compatible queries that you would with traditional databases, making it easy to integrate data from SaaS apps into your pipelines.

Examples of Supported Connected Apps

Etlworks includes hundreds of connectors for connected apps. Here are some of the examples:

• Salesforce
• Salesforce Marketing Cloud
• Salesforce Pardot
• FinancialForce
• Quickbooks Online
• Oracle Sales Cloud
• Marketo
• HubSpot
• NetSuite CRM & ERP
• Mailchimp
• SendGrid
• SuiteCRM
• Act CRM
• Microsoft Dynamics CRM
• Zendesk
• Magento
• eBay
• Shopify
• SAP ERP
• SAP Business One
• SAP ByDesign
• Amazon Marketplace
• OData
• Office 365
• Microsoft Exchange Connector
• GMail connector
• ZOHO apps
• Sharepoint API
• Box API
• Azure Data Lake Storage
• Excel as Database
• Excel Online
• Bing Ads
• Azure Analysis Services
• Smartsheet 
• Azure Table
• Elasticsearch
• DynamoDB
• Cassandra
• Azure CosmosDB
• Btrieve
• Couchbase
• HarperDB
• HBase

Premium Connectors

Most Connected App connectors are premium and require a small annual license fee. You can still evaluate them during your trial period, but a license is needed for production use.

Using a Connected App Connector

Once configured, a Connected App connector works just like a regular database connector. You can:

• Create source and destination connections

• Browse tables, views and fields

• Create and run flows like Connected App to Database, File to Connected App, or Connected App to Connected App, etc.

• Use wildcard processing
• Use incremental high watermark replication from and to connected apps

No additional scripting or manual API work is needed, just connect, map, and run.

Read how to work with connected apps in Etlworks.