How to connect an SQL data source to specific table in Bold BI?

When working with SQL Data sources in Bold BI, you may need to connect to specific individual tables within a data source. This can be achieved by specifying the desired table names in the Additional Connection Parameters text box during the connection process. Below are the steps to accomplish this:

Steps to Connect to Specific Tables

1. Open the Data Source Connection Dialog:

   • Navigate to the data source connection settings in Bold BI.

2. Enter the Table Name:

   • In the Additional Connection Parameters text box, enter the following syntax to specify the table you want to connect to:

specifictable=tablename or currenttable=tablename 

• Replace tablename with the actual name of the table you wish to retrieve.

3. Retrieve and List the Table:
   • By following the above method, only the mentioned table will be retrieved and listed in the tables list inside the data source for live mode and in the extract data dialog for extract mode.

Connecting to Multiple Tables

If you need to extract data from multiple tables, you can use the following syntax in the Additional Connection Parameters input field:

specifictable=table1,table2 or currenttable=table1,table2

Replace table1 and table2 with the actual names of the tables you want to connect to. This will ensure that only the specified tables are retrieved and listed.

Example

For instance, if you want to connect to tables named Sales and Customers, you would enter:

specifictable=Sales,Customers or currenttable=Sales,Customers

This will retrieve and list only the Sales and Customers tables in the data source and other tables which has that name like Sales Orders, Top 100 Customers etc…

Conclusion

By using the Additional Connection Parameters text box to specify table names, you can efficiently connect to and work with specific tables in Bold BI. This method helps in managing and organizing your data sources more effectively.

References

• Bold BI Documentation
• Connecting to specific table in MySQL data source
• Bold BI Support

By following these steps, you can streamline your data connection process and ensure that only the necessary tables are included in your analysis.