Guides
Visit our websiteDeveloper Docs
  • Getting Started with Databrain
    • What is Databrain?
  • ❄️Onboarding & Configuration
    • 📝Sign-Up
    • ✍️Sign-In
    • ✏️Google Sign In Setup for Self-hosted app
    • 🤔Forgot password? Recover your Databrain Account
    • 🌟Onboarding
    • 💾Add a Data Source
    • 🧑Configure Tenants
    • 🆕Create a Workspace
    • 🔓Create a Private Workspace
    • 🆕Create a Dashboard
    • 💠Create a Metric
      • Create Custom Columns
      • Create a Metric using Chat Mode
      • Create a Metric using Custom SQL
    • Workspace Settings
      • General Settings
      • Access Control Settings
      • Cache Settings
      • Download Settings
    • 🗄️Explore Data
  • 🛢️Datasources
    • Connecting Data Sources to Databrain
      • Amazon Redshift
      • Snowflake
      • BigQuery
      • MySQL
      • Postgres
      • MongoDB
      • ElasticSearch
      • DataBricks
      • ClickHouse
      • MSSQL
      • Amazon S3
      • CSV
      • Firebolt
      • SingleStore
      • Athena
    • Allow Access to our IP
    • Add a Data Source
    • Configure Tenants
    • How to Sync a Data Source
    • Edit Tenancy
    • Create a Datamart
    • Semantic Layer
    • Create a Data App
    • Creating a Custom Dataset/View in a Multi-Datasource Environment
  • Workspace
    • Multi Datasource Workspace
  • 🔍DASHBOARDS
    • Edit a Dashboard
    • Share Dashboard
    • Dashboard Settings
    • Create/Modify Dashboard Filter
      • Dashboard Filter - Variable Apply On
      • Add LHS and RHS custom sql support for dashboard filter
    • Customize Layout
    • Adding Elements to Dashboard
    • Import/Export Dashboard
    • Report Scheduler
  • 📉METRIC
    • Edit a Metric
    • Joins , Filter, Sort, Group By
    • Complex Filter
    • Apply Metric Filter
      • Metric Filter - Variable
      • Metric Filter - Custom
    • Switch X axis and Switch Y axis
    • Group By
    • Footnote and Long Description
    • Dynamic Property
    • Archive/Unarchive Metric Card
    • Download Metric Card
    • Download Underlying Data
    • Metric Summary
    • Metric Expression for Single Value Card
    • AI Summary
    • Merge Metrics
    • Section Filters
    • View Unpublished Metrics
  • 📊VISUALIZATIONS - ACTIONS & APPEARANCE
    • Chart Actions
      • Chart Click Action
      • Chart Click Action with Metric
      • Card Click Action
      • Drill Down
      • Cross Dashboard Drill Down
    • Chart Appearance
      • Chart-Specific Appearance Options
  • 🛢️PREVIEW OF DASHBOARDS
    • Email Settings for Scheduled Reports
    • Scheduled Reports for End User
  • 🔍FILTERS
    • Dashboard Filter
    • Metric Filter
    • App filter
  • 💡Features
    • Python Editor Console
    • Custom SQL Console
    • Custom SQL Query Guidelines
  • 🏢Integrating Plugin
    • ✳️Get an auth token
    • 🙏Get a guest token
  • 🛃THEMEING & CUSTOMIZATION
    • 🎨Creating a theme
    • 🖼️View the theme in action
    • ⚙️Reset a saved theme
  • 📊Metric Component (upto version v0.11.15)
    • ✨Quick start
  • 🕸️Web Components
    • ✨Quick start
    • ⚛️Framework Specific Guide
  • 🚀Product Changelog
  • 🤳Self Hosted Changelog
Powered by GitBook
On this page
  1. Datasources
  2. Connecting Data Sources to Databrain

MongoDB

PreviousPostgresNextElasticSearch

Last updated 18 hours ago

Getting Started with MongoDB BI Connector Configuration

Requirements:

  • Active MongoDB BI Connector instance.

  • Allow connections from Databrain to your MongoDB BI Connector.

    • For details on setting up IP whitelisting and ensuring secure connectivity, refer to our guide on

  • Choose the Databrain Workspace to which you wish to connect the data.

Setup Guide:

  1. Ensure Connector Accessibility:

    • Ensure your MongoDB BI Connector is active and accessible from the machine running Databrain.

    • Accessibility is dependent on your MongoDB user privileges and network settings. The easiest way to verify if Databrain can connect to your MongoDB BI Connector is via the check connection tool in the UI. For detailed setup and permissions, refer to the MongoDB BI Connector documentation.

  2. Fill Up Connection Info:

    • Provide the necessary information to connect to your MongoDB BI Connector:

      • Integration Name: [Pick a name to help you identify this integration in Databrain]

      • Host: [Enter your MongoDB BI connector Hostname]

      • Port: 3306 (or enter your specific MongoDB BI Connector Port)

      • Username: [Enter your MongoDB BI Connector User]

      • Password: [Enter the password associated with the username]

Encryption:

  • Ensure you have SSL/TLS set up for your MongoDB BI Connector if you require encrypted connections from Databrain for enhanced security.

Permissions:

  • Sync the BI connector with intervals, based on schema change frequency.

  • Whitelist the IP address.

  • Grant read access to schemas (usage) and tables, noting that access to only tables may not suffice in certain databases.

Replace the placeholders inside the square brackets with actual values when filling in the details.

Locating the Configuration Details in MongoDB BI Connector

  1. Integration Name:

    • This is a custom name you decide for identification within Databrain. Choose a name that's relevant and descriptive for your MongoDB BI Connector source.

  2. Host:

    • This is the server address where your MongoDB BI Connector is running. For remote servers, it would be the IP address or domain name of the server.

    • Check the MongoDB BI Connector's configuration or startup parameters to confirm the host details.

  3. Port:

    • By default, MongoDB BI Connector listens on port 3306. However, this might be different based on your setup.

    • Confirm the specific port by checking the BI Connector's configuration or the command-line arguments used to start it.

  4. Username:

    • The MongoDB BI Connector uses the MongoDB database's authentication when set up with authentication. You'd use the same credentials as those to connect to your MongoDB cluster.

    • If you're not sure about the credentials, consult with your MongoDB administrator or the person who set up the BI Connector.

  5. Password:

    • The password associated with the username. This would be the same password used for the MongoDB cluster when authentication is enabled.

    • For security reasons, passwords are typically not displayed in configurations. Ensure you have it stored securely or consult your MongoDB administrator if unsure.

  6. Permissions:

    • To synchronize the schema in a BI connector when auto-sync is not enabled, it's necessary to manually configure the auto-sync interval. This interval should be adjusted based on the frequency of schema changes; if changes occur frequently, a shorter interval should be set.

🛢️
Allow Access to our IP