Connect to CDATA data source

The Bold Reports^® allows you to connect with CDATA data source in reports.

How to create CDATA data source

To configure the CDATA data source, follow these steps:

1. Click on the Data icon in the configuration panel.
2. In the DATA configuration panel, click on the NEW DATA button.
3. In the connection type panel, choose the CDATA data source type.

Create CDATA data source with basic options

When you create a new data, the NEW DATASOURCE panel will show up with basic options.

1. Specify the data source name without special characters in the Name field.
2. Enter a valid CDATA server or host name in the Server Name field.
3. Enter a valid CDATA username in the UserName text box.
4. Enter a valid CDATA password in the Password text box.
5. Select a database that you want to query in the listed database associated with the given CDATA server in the database drop-down.

Click on the Connect to proceed with query design pane. Now, enter the required query and execute. Its corresponding values will be shown in grid for preview.

Click Finish to save the data source with a relevant name to proceed with designing report.

Connecting to a CDATA data source through SSH Tunnel

You can now connect to a CDATA data source using a secure SSH tunnel. This enhancement provides a more robust and secure method for connecting, especially when accessing remote databases over untrusted or insecure networks.

Refer Configuring SSH tunnel for data connectors for more details.

See Also

MySQL Datasource