My org is considering using Azure Data Lake Storage gen2 and have asked me to look into how Alteryx interacts with that service.
Background:
- We currently schedule dozens of ETL workflows on Alteryx Server
- Our gallery instance has been very buggy and crashes often, therefore we don't schedule anything on it
- I'm considering using Alteryx to write files to ADLS and read files from there on a scheduled basis
The problem:
When I downloaded the ADL output tool, I see "you can't schedule workflows on Server if you connect manually". However, the data connection manager doesn't support Azure Data Lake Storage per this link - https://help.alteryx.com/current/en/designer/tools/dcm---designer/dcm-supported-connectors-and-tools.html#dcm-supported-connectors-and-tools
Does this mean that under our current setup, we won't be able to schedule workflows that connect to ADLS on Server? If not, what alternatives should I pursue? I've seen Data Factory and Azure Databricks as possibilities, I just want to exhaust everything on the Alteryx side before committing to significant rework through either of those tools.
