Connect from Excel¶
For M10+ clusters that have enabled the BI Connector for Atlas, the Connect dialog provides the details to connect via the BI Connector for Atlas.
Prerequisites¶
- Atlas cluster with BI Connector for Atlas enabled
- Create a system Data Source Name (DSN)
Connect from Microsoft Excel¶
1
Start Microsoft Excel.¶
Start Microsoft Excel and open a blank worksheet.
2
Use the Data Connection Wizard to set up the connection.¶
- Click the Data tab.
Select From Other Sources >
From Data Connection Wizard option.
- Select ODBC DSN from the list of data source options and click Next.
- Select the DSN created for your Atlas cluster and click Next.
- Select a database and collection from which to import data and click Next.
Save the data connection file and click Finish.
If you wish to re-use this connection in the future, you can select it from the Data > Get External Data > Existing Connections menu.
- In the final wizard window,specify a format for your worksheet. Click OK when finished.
Additional Reference¶
For more information on the MongoDB Connector for Business Intelligence, see MongoDB Connector for BI Manual.
Give Feedback