Supported Connectors

Integrate all of your enterprise data on a single secure platform

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.

SQL Database Connectors

Apache Hive

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

SAP SQL Anywhere

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

Firebird Database Server

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

SQLite

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

SingleStore (MemSQL)

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

Google AlloyDB

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

Amazon Redshift

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

Dremio

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

Databricks

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

IBM Informix

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

IBM DB2

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

MySQL

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

PostgreSQL

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

Oracle Database

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

Snowflake

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

Microsoft SQL Server

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

NoSQL Database Connectors

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

Azure Table Storage

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

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

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

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

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

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

Cloud File & Object Storage Connectors

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

Local File System

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

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

MongoDB 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

Azure Blob Storage

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

Amazon 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

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

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

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.