Troubleshooting Connection Issues with MongoDB in Bold BI
When integrating MongoDB with Bold BI, users may occasionally encounter connection issues. To effectively troubleshoot these issues, consider the options outlined below:
SSL and SSH Configuration
Ensure that your MongoDB server is configured with SSL (Secure Sockets Layer) or SSH (Secure Shell). If your MongoDB server uses these security measures, you must configure the Bold BI MongoDB connector to match these settings.
- Verify SSL and SSH settings on your MongoDB server.
- Configure the Bold BI MongoDB connector to use SSL and SSH if required.
IP Whitelisting
Connection issues can arise if the IP address you are connecting from is not whitelisted on the MongoDB server. Make sure to add required IP address to the whitelist to allow connections especially for MongoDB hosted in cloud instances.
- Check the MongoDB server's whitelist settings.
- Add your IP address to the whitelist if it's not already included.
Server Reachability
Confirm that your MongoDB server is reachable from your network. This is particularly important if you are using MongoDB Atlas, as you should also check the connectivity to the alternate (Primary and Secondary) servers.
- Test the reachability of your MongoDB server.
- For MongoDB Atlas users, verify connectivity to primary and secondary servers.
Authentication Configuration
If your MongoDB server requires authentication, ensure that the correct credentials are set up in the Bold BI MongoDB connector.
- Check your MongoDB server for authentication requirements.
- Set the appropriate authentication credentials in the Bold BI connector.
By following these troubleshooting steps, you should be able to resolve most connection issues with MongoDB in Bold BI. If problems persist, consider consulting the official Bold BI documentation or reaching out to their support team for further assistance.
Additional References
