Understanding SQL Live Mode Connections in Bold BI

Published:

SQL Live mode is a powerful feature in Bold BI that allows users to connect their dashboards directly to SQL databases. This mode provides real-time data access and supports all expressions that are compatible with SQL, ensuring that users can perform complex queries and data manipulations with ease.

Key Features of SQL Live Mode

Expression Support

SQL Live mode supports all SQL expressions, enabling users to leverage the full power of SQL within their dashboards. This means that any function or operation that can be performed in SQL can be directly used in Bold BI without any limitations.

You can refer to this Bold BI expression documentation for more clarifications.

Code View for Queries

For those who require more control over their queries, SQL data source offers a code view. This feature allows users to write and edit SQL queries manually, providing greater flexibility and precision in data retrieval and manipulation.

You can refer to this Bold BI code view mode data source documentation for more clarifications.

Utilizing Views

Views in SQL are virtual tables that consist of a SQL query. In Bold BI, users can take advantage of views to simplify complex queries, encapsulate the logic required for data analysis, and improve dashboard performance by pre-filtering data. We can create the views in the database server and use those views in Bold BI to create data sources. Please refer to the image below for better understanding.

Stored Procedures

Stored procedures are another feature supported by SQL datasource in Bold BI. These are precompiled collections of SQL statements that are stored under a name and processed as a unit. They can be used to encapsulate complex business logic, perform data modifications, and return results to the dashboard. We can create the stored procedures in the database server and use those stored procedures in Bold BI to create data sources.

Indexed Views

Indexed views are a special type of view in SQL that can significantly optimize database performance. Bold BI supports the use of indexed views, which can help in speeding up the data retrieval process for dashboards. For more information on optimizing database performance with indexed views in SQL Server, you can refer to the knowledge base article here and the related blog post here.

Materialized Views

A materialized view is a database object that stores the result of a query physically. Unlike regular views, materialized views are precomputed and stored, allowing for faster query performance by avoiding the need to recompute the result each time the view is queried.

More details on materialized views,
Summary Tables vs Materialized Views: A Comparison
Connecting Materialized Views in Bold BI - MSSQL, PostgreSQL, Oracle and Google Big Query

Uses of SQL Live Mode in Bold BI

SQL Live mode is particularly useful for scenarios where up-to-date data is crucial. It allows for real-time data analysis and reporting, which is essential for time-sensitive decision-making processes. Additionally, it is beneficial for users who need to perform ad-hoc queries or require a high level of customization in their data retrieval.

By leveraging SQL Live mode, organizations can ensure that their dashboards reflect the most current state of their data, enabling them to respond quickly to emerging trends and make informed decisions.

Additional References

For further information and best practices on using SQL Live mode in Bold BI, please refer to the following resources:

These resources provide in-depth guidance on how to effectively use SQL Live mode features to enhance the performance and capabilities of your Bold BI dashboards.

Was this article useful?

Dislike

Written by Siranjeevi Murugan

Updated:

Comments (0)