Unable to connect to a MongoDB from Azure synapse
NickName:Baobab Ask DateTime:2022-11-18T20:50:30

Unable to connect to a MongoDB from Azure synapse

Unable to connect to a MongoDB from copy activity as a timeout error occurs in just 30 seconds. The MongoDB seems to be online. I am able to test the connection successfully inside the copy activity. However, when I run the pipeline the following error occurs:

A timeout occurred after 30000ms selecting a server using CompositeServerSelector{ Selectors = MongoDB.Driver.MongoClient+AreSessionsSupportedServerSelector, 
LatencyLimitingServerSelector{ AllowedLatencyRange = 00:00:00.0150000 } }. Client view of cluster state is { ClusterId : "1", ConnectionMode : "ReplicaSet", Type : 
"ReplicaSet", State : "Disconnected", Servers : [{ ServerId: "{ ClusterId : 1, EndPoint : "Unspecified/**serveraddress**:27017" }", 
EndPoint: "Unspecified/**serveraddress**:27017", State: "Disconnected", Type: "Unknown", LastUpdateTimestamp: 
"2022-11-18T10:51:01.9853437Z" }, { ServerId: "{ ClusterId : 1, EndPoint : "Unspecified/**serveraddress**:27017" }", EndPoint: 
"Unspecified/**serveraddress**:27017", State: "Disconnected", Type: "Unknown", LastUpdateTimestamp: "2022-11-18T10:51:01.9913438Z" }

What could be the issue?

Copyright Notice:Content Author:「Baobab」,Reproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/74489950/unable-to-connect-to-a-mongodb-from-azure-synapse

More about “Unable to connect to a MongoDB from Azure synapse” related questions

Azure synapse Analytics connection to MongoDB Atlas

I'm new to Azure synapse Analytics. I'm trying to copy data from my mongodb Atlas cluster to a datalake I'm trying to use a private endpoint to authorize the connection from my Azure Synapse worksp...

Show Detail

Is it possible to connect to Azure Synapse with SSMS?

I connected Synapse to Azure data studio by following the steps that are mentioned at this link: How to connect to Azure Synapse? But when I try to follow the same steps and connect Synapse to SSMS...

Show Detail

How to install MongoDB Connector for Spark in Azure Synapse Notebook?

I want to install MongoDB Spark Connector in Azure Synapse, so I can write code like this in my Notebooks: df = spark.read.format("mongodb").option("spark.synapse.linkedService", &

Show Detail

Unable to connect to a MongoDB from Azure synapse

Unable to connect to a MongoDB from copy activity as a timeout error occurs in just 30 seconds. The MongoDB seems to be online. I am able to test the connection successfully inside the copy activity.

Show Detail

How to connect to Azure Synapse?

How am I supposed to connect to Azure Synapse? Is there a page on the portal (and where is it)? Is it from Management Studio (and how to I set that up)?

Show Detail

Connect to Azure Synapse Spark Pool from outside

Is there a possibility to connect to the Azure Synapse Spark pool from "outside". Meaning with Rstudio or Sparksql?

Show Detail

Hi I was trying to connect to import data to Azure ML from Azure Synapse Link

So first I wanted to import a table from Powerapps dataverse to use it on Azure ML, for this I created an Azure Synapse link for the table into the Azure Portal. Now from the Storage account which ...

Show Detail

Azure synapse studio connectivity using Private end point

I am trying to setup a secure connection to Azure synapse studio using private link hub and private endpoint as mentioned in the below doc, https://learn.microsoft.com/en-us/azure/synapse-analytics/

Show Detail

How to connect to on-premise SQL Server from Azure Synapse

We are currently creating a new Azure Synapse Analytics environment to house our data. For this, we need to connect from Synapse to our on-premise SQL Server databases. These databases are not reac...

Show Detail

Is there a way to connect azure synapse studio to bitbucket repo?

Is there a way to connect azure synapse studio to bitbucket repo ?

Show Detail