![]() ![]() This means that you would need to create a new container with Synapse Link enabled and migrate your data to the new container. Regarding Synapse Link, it can only be enabled on newly created MongoDB API containers. You can follow the steps in this Azure Cosmos DB API for MongoDB to create a pipeline that moves data from MongoDB to Azure Cosmos DB. Regarding syncing data between MongoDB and Azure Cosmos DB, you can use Azure Data Factory to move data from MongoDB to Azure Cosmos DB. You can follow the steps outlined in Configure access to Azure Cosmos DB from virtual networks (VNet) to set up the virtual network service endpoint for Azure Cosmos DB. This will allow traffic from the subnet to Azure Cosmos DB to flow through the virtual network, providing secure communication between the two resources. Then, you can enable the virtual network service endpoint for Azure Cosmos DB on the subnet. To set up the endpoint on the Azure side, you need to create a virtual network (VNet) and a subnet in the same region as your Azure Cosmos DB account. Thank you for your patience while checking on this. This will be useful for others community members with similar ask.Īnother example here but with python in case you want to explore If it does, please don't forget to mark as accept answer. Please let me know if that answers your question. Synapse Link can be enabled on newly created Mongo DB containers. Ĭurrently you can't enable Synapse Link on your existing MongoDB API containers. There is a great demo on YouTube by Our Azure Cosmos DB product group on how to use the Azure Synapse link for Azure Cosmos DB to see real time data in Power BI. When to use Azure Synapse Link for Azure Cosmos DB? See Azure Synapse Link pricing section for more details. So, just follow the instructions not using the portal experience.Įnabling Azure Synapse Link has cost implications. Important Note!!!!!: The PBI portal experience isn't there for mongo yet. Once the data is in sync between Mongo DB and Azure cosmos DB then you can set up Synapse link on the Azure cosmos DB to see the real time data.įor synapse, we can use either Azure SQL or on-prem SQL to setup the synapse link. You can use Azure cosmos DB as an intermediate between mongo DB and PBI. "However, I don't want to risk unnecessary costs by doing the wrong setup and I'm not even 100% sure if this setup would actually work to achieve my goal". Please let me know if my understand is not correct. Trying to do capacity planning for a migration to Azure Cosmos DB? You can use information about your existing database cluster for capacity planning.My understanding is that you are trying to build a connection between Mongo and Cosmos then configure a Vnet gateway and build a Power BI to create a data flow from both ends and make a refresh live data on PBI reports.Explore MongoDB samples with Azure Cosmos DB's API for MongoDB.Learn how to use Studio 3T with Azure Cosmos DB's API for MongoDB.Your Azure Cosmos DB account and databases should now be visible within MongoDB Compass. Remove the value automatically populated in the Replica Set Name field to ensure that is left blank.Ĭlick on Connect at the bottom of the page. Upon clicking Yes in the above step, your details from the connection string will be automatically populated. If Compass does not automatically detect your connection string, you can still manually paste it into the application. ![]() Click on Yes as shown in the screenshot below. Open Compass on your desktop/machine and click on Connect and then Connect to.Ĭompass will automatically detect a connection string in the clipboard, and will prompt to ask whether you wish to use that to connect. Clicking this button will copy your entire connection string to your clipboard. Retrieve the connection information for your Azure Cosmos DB account configured with Azure Cosmos DB's API MongoDB using the instructions here.Ĭlick on the button that says Copy to clipboard next to your Primary/Secondary connection string in Azure Cosmos DB. To connect your Azure Cosmos DB account to Compass, you can follow the below steps:
0 Comments
Leave a Reply. |