
Dremio
- Cloud Databases
Integrate DashboardFox with Dremio to access and analyze your data from various sources, allowing for powerful reporting and dashboard creation from a unified data view.
About
Dremio is a powerful data-as-a-service platform that simplifies the process of accessing, transforming, and analyzing data from various sources. It provides a unified interface for data discovery and analytics, allowing organizations to connect to multiple data sources seamlessly. Dremio’s innovative architecture enables users to run fast queries on data without the need for extensive data movement or duplication. When integrated with DashboardFox, users can access real-time data from Dremio to create detailed reports and interactive dashboards. Additionally, DashboardFox support thew Dremio user impersonation, allowing users to pass their user ID for enhanced security and access control during data queries.
Supported Versions
Dremio operates as a continuously updated service rather than traditional versions.
Integration Capabilities
- Live query read-only access to your data source
- Support for table owner/schema
- Compatibility with Views
- Support for various data formats and sources
- Dynamic Data Source Connection Strings
- User impersonation for enhanced security and access control
Requirements
- Dremio ODBC driver installed and configured
- Network/Firewall access to the Dremio instance
- User ID with read-only access permissions
- Recommend use of reflections to improve performance
Support
Integration FAQs
-
How do I get started with this integration?
If you have admin privileges, navigate to Settings > Integration and select Create a New App for the data source you want to use.
-
What types of data can I access through this integration?
DashboardFox generates SQL queries dynamically using the official database driver, ODBC driver, or API endpoint. Through this integration, you can access a variety of structured data from your data source, such as tables, views, and results from stored procedures in MSSQL and MySQL.
-
How do I refresh the data in DashboardFox after making changes in my database?
DashboardFox performs live queries against your data source, ensuring that every time a report or dashboard is executed, it retrieves the most up-to-date data available. This means you always have access to the latest information without needing to manually refresh anything.
-
Can DashboardFox cause any damage or harm to my data source?
DashboardFox performs read-only queries against the connected data source, meaning it cannot write or modify any data. However, if queries are designed to pull excessive amounts of data, they can consume significant resources, potentially leading to timeouts or increased load that may affect overall performance.