Hello all!
I am new to Alteryx and was wondering if it's possible to embed SQL developer query within an alteryx workflow, i.e. the input data file is automatically updated via the query/export of the data from a source (such as Oracle EBS) using the SQL Developer program.
Is this possible or is something similar possible?
Thank you!
Jon Kopelman
Solved! Go to Solution.
Hi @jkope404
When you say a SQL Developer Query do you mean a select statement?
If so you can put this into the Input Data tool after setting up your driver connection to your database. Each time you then run your workflow this will execute the statement refreshing the input into Alteryx and reading the latest results.
Hi
remembering that plsql will not run
[]
"If so you can put this into the Input Data tool after setting up your driver connection to your database. Each time you then run your workflow this will execute the statement refreshing the input into Alteryx and reading the latest results."
Correct, using a select statement. Can you give an example or point me in the direction of a "How To" on setting up a driver connection to the database?
@jkope404 wrote:
"If so you can put this into the Input Data tool after setting up your driver connection to your database. Each time you then run your workflow this will execute the statement refreshing the input into Alteryx and reading the latest results."
Correct, using a select statement. Can you give an example or point me in the direction of a "How To" on setting up a driver connection to the database?
Sure, there is a guide here within help: https://help.alteryx.com/current/OracleConnections.htm
Let me know if you have any questions about it.