Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Running Alteryx workflow from a server

learnalteryx
7 - Meteor

I am facing an issue. My file server & SQL server is located in another country. This file server contains my

1. Input file

2. Alteryx workflow

 

These files are accessed by multiple team members who are in the same country except me. I am staying in another country

. When I run the workflow from the server it is super slow and outputing to the SQL server ends up as error.

 

What I do as a work around is , I copy the workflow and the input file to my local drive, remap it and run the workflow. This is taking too much time. - But still have the file processed. But I still have another issue of updating the SQL.

My question

1. How can I improve the import to the SQL server ? Reducing the transaction limit OR bulk insert

2. Any tips of running the file directly from the server ?

0 REPLIES 0
Labels
Top Solution Authors