If you need a tool that lets you query data across multiple sources without moving the data, Peaka is worth a look. It's a data integration platform that links relational and NoSQL databases, SaaS apps and APIs, and lets you run federated queries without having to run ETL jobs. Peaka has a range of options like API to SQL, NoSQL to SQL, and SQL to API, and self-service integration with connectors. It also has a pay-as-you-go pricing model and an enterprise plan with custom connectors and dedicated support, so it can be a good option for those who want to optimize operations and maintenance.
Another option is Airbook, a collaborative data workspace that connects to more than 150 data sources with native connectors. You can query data with SQL, Python or no-code interfaces, and it has features like collaborative workspaces, visualization, query saving and version control. Airbook supports a broad range of integrations like AWS CloudTrail, Amazon Redshift, Google Analytics and Facebook Ads, so it's good for a variety of use cases like marketing analytics and sales analytics.
If you like querying with natural language, Defog has an interesting approach. It uses fine-tuned AI models to let you query your own data on your own server without losing accuracy or compromising data privacy. Defog connects to big SQL databases and data warehouses, and it has customizable data visualization tools and row-level access control. It's a good option for companies that want to automate data queries and analysis without worrying about security.
Last, Airbyte is an open-source data integration platform that connects more than 300 structured and unstructured data sources to multiple destinations. It has features like a Connector Builder, automated schema evolution and security options like single sign-on and role-based access control. Airbyte can be deployed in a variety of ways, including cloud-hosted and self-managed options, so it's good for both big and small data integration projects.