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!
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.
Hello
If you have an Excel file with data from an OLE DB Query connection, and you want to integrate it into a workflow:
Power Query in Excel:
Workflow Tool (e.g., Power Automate):
Data Processing:
Scheduled Execution (Optional):
You can also check https://community.alteryx.com/t5/Discussions/ct-p/ayx-discussions msbi course
Thank you