07-26-2019 07:56 AM - edited 07-23-2021 03:37 PM
How To: Connect to an OleDB Data Source
Alteryx can connect to databases using different methods. This guide will focus on setting up an OleDB connection to SQL server, however, the same general process can be followed to connect to any database via OleDB.
Prerequisites
OleDB driver for the database (if it is not currently present on your machine, you must download and install it prior to using this guide. The download links to many of the drivers can be foundhere. If you are unsure of where to get the driver or which driver to use please contact your IT or database admin for this information).
Procedure
Before 2019.2
2019.2 and later
All versions
Additional Resources
Hi @MichaelAd,
Thank you for sharing this article.
I am trying to set up the OLEDB with INDB connection and want to save it to a file for the newest driver MSOLEDBSQL. I received the given error. Looks like this is not supported with Alteryx. Kindly let me know about your thoughts on this one or if there are other ways around this?
Driver Details: https://docs.microsoft.com/en-us/sql/connect/oledb/oledb-driver-for-sql-server?view=sql-server-ver15
Thank you!
I am having the same issue as the above with connecting using the new provider MSOLEDBSQL19, with the in-DB input tool. Any solve?