Database connectors in UnifyApps provide the foundation for building robust data integration solutions. These connectors enable your organization to extract data from various database systems, transform it according to your business requirements, and load it into your destination platforms.
What Are Database Connectors?
Database connectors are pre-built integration components that establish secure, reliable connections between UnifyApps and your database systems. They handle the complexities of database communication protocols, authentication mechanisms, and data type conversions.
Supported Database Systems
UnifyApps offers native connectivity to a comprehensive range of database platforms:
Database Connector | Description | Common Use Cases |
| Open-source relational database | Application backends, analytics systems |
| Enterprise relational database | ERP systems, financial applications |
| Open-source relational database | Web applications, content management |
| Microsoft's enterprise database | Business applications, data warehousing |
| Document-oriented NoSQL database | Content repositories, real-time analytics |
| Cloud data warehouse | Analytics, reporting, data sharing |
| Column-oriented OLAP database | High-performance analytics, real-time reporting |
| Unified analytics platform | Data engineering, machine learning |
| NoSQL database service | High-scale applications, serverless architectures |
| High-performance analytical database | Real-time analytics, complex queries |
Key Features of Database Connectors
All UnifyApps database connectors share common capabilities that enable efficient and secure data integration:
Flexible Authentication Options
Direct database authentication
SSH tunneling for secure connectivity
SSL/TLS encryption support
Certificate-based authentication
Timezone Intelligence
Server timezone configuration
Automatic datetime normalization
Consistent UTC conversion
Comprehensive Data Type Support
Native handling of database-specific data types
Automatic type conversion and mapping
Support for complex types (JSON, arrays, etc.)
Multiple Ingestion Modes
Historical and Live: Full load plus ongoing changes
Live Only: New data from deployment onward
Historical Only: One-time full load
Change Data Capture (CDC)
Real-time change tracking
Minimal impact on source systems
Complete CRUD operation visibility
Business Benefits
Database connectors deliver significant value to your organization by:
Reducing Development Time: Eliminating the need to build and maintain custom database integrations
Improving Data Currency: Enabling real-time or near-real-time data synchronization
Enhancing Security: Providing secure connectivity options for sensitive data
Supporting Compliance: Maintaining comprehensive audit logs of data movement
Enabling Analytics: Making data available across your organization for insights
