Data Sources
Data Sources in Datalytics
Datalytics connects to a wide range of data sources, allowing you to centralize your analytics. Below is a detailed guide for every supported connection type.
Data Sources at a Glance
| Data Source | Type | Best For |
|---|---|---|
| MongoDB | NoSQL | Unstructured data, logs, and document catalogs |
| SQL Server | Relational | Enterprise data, financial, and operational records |
| PostgreSQL | Relational | Modern app databases and high-performance warehousing |
| Oracle | Relational | Mission-critical enterprise transactional systems |
| MySQL / MariaDB | Relational | Web applications, e-commerce, and open-source stacks |
| ClickHouse | Relational | High-performance real-time OLAP analytics |
| Amazon Redshift | Cloud Warehouse | Large-scale analytical queries on AWS |
| Azure Synapse | Cloud Warehouse | Enterprise analytics on Microsoft Azure |
| Snowflake | Cloud Warehouse | Scalable multi-cloud data warehouse |
| BigQuery | Cloud Warehouse | Serverless analytics on Google Cloud Platform |
| Databricks | Cloud Warehouse | Delta Lake and Spark-based analytics platform |
| REST API | API | SaaS integration and microservices |
| Salesforce | SaaS / API | CRM data via SOQL — leads, opportunities, accounts |
| Airtable | SaaS / API | Spreadsheet-database hybrid for team data |
| Amazon S3 | Cloud Storage | CSV and JSON files stored in S3 buckets |
| Elasticsearch | NoSQL | Full-text search and log analytics |
| DynamoDB | NoSQL | AWS key-value and document data |
| Redis | NoSQL | In-memory HASH key analysis |
| Google Sheets | Spreadsheet | Live spreadsheet data via Service Account or API Key |
| GitLab | Database | Deep repository analytics and project commit trends |
| File Uploads | Static Files | Ad-hoc analysis of CSV, Excel, JSON, or XML files |
| SSH Tunnel | Security | Accessing private databases behind firewalls |
Choose a data source from the sidebar or the table above to see detailed connection instructions.