Alteryx Data transfer to SQL

[TNB8617]

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

[messi007]

@TNB8617,

Have you tried to use in-data base tools? 

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

Hope this helps!

Regards,

[Martyn]

Use the SQL Server Bulk Loader (ssvb) option.

[apathetichell]

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