Drag and Drop Builder
Global Filters and Saved Views
Drill Down and Launch Out
Visualizations
Content Blocks
In-Memory Caching
Mobile Interface
Codeless Report Building
Custom Formulas and Criteria
Chart and Dataset Builder
Data Blending
Stored Procedures
Embeddable Dashboards and Reports
Direct Link
Scheduled Emails
Public View Embeds
Display Mode (TV)
Tenant Level Security
Dynamic Data Sources
Role Based Security
Authentication Modes
Team, Private, Favorites Library
Folder Hierarchy
Folder and Report Security
Guest/Anonymous Library
Customizable Interface
Multi-lingual
Custom Domain
Seamless Sign-On
Table and View Relationships
Data Transformation
Column Level Security
Data Field Organization
API for Automations
Production and Dev Environments
Audit Logs
BI Guides
Contact
Customer Portal
ODBC Driver
- Databases
Connect Yurbi to any data source using the ODBC Driver, providing a flexible way to access and analyze your data for comprehensive reporting and dashboard creation.
About
The ODBC (Open Database Connectivity) driver provides a standard interface for connecting to various database management systems, enabling seamless communication between applications and databases. With ODBC, users can access data from multiple sources using a consistent set of commands, which simplifies the process of integrating and analyzing data. Yurbi supports ODBC drivers on Windows Server 2016 and above, as well as various Debian and Fedora Linux distributions, allowing users to connect to a wide array of databases effortlessly.
Supported Versions
ODBC drivers are compatible with various database systems, and the support generally includes any ODBC-compliant driver that is compatible with the operating system in use. Users should ensure they are using the latest version of their ODBC driver for optimal performance and security.
Integration Capabilities
- Live query read-only access to your data source
- Support for table owner/schema
- Compatibility with Views
- Dynamic Data Source Connection Strings
Requirements
- ODBC driver installed and configured on the server
- DSN configured with proper credentials
- Network/Firewall access to the database instance
- User ID with read-only access permissions
Support
Contact Us 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?
Yurbi 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 Yurbi after making changes in my database?
Yurbi 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 Yurbi cause any damage or harm to my data source?
Yurbi 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.
