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
Microsoft SQL Server
- Databases
Seamlessly connect Yurbi to your on-premise Microsoft SQL Server databases, enabling real-time access to your data for comprehensive reporting and insightful dashboards.
About
Microsoft SQL Server is a powerful database tool that helps businesses store and manage their data efficiently. It allows users to easily access, analyze, and share information, making it suitable for organizations of all sizes. With features that ensure data security and reliability, SQL Server provides a solid foundation for making informed decisions. When connected with Yurbi, you can use real-time data from SQL Server to create detailed reports and engaging dashboards that drive your business forward.
Supported Versions
- 2016 and above
Integration Capabilities
- Live query read-only access to your data source
- Support for table owner/schema
- Compatibility with Views
- Integration with Stored Procedures
- Dynamic Data Source Connection Strings
- Support for NOLOCKS
Requirements
- SQL User ID with read-only access
- Network/Firewall access to the database instance
- SQL Browser Service must be running
- SQL TCP/IP protocol enabled
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.
