Connect via BI Connector for Atlas¶
On this page
Serverless instances are in preview and do not support this feature at this time. To learn more, see Serverless Instance Limitations.
You can enable the BI Connector for Atlas when you
create or
scale an M10
or larger cluster.
The MongoDB Connector for Business Intelligence for Atlas (BI Connector) is only available for M10
and
larger clusters.
The BI Connector is a powerful tool which provides users
SQL-based access to their MongoDB databases. As a result, the
BI Connector performs operations which may be CPU and memory
intensive. Given the limited hardware resources on M10
and
M20
cluster tiers, you may experience performance degradation of
the cluster when enabling the BI Connector. If this occurs,
upgrade to an M30
or larger cluster or disable the
BI Connector.
To connect to the BI Connector for Atlas:
- Click the Connect button for your cluster.
- 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.
The MongoDB Connector for Business Intelligence for Atlas (BI Connector) is only available for M10
and
larger clusters.
The BI Connector is a powerful tool which provides users
SQL-based access to their MongoDB databases. As a result, the
BI Connector performs operations which may be CPU and memory
intensive. Given the limited hardware resources on M10
and
M20
cluster tiers, you may experience performance degradation of
the cluster when enabling the BI Connector. If this occurs,
upgrade to an M30
or larger cluster or disable the
BI Connector.
Multi-Cloud Cluster Considerations¶
If you have a multi-cloud cluster,
your BI Connector connection string may include the cloud provider
type (.gcp
or .azure
). In the event of a failover in which nodes
on one cloud provider fail and requests are routed to nodes in another cloud
provider, your BI Connector connection string may change.
To mitigate this hazard, add analytics nodes to clusters deployed only in one cloud provider and set the BI Connector read preference to Analytics. This ensures that your connection string remains constant.
Connection Tutorials¶
Use the displayed information to connect from various clients using the BI Connector for Atlas:
Additional Reference¶
For more information on the MongoDB Connector for Business Intelligence, see MongoDB Connector for BI Manual.