---
title: "Connectors | DreamFactory"
description: "DreamFactory connects with all common databases, file storage systems, and third-party APIs. Generate, secure, and deploy an API in minutes."
url: "https://www.dreamfactory.com/connectors"
---

## Supported Connectors

## Integrate all of your enterprise data on a single secure platform

* [Try API Generation for Free](https://www.dreamfactory.com/demo)
* [Get Your Free Middleware Assessment](https://www.dreamfactory.com/demo)

### DreamFactory Database Connectors:   
Secure, Scalable, Ready to Use

All DreamFactory connectors share a common foundation of enterprise-ready features:

* #### Automatic REST API Generation:  
Transform databases, file systems, and services into standardised RESTful endpoints without writing code
* #### Advanced Query Operations:  
Transform databases, file systems, and services into standardised RESTful endpoints without writing code
* #### Multi-Protocol Authentication:  
Support for OAuth, API keys, username/password, and certificate-based authentication
* #### Role-Based Access Control (RBAC):  
Apply granular permissions at the service, endpoint, and field level
* #### OpenAPI Documentation:  
Auto-generated API documentation for every connected data source
* #### Batch Operations:  
Efficient bulk create, update, and delete operations with transaction support
* #### Schema Introspection:  
Automatic discovery of tables, collections, functions, and metadata
* #### Secure Credential Management:  
Automatic discovery of tables, collections, functions, and metadata
* #### Field Selection:  
Return only the fields you need to optimize payload size and performance

## Chosen by teams in finance, manufacturing, public sector, and healthcare.

[![ExxonMobil company logo](https://www.dreamfactory.com/cdn.prod.website-files.com/64ed8da8a866be7a702fbae0/69610a8934bad6d8b1cd1b2f_exxon-mobil.svg)](https://www.dreamfactory.com/case-studies/energy-snowflake-modernization)![AkerBP company logo](https://www.dreamfactory.com/cdn.prod.website-files.com/64ed8da8a866be7a702fbae0/682e11c3117d29af0c1663a3_Aker%20BP.avif)![Miller Industries company logo](https://www.dreamfactory.com/cdn.prod.website-files.com/64ed8da8a866be7a702fbae0/6961079c699f8f5456a3a30c_thenatureconservancy.svg)![PPG Company logo](https://www.dreamfactory.com/cdn.prod.website-files.com/64ed8da8a866be7a702fbae0/696107b591ca26f2903573b7_house-of-representatives.avif)

## SQL Database Connectors

[MS SQL Server](https://www.dreamfactory.com/connectors#)

SQL Server 2016+, Azure SQL Database

#### Key Differentiators:

* Full support for stored procedures, functions, and views as API endpoints
* Native SQL Server data type handling including GEOGRAPHY, HIERARCHYID, and XML
* Windows Authentication integration for enterprise environments
* Custom Doctrine DBAL extensions for optimal PDO performance
* Transaction support with configurable isolation levels

Ideal for: Modernizing enterprise .NET applications, integrating with Azure ecosystems, exposing legacy SQL Server data to mobile and web apps

[Learn more](https://www.dreamfactory.com/connectors/sql-server)

[Snowflake](https://www.dreamfactory.com/connectors#)

Snowflake Cloud Data Warehouse (all editions)

#### Key Differentiators:

* Key-pair authentication using RSA private keys for passwordless access
* Native support for Snowflake's virtual warehouses and query optimization
* Automatic handling of semi-structured data (VARIANT, OBJECT, ARRAY types)
* Full stored procedure and user-defined function support
* Secure key file management with encrypted storage

Ideal for: Data analytics teams building dashboards, data scientists exposing ML model results, organizations building data products on Snowflake

[Learn more](https://www.dreamfactory.com/connectors/snowflake)

[MySQL](https://www.dreamfactory.com/connectors#)

MySQL 5.7+

#### Key Differentiators:

* Stored procedure parameter mapping with IN/OUT/INOUT support
* JSON column type handling (MySQL 5.7+)
* Full-text search capabilities via MySQL's MATCH AGAINST
* Maintained compatibility between MySQL and MariaDB variants
* Efficient connection pooling for high-traffic applications

Ideal for: LAMP/LEMP stack modernization, WordPress/Drupal integrations, cost-effective cloud deployments

[Learn more](https://www.dreamfactory.com/connectors/mysql)

[SAP HANA (On-Premise)](https://www.dreamfactory.com/connectors#)

SAP HANA 2.0+

#### Key Differentiators:

* Supports SQLScript procedures, table functions, and calculation views
* Optimized for in-memory, columnar performance and real-time analytics
* Native handling of spatial, LOB, and SAP-specific data types
* Integrates with SAP landscapes and enterprise authentication systems

Ideal for: High-performance, real-time processing and analytics across large enterprise datasets in SAP landscapes, with seamless exposure to front-end applications via REST APIs.

[Learn more](https://www.dreamfactory.com/connectors/sap-hana)

[Oracle](https://www.dreamfactory.com/connectors#)

Oracle Database 12c+

#### Key Differentiators:

* PL/SQL package support for grouped stored procedures
* TNS connection string compatibility for complex Oracle networks
* Native sequence management for auto-increment ID generation
* BLOB/CLOB streaming for large object handling
* Advanced data type support including XMLTYPE and user-defined types

Ideal for: Enterprise Oracle shops modernizing integrations, exposing ERP data (Oracle E-Business Suite, PeopleSoft), hybrid cloud migrations

[Learn more](https://www.dreamfactory.com/connectors/oracle)

[IBM DB2](https://www.dreamfactory.com/connectors#)

IBM DB2 10.5+

#### Key Differentiators:

* Support for DB2's unique schema architecture
* EBCDIC to ASCII conversion handling for mainframe integration
* DB2-specific SQL dialect support
* Compatible with both DB2 LUW and DB2 for z/OS

Ideal for: Mainframe modernization, connecting legacy IBM systems to cloud applications, exposing AS/400 data

[Learn more](https://www.dreamfactory.com/connectors/ibm-db2)

[Dremio](https://www.dreamfactory.com/connectors#)

Dremio 18+ (via ODBC/JDBC)

#### Key Differentiators:

* Access to virtual datasets and reflections for query acceleration
* Federated query support across multiple data sources
* Dremio's semantic layer integration
* Optimized for self-service analytics

Ideal for: Data lake analytics, reducing data warehouse costs, enabling self-service BI

[Learn more](https://www.dreamfactory.com/connectors/dremio)

[PostgreSQL](https://www.dreamfactory.com/connectors#)

PostgreSQL 9.6+

#### Key Differentiators:

* PostGIS spatial extension support for geographic data
* JSONB column operations for flexible document storage
* Array data type handling for multi-value fields
* PostgreSQL-specific functions (stored procedures, triggers)
* Advanced indexing strategies (GiST, GIN, BRIN)

Ideal for: Full-stack web applications, geospatial applications, applications requiring both relational and document data models

[Learn more](https://www.dreamfactory.com/connectors/postgresql)

[Google BigQuery](https://www.dreamfactory.com/connectors#)

Google BigQuery

#### Key Differentiators:

* Serverless, auto-scaling warehouse; almost no ops to manage
* Storage and compute separated for flexible cost control
* Built-in SQL-based ML, geospatial, and BI features
* Deep integration with Google Cloud and Workspace tools

Ideal for: TB–PB scale analytics, streaming events, multi-source data, and teams on GCP or Workspace.

[Learn more](https://www.dreamfactory.com/connectors/google-bigquery)

[Databricks](https://www.dreamfactory.com/connectors#)

Databricks Lakehouse Platform

#### Key Differentiators:

* Delta Lake table support with ACID transactions
* Unity Catalog integration for data governance
* Optimized for analytical query patterns and large datasets
* Compatibility with Apache Spark SQL

Ideal for: Data science teams serving ML models, business intelligence dashboards, data product development

[Learn more](https://www.dreamfactory.com/connectors/databricks)

[SQLite](https://www.dreamfactory.com/connectors#)

SQLite 3+

#### Key Differentiators:

* File-based database requiring no separate server process
* Zero-configuration deployment
* Ideal for embedded applications and local development
* Full ACID compliance despite lightweight footprint

Ideal for: Prototyping, testing environments, embedded applications, desktop software

[Learn more](https://www.dreamfactory.com/connectors/sqlite)

[Amazon Redshift](https://www.dreamfactory.com/connectors#)

Amazon Redshift (all node types)

#### Key Differentiators:

* Optimized for columnar storage and analytical queries
* Distribution key and sort key awareness for query optimization
* Redshift Spectrum support for querying S3 data
* Automatic workload management integration

Ideal for: Data warehouse modernization, BI tool integration, exposing aggregated analytics

[Learn more](https://www.dreamfactory.com/connectors/redshift)

[Azure Table Storage](https://www.dreamfactory.com/connectors#)

Azure Table Storage

#### Key Differentiators:

* NoSQL key-value store with PartitionKey/RowKey entity model
* Entity group transactions for atomic batch operations
* OData query protocol support
* Cost-effective alternative to Azure Cosmos DB for simple data models

Ideal for: Structured NoSQL data on Azure, high-volume table storage, cost-sensitive cloud applications

[Learn more](https://www.dreamfactory.com/connectors/azure-table-storage)

[SingleStore (MemSQL)](https://www.dreamfactory.com/connectors#)

SingleStore 7.6+

#### Key Differentiators:

* In-memory row store for real-time transactions
* Columnar disk store for analytics on the same database
* MySQL wire protocol compatibility
* Distributed SQL with horizontal scalability

Ideal for: Real-time analytics dashboards, operational intelligence, applications requiring sub-second query response

[Learn more](https://www.dreamfactory.com/connectors/singlestore)

[Google AlloyDB](https://www.dreamfactory.com/connectors#)

Google AlloyDB for PostgreSQL

#### Key Differentiators:

* Full PostgreSQL compatibility with Google Cloud optimizations
* Columnar engine integration for analytical queries
* Optimized for cloud-native, high-availability workloads
* Automatic failover and point-in-time recovery

Ideal for: Google Cloud Platform deployments, PostgreSQL migrations to GCP, hybrid transactional/analytical workloads

[Learn more](https://www.dreamfactory.com/connectors/alloydb)

[IBM Informix](https://www.dreamfactory.com/connectors#)

IBM Informix 12.10+

#### Key Differentiators:

* Time-series data support via Informix TimeSeries
* Hybrid OLTP/OLAP workload optimization
* Informix-specific data types and extensibility features
* Support for both logged and unlogged databases

Ideal for: IoT sensor data applications, financial services time-series data, retail point-of-sale systems

[Learn more](https://www.dreamfactory.com/connectors/ibm-informix)

[SAP SQL Anywhere](https://www.dreamfactory.com/connectors#)

SAP SQL Anywhere 17+

#### Key Differentiators:

* Integration with SAP business applications
* Support for remote data access and synchronization
* Embedded database mode for edge computing
* Complex join optimization for normalized SAP schemas

Ideal for: SAP ecosystem integrations, mobile/embedded SAP applications, remote office data synchronization

[Learn more](https://www.dreamfactory.com/connectors/sap-sql-anywhere)

[Firebird Database Server](https://www.dreamfactory.com/connectors#)

Firebird SQL 3+

#### Key Differentiators:

* Support for Firebird's multi-generational architecture
* Embedded and server deployment modes
* Legacy application modernization without migration
* Custom UDF (user-defined function) support

Ideal for: Modernizing legacy Firebird applications, European/Latin American enterprise systems

[Learn more](https://www.dreamfactory.com/connectors/firebird)

[Apache Hive](https://www.dreamfactory.com/connectors#)

Apache Hive (via HiveServer2)

#### Key Differentiators:

* SQL queries over HDFS and distributed file systems
* Partition pruning for optimized big data queries
* Support for complex data types (structs, arrays, maps)
* Integration with Hadoop ecosystem

Ideal for: Big data analytics, data lake queries, Hadoop ecosystem integrations

[Learn more](https://www.dreamfactory.com/connectors/apache-hive)

## NoSQL Database Connectors

### MongoDB

MongoDB 4.0+

#### Key Differentiators:

* Schema-less operations with dynamic collection support
* Aggregation pipeline framework for complex transformations
* GridFS integration for binary file storage within MongoDB
* Support for both mongodb:// and mongodb+srv:// connection strings
* Native BSON document handling with automatic JSON conversion

Ideal for: Flexible schema applications, content management systems, IoT data storage, applications requiring both database and file storage

[Learn more](https://www.dreamfactory.com/connectors/mongodb)

### Azure Document DB

Azure DocumentDB (Cosmos DB predecessor API)

#### Key Differentiators:

* Document-oriented database with automatic JSON schema mapping
* SQL-like query language for documents
* Consistent indexing across all properties
* Legacy Azure DocumentDB API compatibility

Ideal for: Migrating from Azure DocumentDB to modern APIs, document-based Azure applications

[Learn more](https://www.dreamfactory.com/connectors/azure-documentdb)

### Azure Cosmos DB

Azure Cosmos DB (NoSQL API)

#### Key Differentiators:

* Multi-model support (key-value, document, graph via different APIs)
* Global distribution with multi-region writes
* Five consistency models (strong, bounded staleness, session, consistent prefix, eventual)
* Automatic indexing with configurable policies

Ideal for: Globally distributed applications, Azure-native microservices, multi-region mobile apps

[Learn more](https://www.dreamfactory.com/connectors/cosmosdb)

### CouchDB

Apache CouchDB 3+

#### Key Differentiators:

* RESTful native architecture aligning with DreamFactory's API-first approach
* MapReduce view support for complex queries
* Multi-version concurrency control (MVCC) with document revisions
* Built-in replication protocol for distributed deployments

Ideal for: Offline-first applications, distributed systems, master-master replication scenarios

[Learn more](https://www.dreamfactory.com/connectors/couch-db)

### Amazon DynamoDB

AWS DynamoDB (all regions)

#### Key Differentiators:

* Key-value and document data model support
* Global and Local Secondary Index operations
* Conditional write operations for optimistic concurrency
* AWS SDK v3 integration with IAM role support
* Works with both provisioned and on-demand capacity modes

Ideal for: Serverless applications, microservices, gaming leaderboards, session management

[Learn more](https://www.dreamfactory.com/connectors/dynamodb)

### Apache Cassandra

Apache Cassandra 3.11+

#### Key Differentiators:

* Wide-column store optimized for write-heavy workloads
* Multi-keyspace support for logical data separation
* CQL (Cassandra Query Language) native operations
* Tunable consistency levels for CAP theorem trade-offs

Ideal for: IoT sensor data, time-series applications, high-availability systems, write-intensive workloads

[Learn more](https://www.dreamfactory.com/connectors/cassandra-db)

## Cloud File & Object Storage Connectors

### S3

AWS S3 (all regions and storage classes)

#### Key Differentiators:

* Presigned URL generation for temporary direct access
* S3 versioning and lifecycle management
* Support for all storage classes (Standard, IA, Glacier, Intelligent-Tiering)
* Server-side encryption options (SSE-S3, SSE-KMS)
* Multipart upload for files over 5GB

Ideal for: Media asset management, data lake storage, backup and archival, cloud-native file operations

[Learn more](https://www.dreamfactory.com/connectors/amazon-s3)

### Azureblob

Azure Blob Storage (all tiers)

#### Key Differentiators:

* Block, Page, and Append blob type support
* Access tier management (Hot, Cool, Archive)
* Shared Access Signature (SAS) token generation
* Azure Active Directory authentication integration
* Custom metadata on blobs and containers

Ideal for: Azure-native applications, CDN content delivery, VM disk storage (Page blobs), log aggregation (Append blobs)

[Learn more](https://www.dreamfactory.com/connectors/azure-blob)

### FTP/SFTP

FTP, FTPS, SFTP servers

#### Key Differentiators:

* SSH key authentication for SFTP (more secure than password-based)
* Support for both active and passive FTP modes
* TLS/SSL encryption for FTPS
* Directory traversal and recursive operations
* Compatibility with legacy file transfer systems

Ideal for: EDI file exchanges, legacy system integration, automated file transfer workflows, secure B2B data exchange

[Learn more](https://www.dreamfactory.com/connectors/ftp-sftp)

### Local Storage

Local server filesystem

#### Key Differentiators:

* Direct filesystem access with configurable root directory
* Symlink handling and permission management
* High-performance local I/O without network latency
* Ideal for on-premise deployments
* Container volume mount support

Ideal for: On-premise file management, container-based file services, testing environments, NAS/SAN integrations

[Learn more](https://www.dreamfactory.com/connectors/local-storage)

### GridFS

MongoDB 4.0+

#### Key Differentiators:

* Automatic file chunking for objects over 16MB
* Rich metadata storage with each file
* Stream support for memory-efficient large file handling
* Integrated with MongoDB authentication and access control
* Eliminates need for separate file storage infrastructure

Ideal for: Applications already using MongoDB, storing files with associated document data, eliminating S3 dependency

[Learn more](https://www.dreamfactory.com/connectors/gridfs)

### Rackspace Cloud Files

Rackspace Cloud Files, OpenStack Swift

#### Key Differentiators:

* OpenStack Swift API compatibility
* Akamai CDN integration for content delivery
* Multi-region support for geographic distribution
* Container-level access control
* Compatibility with private OpenStack deployments

Ideal for: Rackspace cloud customers, OpenStack environments, CDN-accelerated content delivery

[Learn more](https://www.dreamfactory.com/connectors/rackspace-cloud-files)

## CRM & SaaS Connectors

### SOAP to REST

SOAP 1.1/1.2 Web Services

#### Key Differentiators:

* Automatic WSDL parsing and function discovery
* Non-WSDL mode support for services without WSDL
* WS-Security (WSSE) authentication header support
* Complex type mapping and automatic serialization/deserialization
* Custom SOAP header support for proprietary services
* SOAP fault to REST error translation
* WSDL caching for improved performance
* Full PHP SoapClient option support (encoding, compression, timeouts)

Ideal for: Legacy SOAP service modernization, integrating with enterprise web services, transitioning SOAP-based systems to REST without rewriting

[Learn more](https://www.dreamfactory.com/connectors/soap-to-rest)

### Salesforce

Salesforce CRM (all editions)

#### Key Differentiators:

* Dual authentication modes: SOAP (username/password/security token) or OAuth 2.0
* Treat Salesforce objects (Accounts, Contacts, etc.) like database tables
* Automatic SObject schema introspection with field and relationship discovery
* Support for both Salesforce REST and SOAP APIs
* Custom WSDL upload for enterprise Salesforce instances
* Reference field (foreign key) navigation for related objects
* Configurable API version support

Ideal for: Salesforce data synchronization, custom Salesforce integrations, building Salesforce-connected applications, CRM data warehousing

[Learn more](https://www.dreamfactory.com/connectors/salesforce)

* [SQL Database Connectors](https://www.dreamfactory.com/connectors#sql-database)
* [NoSQL Database Connectors](https://www.dreamfactory.com/connectors#nosql-database)
* [Cloud File & Object Storage Connectors](https://www.dreamfactory.com/connectors#storage-connectors)
* [CRM & SaaS Connectors](https://www.dreamfactory.com/connectors#saas-connectors)

## DreamFactory Platform & Installer FAQs

* ### DreamFactory Platform & Installer FAQs  
API management software helps you manage your custom APIs, but you have to build REST APIs yourself. DreamFactory, on the other hand, is a transactional run-time server for client applications that  
   1. automatically generates REST APIs for you,  
   2. enables you to customize API behavior with server-side scripts  
   3. manages all the backend security for those APIs  
   4. returns JSON / XML from REST API calls at runtime.
* ### Why do I need to book a call with an engineer to try the product?  
Since DreamFactory is self-hosted software, we require a call with an engineer to discuss licensing, installation, and pricing. This will ensure you have all the information needed to be successful.  
If you are not ready for a call, we recommend you try our hosted trial. It's a limited version of the product, but it will give you a taste of how our automatic API generation, role-based access, and documentation works
* ### Where can I get more information about how to install DreamFactory?  
Start in our documentation, but if you don't see your answer, please ask a question in the intercom chat bubble or schedule a call with our support team.
* ### Can you tell me how DreamFactory scales?  
Yes, we have a detailed White Paper breaking down how Dreamfactory scales with performance benchmarks. Here is another White Paper specific to scaling microservices.
* ### Can I customize the APIs?  
Yes! DreamFactory offers a robust scripting engine with support for PHP, Python, and NodeJS to fully customize your APIs.