Allow Non-Administrator Users to Run ADC Updates

Allow Non-Administrator Users to Run ADC Updates

Running All Connections

This is the easiest configuration and allows any user to run the configured connections for all active tables.

Create a shortcut to ADCUpdate.exe (located in the anterraDataCenter installation folder).  You can place this shortcut on user's desktops (usually C:\Users\[username]\Desktop) or on the desktop of all users that can access the machine by putting it on the Public Desktop (usually C:\Users\Public\Desktop).  When it is run, the user will be shown a progress interface, if you want to hide this interface add /SCHEDULEDTASK to the parameters.
If using Sage 300 CRE, the user running the application must have access to the location of the Sage data files (this is often configured as a file share, even on the same machine)

Running Selected Connections

This allows you to select one or more configured connections in ADC and allow a user to run those connections. To do this, we'll go through the process of creating a scheduled task, since most connections that are going to be updated by a user will also run on a consistent schedule.  If you have a special use case where you don't want to have the scheduled task, at the end of the process you can delete the scheduled task and simply use the information populated by ADC into the scheduled task.
  1. As an administrator, open ADC
  2. Click Create Schedules on the ribbon strip 
  3. Click Next when the window appears
  4. Choose 'Create new scheduled task for selected Connections' (you will select which connections next) and click Next
  5. Select one or more connections and click Next
  6. Give your schedule task a name and a frequency then click Next
  7. Choose the time of day (based on the server's time) that the scheduled task will run and click Next
  8. Pick the first date this scheduled task will run and whether it will run every day, only on weekdays, or every X number of days, and click Next
  9. Lastly, provide the service account username / password that this scheduled task will run as.  If you're not planning on keeping the scheduled task and are creating it only to configure shortcuts for users then you can use your account.  When complete, click Finish.
  10. Open Windows Scheduled Tasks, right-click on the newly created task, and choose Properties.
  11. Navigate to the Actions tab and click the Edit button
  12. In the Add arguments (optional) box you will see the /RUNEXTRACTOR flag along with the selected unique identifiers (strings of numbers and letters) for each connection you selected, you can use these properties to create a shortcut on the desktops of users.  To allow the status interface to appear for users when they run the shortcut you create simply remove the /SCHEDULEDTASK flag found at the end of the arguments.

Running Only Specific Tables

This allows you to select any of the tables (or groups of tables) in ADC, create a group for those tables called a table group, and allow a user to run update those tables in any number of connections.  To do this we'll go through the process of creating a scheduled task since most table groups that are going to be updated by a user also need to run on a consistent schedule. If you have a special use case where you don't want to have the scheduled task, at the end of the process you can delete the scheduled task and simply use the information populated by ADC into the scheduled task.
  1. As an administrator, open ADC
  2. Click Table Groupings found at the bottom left of the ADC window
  3. Click the New Group button on the ribbon bar 
  4. Provide a name for the new group and click OK
  5. Place checkmarks in the appropriate tables that will be a part of this group and click the  button
  6. Click Create Schedules on the ribbon strip 
  7. Click Next when the window appears
  8. Choose Create new scheduled task for Table Groups and click Next (you will choose the table group(s) on the next step)
  9. Choose the table group you created earlier or any number of table groups then click Next
  10. Give your schedule task a name and a frequency then click Next

  11. Choose the time of day (based on the server's time) that the scheduled task will run and click Next
  12. Pick the first date this scheduled task will run and whether it will run every day, only on weekdays, or every X number of days, and click Next
  13. Lastly, provide the service account username/password that this scheduled task will run as.  If you're not planning on keeping the scheduled task and are creating it only to configure shortcuts for users then you can use your account.  When complete, click Finish.
  14. Open Windows Scheduled Tasks, right-click on the newly created task, and choose Properties.
  15. Navigate to the Actions tab and click the Edit button
  16. In the Add arguments (optional) box you will see the /RUNEXTRACTOR flag followed by the /GROUP flag along with the selected unique identifiers (strings of numbers and letters) for each table group you selected, you can use these properties to create a shortcut on the desktops of users.  To allow the status interface to appear for users when they run the shortcut you create simply remove the /SCHEDULEDTASK flag found at the end of the arguments.