Docs Menu
Docs Home
/
MongoDB Atlas
/ / /

Connect from MySQL Workbench

Important

Feature unavailable in Serverless Instances

Serverless instances don't support this feature at this time. To learn more, see Serverless Instance Limitations.

For M10+ clusters that have enabled the BI Connector for Atlas, the Connect dialog box provides the details to connect via the BI Connector for Atlas.

To connect to the BI Connector for Atlas:

1

Click the Connect button for your cluster.

2

Select Standard Connection and click Choose a connection method.

3

Click Connect Your Business Intelligence Tool and use the provided connection information to connect with your BI tool.

For more information on connecting to the BI Connector for Atlas, see Connection Tutorials.

  • Atlas cluster with BI Connector for Atlas enabled

  • MySQL Workbench 6.3 or later

    Note

    Versions of MySQL Workbench that are compatible with MySQL server version 5.7 are also compatible with the BI Connector for Atlas.

    We recommend that you use a MySQL Workbench version between and including versions 6.3 and 8.0.31 to guarantee compatibility.

The following tutorial outlines the steps to connect using MySQL Workbench 6.3. Atlas supports both the Community and Commercial Editions.

1

Start the MySQL Workbench 6.3.

2
  1. From the Welcome page, click on the plus sign (+):

    Alternatively, you can create a new connection from the Manage Connections ... screen.

  2. Enter the name for your connection.

  3. Configure the parameters for the connection. In the Parameters section, update the following fields:

    Field Name
    Description
    Hostname
    Enter the Hostname specified in the Atlas connect dialog box.
    Port
    Enter the Port specified in the Atlas connect dialog box.
    Username

    Enter either the user specified in the Atlas connect dialog box or a different database user for the cluster.

    The user is specified in the format:

    <username>?source=<database-name>

    where the <database-name> is the authentication database for the user.

    Password
    Store the password in the keychain.
    Default Schema
    Optional. The name of a database in the cluster to connect.
  4. Configure the SSL settings for the connection. In the SSL section, update the following field:

    Field Name
    Description
    Use SSL
    Select If available.
  5. Configure the advanced settings for the connection. In the Advanced section, update the following field:

    Field Name
    Description
    Enable Cleartext Authentication Plugin
    Select.
3

If the connection is successful, click OK and Close the Connection setup screen and return to the Welcome page.

If the connection fails, check the settings, including the MongoDB database user credentials and the IP access list.

4

From the Welcome page, double-click on the newly created connection to connect and open the SQL Editor.

For more information on the MongoDB Connector for Business Intelligence, see MongoDB Connector for BI Manual.

← Qlik Sense