Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Alteryx Data transfer to SQL

TNB8617
5 - Atom

Hello,

 

I am working on a project that requires data transfer from Alteryx to Sql database. 

Below is the information of data that needs to be transferred -

Records - 5000

Columns - 100

 

For transferring above dataset it took me 30 mins to transfer from Alteryx to SQL. However, while transferring same data from excel to Sql using macros, it takes not more than 2 mins.

 

Is there any faster way to upload data from Alteryx to Sql.

 

Thanks

Akshat

3 REPLIES 3
messi007
15 - Aurora
15 - Aurora

@TNB8617,

 

Have you tried to use in-data base tools? 

 

https://help.alteryx.com/20213/designer/in-database-overview 

 

messi007_0-1643703436603.png

 

Hope this helps!

Regards,

Martyn
9 - Comet

Use the SQL Server Bulk Loader (ssvb) option.

apathetichell
19 - Altair

What kind of SQL are you using? There are alot of things which could be impacting performance here. Is this using a datastream in tool?

 

datastream in/datastream out can take awhile... ...

Labels
Top Solution Authors