Skip to content

Data Connectors

Bold Reports Data Connectors: Connect to 25+ Data Sources

The Bold Reports report designer includes 25+ built-in data connectors for relational databases, cloud data warehouses, NoSQL stores, search engines, flat files, and REST/OData APIs, with no custom code required for standard connections. Sources without a dedicated connector are reached through the ODBC, OLE DB, or CData connectors. Every connector below links to a step-by-step setup guide.

Data Connectors
  • 25+ Connectors

    Built-in connectors ready to use

  • Any Environment

    Works across cloud and on-premises

  • Zero Code

    Configure connections without coding

  • 250+ Systems

    Extend connectivity through CData

Trusted by leading companies

  • johnson-and-johnson-logo
  • schneider-electric-logo
  • bridgestone-logo
  • siemens-logo
  • verizon-logo
  • hp-logo
  • fidelity-investments
  • intel-logo

How it works

How do I connect a data source with no code?

From picking a source to a finished report, the whole setup happens inside the designer.

  1. Pick a connector

    Choose your data source from the report designer's connector list.

  2. Enter connection details

    Fill in the connection dialog, no custom code or drivers to install.

  3. Build your report

    Your data source is ready to bind to tables, charts, and other report items.

Get the Details You Need

A closer look at four of the most widely used connectors on this page.

  • CData

    Access 250+ additional systems and applications through CData's extensive driver library.

  • XML

    Report directly on structured XML data sources and feeds without conversion.

  • Snowflake

    Cloud-native data platform for warehousing and analytics.

  • ODBC

    Connect to any ODBC-compliant data source using a standard driver connection.

Why connect here

Connecting your data helps you

A consistent connection experience across every data source, built into the report designer.

  1. No Custom Code

    Skip the code

    Standard connections are configured through the report designer's dialogs, no custom code required.

  2. Built-In Security

    Secure credentials

    AWS Secrets Manager retrieves connection credentials securely instead of storing them in plain text.

  3. Shared Data Sources

    Reuse connections

    Shared data sources let one configured connection power multiple reports without reconfiguring it.

All Data Connectors

27 connectors

Relational Databases

Standard on-premises and self-managed SQL engines for transactional and operational reporting. Connect directly with native drivers, no middleware required.

  • Microsoft SQL Server

    Connect to Microsoft's relational database engine for enterprise reporting.

  • MySQL

    Open-source relational database, widely used for web and business applications.

  • PostgreSQL

    Open-source object-relational database with advanced SQL compliance.

  • Oracle

    Connect to Oracle Database for enterprise-grade relational reporting.

  • MariaDB

    Open-source relational database, drop-in compatible with MySQL.

  • MemSQL

    Distributed SQL database built for real-time analytics at scale.

Cloud Data Warehouses & Managed Databases

Managed and elastic data platforms across AWS, Azure, and Google Cloud. Scale storage and compute independently without managing infrastructure.

  • Azure SQL Data Warehouse

    Microsoft's cloud-scale relational data warehouse.

  • Amazon RDS

    Managed relational database service across multiple engines.

  • Amazon Aurora

    MySQL- and PostgreSQL-compatible cloud database built for high throughput.

  • Amazon Redshift

    Fully managed, petabyte-scale cloud data warehouse.

  • Google Cloud SQL

    Fully managed relational database service on Google Cloud.

  • Google BigQuery

    Serverless, highly scalable enterprise data warehouse

  • Snowflake

    Cloud-native data platform for warehousing and analytics.

NoSQL & Search

Document stores and search/analytics engines for schema-flexible and log-heavy data. Report on unstructured and semi-structured records alongside relational sources.

  • MongoDB

    Document-oriented NoSQL database for flexible, schema-less data.

  • Elastic Search

    Distributed search and analytics engine for log and text-heavy data.

  • AWS OpenSearch

    Managed, open-source search and analytics suite.

Files & Flat Data

Bold Reports connects to four structured file formats directly (CSV, Excel XLS/XLSX, JSON, and XML), no database required. Good for one-off reports or data exported from other systems.

  • CSV

    Report directly on comma-separated value files.

  • Excel

    Connect to Excel workbooks (XLS/XLSX) as a report data source.

  • JSON

    Report on structured JSON data from files or endpoints.

  • XML

    Report on structured XML data sources.

APIs & Universal Connectivity

Standard protocols for connecting to cloud or on-premises sources. Built for systems without a dedicated Bold Reports connector, and the source must be ODBC-compliant, OLE DB-compliant, OData-compliant, a REST endpoint, or covered by CData's 250+ systems.

  • Web API (REST)

    Connect reports directly to REST API endpoints.

  • OData

    Query OData-compliant services as a report data source.

  • OLEDB

    Connect to any OLE DB–compliant data source.

  • ODBC

    Connect to any ODBC-compliant data source.

  • CData

    Access 250+ additional systems through CData's driver library.

Analytics & Security

Analytical cubes and credential management services for governed enterprise reporting. Supports multidimensional models and secure connection handling.

  • Microsoft SQL Server Analysis Services (SSAS)

    Connect to OLAP cubes and tabular models for multidimensional reporting.

  • AWS Secrets Manager

    Retrieve database credentials securely at connection time instead of storing them in plain text.

Get the Details You Need

Frequently Asked Questions

Can Bold Reports use SQL Server and Excel data in the same report designer?

Bold Reports includes both a Microsoft SQL Server connector and an Excel connector for XLS and XLSX workbooks. Each is set up as its own data source from the report designer's connector list, and each connector links to a setup guide in the documentation.

How do I connect a report to SQL Server in Bold Reports?

Bold Reports connects to Microsoft SQL Server through a native driver with no middleware. Choose Microsoft SQL Server from the connector list, enter the connection details, and bind the data source to tables, charts, and other report items.

What data sources should an enterprise reporting tool support?

An enterprise reporting tool should cover relational databases, cloud warehouses, NoSQL stores, files, REST and OData APIs, and analytical cubes. Bold Reports provides 25+ built-in connectors across those groups, including Microsoft SQL Server Analysis Services (SSAS), plus 250+ additional systems through CData.

How do I create reports from Snowflake, BigQuery or MongoDB data in Bold Reports?

Bold Reports includes Snowflake, Google BigQuery, and MongoDB connectors. Pick the connector, enter the connection details, then bind the data source to tables, charts, and other report items in the designer.

What data sources does Bold Reports support?

Bold Reports supports a wide range of data connectors, including major relational databases (SQL Server, MySQL, PostgreSQL, Oracle), cloud warehouses (Snowflake, BigQuery, Redshift), NoSQL sources (MongoDB, Elastic Search), and file/API formats (CSV, Excel, JSON, XML, REST, OData).

Does Bold Reports support NoSQL databases like MongoDB?

Yes, MongoDB is a supported data connector in Bold Reports Designer.

Where can I find setup instructions for a specific connector?

Every connector on this page links to a step-by-step guide in the Bold Reports documentation.

Does Bold Reports support cloud data warehouses like Amazon Redshift?

Yes. Amazon Redshift is a supported cloud data warehouse connector, alongside Azure SQL Data Warehouse, Google BigQuery, and Snowflake.

Does Bold Reports support REST APIs and OData services?

Yes. Bold Reports connects to Web API (REST) endpoints and OData-compliant services as standard data sources.

How do I connect Bold Reports to Snowflake or Amazon Redshift?

Bold Reports has dedicated Snowflake and Amazon Redshift connectors. Pick the connector in the report designer, fill in the connection dialog with no custom code or drivers to install, and bind the data source to report items.

Does Bold Reports support OData, ODBC, and OLE DB data sources?

Yes. Bold Reports has separate OData, ODBC, and OLEDB connectors. OData queries OData-compliant services, while ODBC and OLEDB connect to any ODBC-compliant or OLE DB-compliant source.

What are the best practices for shared data sources in Bold Reports?

In Bold Reports, configure a connection once as a shared data source and reuse it across multiple reports instead of reconfiguring it each time. For credentials, pair the connection with AWS Secrets Manager so database credentials are retrieved at connection time instead of stored in plain text.

Can I connect Bold Reports to Snowflake or BigQuery?

Yes. Snowflake and Google BigQuery are both supported connectors with dedicated setup documentation.

Can I reuse a data source across multiple reports?

Yes, Bold Reports supports shared data sources so a single configured connection can be reused across reports without reconfiguring it each time.

Is coding required to connect a data source in Bold Reports?

No. Standard connections to any of the supported sources are configured through the report designer’s connection dialogs, with no custom code required.

Can I connect to both on-premises and cloud data sources in the same report designer?

Yes. Bold Reports supports on-premises databases (SQL Server, MySQL, PostgreSQL, Oracle) and cloud sources (Amazon RDS, Google Cloud SQL, Snowflake) side by side.

How do I connect to a database that isn’t directly listed as a connector?

Use the ODBC, OLEDB, or CData connectors to reach additional ODBC/OLE DB-compliant systems or the 250+ systems supported through CData’s driver library.

Does Bold Reports support secure credential management for data connections?

Yes. AWS Secrets Manager is a supported connector for retrieving database credentials securely at connection time instead of storing them in plain text.

Ready to get started?

Ready to Modernize Reporting the Modern Way?

From migrating legacy reports to embedding reporting in applications, Bold Reports helps you move forward with confidence.

No credit card required.