community
cancel
Showing results for 
Search instead for 
Did you mean: 

alteryx connect Knowledge Base

Definitive answers from Connect experts.

Schedule Metadata Loader

Moderator
Moderator
Created on

In order to schedule the Metadata loader, you will need to configure and save the .yxwv file, and configure the ConnectScheduler workflow to run from the directory of the .yxwv file. Detailed steps listed below:

 

1. Open the Metadata loader in Designer, in this example the Files loader, fill in the information for the "Files to load" and "Alteryx Connect" tabs

 

1539842792(1).png

 

 

2. Click Save button to save the .yxwv file in the default File Loader location - C:\ProgramData\Alteryx\AlteryxConnect\Files_Loader

3. Click Help > Sample Workflow > Alteryx Connect Metadata Loaders > ConnectScheduler

4. Click on the Directory input tool, select the root directory where the yxwv file(s) is saved, for example C:\ProgramData\Alteryx\AlteryxConnect

5. For the File Specification, leave it as *.*

 

directory.png

 

6. Saved locally text

 

Schedule the loader using Local machine

 

 1. To Schedule using local computer, complete steps 1 - 5 from above

 2. Click Option > Schedule Workflow > My computer

 3. Select Run the workflow from its original location on disk

 

Local Schedule.png

 

 

Note: When the scheduler runs, it will run every metadata loader with .yxwv file one by one. If you only need to have one of the loaders scheduled, you need to have the Metadata loader moved into a folder other than C:\ProgramData\Alteryx\AlteryxConnect

 

Schedule the loader using the Alteryx Gallery

 

Save the ConnectScheduler to Gallery for Scheduling. instructions can be found in https://help.alteryx.com/connect/current/Administration/ScheduleLoaders.htm under Configure and test the Connect Scheduler > Step 6.

 

Tip: When scheduling loaders on Alteryx Gallery, we recommend to copying the metadata loader and save the .yxwv files into a share drive to avoid the situation where the Alteryx Server machine is unable to access the end user's machine. See steps below:

 

Spoiler
Steps:
1. Create a Folder called AlteryxConnect in a Share Drive
2. Copy the loader folder, for example Files_Loader from C:\ProgramData\Alteryx\AlteryxConnect to the Share Drive's AlteryxConnect
3. Complete steps 1-2 from above but save the .yxwv file into the share drive under AlteryxConnect\Files_loader
4. Open ConnectScheduler from Help > Sample Workflow > Alteryx Connect Metadata Loaders 
5. In the Directory Input tool, select the Path of AlteryxConnect in the Share Drive, make sure it is the UNC path
6. Save ConnectScheduler, and it is ready to be schedule 

 

 

 

 

Comments
Alteryx Certified Partner
Alteryx Certified Partner

I just wanted to clarify here that there's a separate workflow called ConnectScheduler saved here: Help > Sample Workflow > Alteryx Connect Metadata Loaders > ConnectScheduler

 

AND NOT to try to change the Directory tools that are withing the individual Metadata loaders. e.g. Alteryx_Loader, Tableau_Loaders, etc.

Alteryx Partner
Hello, Stupid question but I'm unable to find it. It may be because I have a French version installed. Is it available elsewhere? Best regards, Simon
Alteryx
Alteryx

Hi @simonaubert_bd , and do you have installed "Connect Loaders"? They are not shipped with Designer by default but has to be installed separately.