SQL Database 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
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
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
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.
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
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
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
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
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.
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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)
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
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
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
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
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
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