Access ODC file via Alteryx - couldn't find file

[estheran]

Hi all,

I got a Microsoft Data Connection file with .odc extension. I attempted to use the Input Data tool to access it but the file is now showing up. Also, I tried to connect to it via the Directory tool and download it. However, it says 'couldn't resolve host name'.

Does anyone know how to access .odc files via Alteryx? Thank you in advance!

[Inactive User · Accepted solution]

You have to go to ODBC administrator and set up a file DSN. Then, you can select the DSN with the input tool.

[brunod]

---

@Inactive User wrote:

You have to go to ODBC administrator and set up a file DSN. Then, you can select the DSN with the input tool.

---

Hi @Inactive User !

Please, could you help me through this? I didn't managed to set up a file DSN.

Thanks!

[Inactive User]

Just navigate to the capture I have attached and click add. Then go through as you normally would to create it.