MongoDB ODBC DSN setup

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

Server

MongoDB

Database Connection

Accepted answers

fmvizcaino

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.

Screenshot 2024-11-15 135202.png

Best,

Fernando Vizcaino

All comments

fmvizcaino

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.

Screenshot 2024-11-15 135202.png

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!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703