Alteryx Data transfer to SQL
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Have you tried to use in-data base tools?
https://help.alteryx.com/20213/designer/in-database-overview
Hope this helps!
Regards,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Use the SQL Server Bulk Loader (ssvb) option.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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... ...
