Access ODC file via Alteryx - couldn't find file
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You have to go to ODBC administrator and set up a file DSN. Then, you can select the DSN with the input tool.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Just navigate to the capture I have attached and click add. Then go through as you normally would to create it.
