Alteryx Data transfer to SQL

Question

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

apathetichell · Answer

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

Martyn · Answer

Use the SQL Server Bulk Loader (ssvb) option.

messi007 · Answer

@TNB8617,

Have you tried to use in-data base tools?

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

Hope this helps!

Regards,