MongoDB

You can use the MongoDB (ODBC) connector to read data from and write data to MongoDB in Alteryx One.

This connector is built on the Unified connector framework and uses an Alteryx-managed ODBC driver. No local driver installation is required.

Requirement	Details
Driver installation	The driver is provided by Alteryx One. No separate installation is required.
Connection Type	ODBC
Support	Read and Write
Authentication	Basic Authentication

Prerequisites

Before creating the connection:

Make sure that Alteryx One can access the MongoDB deployment.
Add the required Alteryx service IP addresses to your allowlist, if applicable.
Obtain a MongoDB username and password with access to the required databases and collections.

To create a connection:

Once the connection is created, enter the following details in the appropriate fields:

Connection Name: Display name for the connection in Alteryx One.
Connection Description: Optional description of the connection.
Server: Hostname or IP address of the MongoDB deployment.
Port: Port used by MongoDB. The commonly used default is 27017.
Database: Name of the default MongoDB database.
Authentication Database: Database used to authenticate the supplied user, if applicable.
ODBC Driver: Alteryx-managed MongoDB ODBC driver.

Credential Type: Select Username and Password. Only Basic authentication is currently supported.
Username: Required. Enter the MongoDB username.
Password: Required. Enter the password associated with the username.

Only Basic authentication is supported.
Existing connections and workflows are not automatically migrated to the new connector.

Alteryx One also provides an existing JDBC-based MongoDB connector. For information about that connector, see MongoDB Connections.

In questa sezione: