Dowload Data from SQL Database

Hi ,

I have this requirement of connecting Alteryx to SQL DB to pull data from certain tables .

But since the data is very very huge , i would like to pull only selective field information from SQL DB instead of dumping everything into Alteryx and filtering out .

Is there way to write a query in alteryx to table to pull few required field information from DB instead of downloading all the data .

Thanks.

Database Connection

Accepted answers

afv2688

Hello @praneshsapmm,

Extractions and uploads can take a lot of time yes. It depends on the amount of lines you expect to get. The more you can narrow your search with the querie the faster it will be. It also depends on the specifications of the machine you are using.

If you like you can also test the results beforehand with the IN DB tools. They are usually faster (as long as you don't want to stream them into your machine) given that they use the db resources instead of the ones on your machine.

Regards

All comments

afv2688

Hello @praneshsapmm ,

Within the input tool you can select to get data from an SQL or ORACLE database (for example). Once you click after having a connection configured you will see an SQL editor to write your own queries. You don't need to download the whole information.

Regards

praneshsapmm

Hi @afv2688 ,

Thankyou for the information .

Iam into SQL or Oracle very much . Is it same SQL queries must be used or is there something specific to Alteryx .

Thanks.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703