This will create an initial collection in your new database. Not only will you be asked to give your new database a name, but also a collection name. You will then be prompted to name your new database ( Figure B).įigure B Naming our new database in Compass. In the resulting window, click Create database. Log into Compass and then click the Databases entry in the sidebar ( Figure A).įigure A The Compass GUI makes working with your databases incredibly simple. The first thing we’ll do is create a database that will house our collection. With those two pieces of the puzzle taken care of, it’s time to create your first database. I will assume you’ve already deployed MongoDB and Compass (read the how-to in the link above for more information). Collections are to MongoDB what a table is to a relational database (such as MySQL). For those who don’t know, a collection is a NoSQL term that refers to a group of MongoDB documents. I want to show you just how easy it is to create a MongoDB database and then add a collection. SEE: Hiring Kit: Database engineer (TechRepublic Premium) The Compass GUI makes it very easy to create and manage your MongoDB databases. Now that you have the MongoDB Compass GUI installed, you might be wondering what you can do with it? The answer is pretty simple-just about anything you need. The next SQL Server: Interview with Asad Khan of Microsoft How to set, change, and recover your MySQL root password How to create a virtual machine in Google Cloud Platform Image: Shutterstock More about data centersĭata warehouse services: What to consider before choosing a vendor Jack Wallen shows you how easy it is to create a MongoDB database and collection using the Compass GUI. By combining Atlas’s powerful Data Federation capabilities with Power BI’s advanced analytics and visualization tools, you can easily create comprehensive dashboards that offer valuable insights into your data, regardless of where it is stored.How to create a database and add a collection with MongoDB GUI Compass The Power BI Connector’s integration with MongoDB Atlas enables you to seamlessly model, analyze, and share insightful dashboards that are built from multiple data sources. With no delays caused by data duplication, you can stay ahead of the curve by unlocking real-time insights on Atlas data that are relevant to your business. Gain real-time insights on live application dataīy using the Power BI Connector to connect directly to MongoDB Atlas, you can build up-to-date dashboards in Power BI Desktop and scale insights to your organization through Power BI Service with ease. With its SQL-92 compatible dialect, mongosql, you can tailor your data to fit any requirements by transforming heavily nested document data to fit your exact needs, all from your Power Query dashboard. The Atlas Power BI Connector makes it easy to model document data with native Power BI features and data modeling capabilities. Effortlessly model document data with Power Query Let’s take a deeper look into how the Atlas Power BI Connector can unlock comprehensive, real-time insights on live application data that will help take your business to the next level. Supporting Microsoft’s Intelligent Data Platform, this integration bridges the gap between Developers and Analytics teams, allowing analysts who rely on Power BI for insights to natively transform, analyze, and share dashboards that incorporate live MongoDB Atlas data.Īvailable in June, the Atlas Power BI Connector empowers companies to harness the full power of their data like never before. Introducing MongoDB Atlas Connector for Power BI, the certified solution that facilitates real-time insights on your Atlas data directly in the Power BI interfaces that analysts know and love! We thank Alexi Antonino, Natacha Bagnard, Jad Jarouche from MongoDB, and Bob Zhang, Mahesh Prakriya, and Rajeev Jain from Microsoft for their contributions. This is a collaborative post from MongoDB and Microsoft.
0 Comments
Leave a Reply. |