SQL developer

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

Workflow

Datasets

Developer

Tips and Tricks

Connectors

Tableau

Optimization

Interface Tools

Database Connection

Iterative Macro

Accepted answers

JoeS

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.

All comments

JoeS

Hi @jkope404

When you say a SQL Developer Query do you mean a select statement?

geraldo

remembering that plsql will not run

[]

jkope404

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703