Skip to Content

Supported connectors

Connect MongoDB

Connect MongoDB through the MongoDB BI Connector.

Before you start

  • You are an Admin or a Developer, or your role has the datasource Connect permission.
  • Your firewall allows Databrain’s outbound IP on the database port. The form shows the IP under Setup guide > Allow the outbound IP. See Allow Databrain’s IP.
  • You run the MongoDB BI Connector in front of your cluster. Databrain connects to the BI Connector, not to mongod.

Connect

  1. Go to Data Studio > Datasources and select Connect data source.

    Datasources page with the Connect data source button outlined
    Connect data source is at the top right of the Datasources page.
  2. Select MongoDB. You can type the name in Search connectors.

    Add datasource page with the MongoDB tile outlined
    The MongoDB tile on the Add datasource page.
  3. Fill in the form:

    FieldWhat to enter
    Datasource nameHow this datasource appears in lists and pickers, for example Production warehouse.
    HostThe BI Connector hostname.
    Username, PasswordYour MongoDB credentials. The BI Connector signs in to the cluster with them.
    PortThe BI Connector port. Usually 3306.
  4. Select Connect datasource.

Connect MongoDB form with the connect button outlined and the Setup guide on the right
Fill in the form, then select the button at the bottom. The Setup guide on the right lists the grants and where each value comes from.

Databrain checks the connection and reads your schema. You see Step 3 of 3 with Model your data. Next, create a datamart.

Where to find the values

  • Host and port: from the BI Connector configuration file or its start-up arguments.
  • The BI Connector does not detect new collections or fields by itself. After the shape of your data changes, sync the datasource.

If something goes wrong

If the check fails, the datasource stays on the form with Needs credentials. Fix the field the message names and select Connect datasource again.

  • The database did not answer in time. A firewall blocks Databrain. Allow the outbound IP on the database port.
  • The database rejected these credentials. Check the username and password, and that the user can sign in from a remote host.

On this page