OLE DB Query connection to Alteryx

[kmontoya]

Hello,

I have an excel file that gets data from a OLE DB Query connection. The Properties in this connection has a "connection string". Command type is "SQL" & there's some info in the "command text". I was wondering if I can connect this into a workflow? Instead of having the excel file as an input?


thank you in advance!

[TimN]

Hi,

It is definitely possible.  You just need access to the data source and the connection details.  I've done this for an Oracle database.  Connection details - you should work with the Database Admin to get the details.

Regards.

[stevediaz]

Hello

If you have an Excel file with data from an OLE DB Query connection, and you want to integrate it into a workflow:

1. Power Query in Excel:

   • Load data into Excel using OLE DB Query.
   • Create a connection without loading the data.

2. Workflow Tool (e.g., Power Automate):

   • Use a workflow tool.
   • Connect to Excel and provide OLE DB details.

3. Data Processing:

   • Perform actions on the connected data.

4. Scheduled Execution (Optional):

   • Set up scheduled updates if needed.

You can also check https://community.alteryx.com/t5/Discussions/ct-p/ayx-discussions msbi course

Thank you