Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.
SOLVED

SQL developer

5 - Atom

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

Highlighted
Alteryx
Alteryx

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.

Highlighted
Alteryx Certified Partner

Hi

 

remembering that plsql will not run

 

[]

Highlighted
5 - Atom

"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?

Highlighted
Alteryx
Alteryx

@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.

Labels