MongoDB ODBC DSN setup

[BonusCup]

Alteryx Version: 2023.1.1

ODBC driver version: v1.4.5

ODBC link: MongoDB BI Connector ODBC Driver - BI Connector

Hi,

I am able to connect to AlteryxGallery and AlteryxService using Studio3T but now that the MongoDB Input tool is deprecated, I've been trying to set up the DSN with no luck. I tried both the ANSI and the Unicode driver and the non-Admin password, but after configuring and when testing it became unresponsive and when I went to close it, it asked to restore and then I received a Connection Failed error:

[MongoDB][ODBC 1.4(a) Driver] Lost connection to MySQL server at 'reading initial communication packet', system error: 0

 

 

 

Can anyone help with this setup?  TIA

[fmvizcaino · Accepted solution]

Hey @BonusCup ,

There is a Simba MongoDB ODBC driver available for download in the Alteryx Downloads portal. That is the one I usually use and is pretty easy to configure.

Best,

Fernando Vizcaino

[BonusCup]

@fmvizcaino, I was going off this page, https://help.alteryx.com/20231/en/designer/data-sources/mongodb.html, but I'll give that a try.

[BonusCup]

@fmvizcaino, that fixed it.  Thanks!