- ODBC Drivers
- Java JDBC Drivers
- ADO.NET Providers
- SQL SSIS Components
- BizTalk Adapters
- Excel Add-Ins
- Power BI Connectors
- Tableau Connectors
- PowerShell Cmdlets
- Delphi & C++Builder
- Data Sync
- API Server
Query Business b-ridge Data in MySQL Workbench
Execute MySQL queries against live Business b-ridge data from MySQL Workbench.You can use the SQL Gateway from the ODBC Driver for Business b-ridge to query Business b-ridge data through a MySQL interface. Follow the procedure below to start the MySQL remoting service of the SQL Gateway and work with live Business b-ridge data in MySQL Workbench.
Connect to Business b-ridge Data
If you have not already done so, provide values for the required connection properties in the data source name (DSN). You can use the built-in Microsoft ODBC Data Source Administrator to configure the DSN. This is also the last step of the driver installation. See the "Getting Started" chapter in the help documentation for a guide to using the Microsoft ODBC Data Source Administrator to create and configure a DSN.
When connecting to Business b-ridge, CompanyKey, ProjectKey, and SubscriptionKey are required.
To obtain the SubscriptionKey, follow the steps below:
- Log in to Business b-ridge API Protal and go to "Profile" in the "Your name" menu.
- In your subscription section click "Main Key" to retrieve their respective values.
Authenticate to Business b-ridge Account
Set the following connection properties to connect:
- CompanyKey: Set the Business b-ridge Company Key of the connection destination.
- ProjectKey: Set the Business b-ridge Project Key of the connection destination.
- SubscriptionKey: Set the value "Subscription Key".
Configure the SQL Gateway
See the SQL Gateway Overview to set up connectivity to Business b-ridge data as a virtual MySQL database. You will configure a MySQL remoting service that listens for MySQL requests from clients. The service can be configured in the SQL Gateway UI.
Query Business b-ridge from MySQL Workbench
The steps below outline connecting to the virtual Business b-ridge database created in the SQL Gateway from MySQL Workbench and issuing basic queries to work with live Business b-ridge data.
Connect to Business b-ridge through the SQL Gateway
- In MySQL Workbench, click to add a new MySQL connection.
- Name the connection (CData SQL Gateway for Business b-ridge).
- Set the Hostname, Port, and Username parameters to connect to the SQL Gateway.
- Click Store in Vault to set and store the password.
- Click Test Connection to ensure the connection is configured properly and click OK.

Query Business b-ridge Data
- Open the connection you just created (CData SQL Gateway for Business b-ridge).
- Click File -> New Query Tab.
- Write a SQL query to retrieve Business b-ridge data, like SELECT * FROM `CData BusinessBridge Sys`.CDATA;

With access to live Business b-ridge data from MySQL Workbench, you can easily query and update Business b-ridge, just like you would a MySQL database. Get started now with a free, 30-day trial of the CData ODBC Driver for Business b-ridge and the CData SQL Gateway.