topic SQL developer in Alteryx Designer Desktop Discussions

SQL developer

jkope404 — Wed, 04 Sep 2019 22:22:38 GMT

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

Re: SQL developer

JoeS — Thu, 05 Sep 2019 07:59:48 GMT

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.

Re: SQL developer

geraldo — Thu, 05 Sep 2019 14:14:55 GMT

remembering that plsql will not run

[]

Re: SQL developer

jkope404 — Thu, 05 Sep 2019 16:58:46 GMT

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

Re: SQL developer

JoeS — Fri, 06 Sep 2019 07:48:13 GMT

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