Can I connect Alteryx to CosmoDB

[ursyaathi]

I have a project where my end users are using Alteryx to combine data sources and import into SQL server. We are investigating changing SQL server to CosmoDB but I'm not sure if connecting to CosmoDB is supported by Alteryx.

Do anyone know if there is a connector? Am I overthinking this? I don't know Alteryx very well.

[alexnajm]

Looks like it’s possible via a generic ODBC connection: https://www.cdata.com/kb/tech/cosmosdb-odbc-alteryx.rst

[AkimasaKajitani]

Hi @ursyaathi 

If you use the Designer Cloud, unfortunately there is no connector for it.

Supported Connection Types

https://help.alteryx.com/AAC/en/platform/connections/supported-connection-types.html

Early Preview Connection Types

https://help.alteryx.com/AAC/en/platform/connections/early-preview-connection-types.html

[nkuipers]

Hi @ursyaathi,

There is no connector for Azure Cosmos DB, currently; nor is it present even as an "I'm interested!" option in the Create Connection Window in AACP. 😞 That said, I see from the Microsoft doc here that Cosmos DB exposes a REST API, and there is a supported read-only REST API connector (doc here). Could this be useful for you?

[Dev73]

Hi @ursyaathi , you can't connect with CosmoDB  in the alteryx.