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 create schedules
  3. Click Next when the window appears
    task setup wizard
  4. Choose 'Create new scheduled task for selected Connections' (you will select which connections next) and click Next
    create new task
  5. Select one or more connections and click Next
    select connections
  6. Give your schedule task a name and a frequency then click Next
    name and frequency
  7. Choose the time of day (based on the server's time) that the scheduled task will run and click Next
    schedule task
  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
    date of task
  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.
    user authorization
  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
    specify action
  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.
    add 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
    activated tables
  3. Click the New Group button on the ribbon bar 
  4. Provide a name for the new group and click OK
    new group name
  5. Place checkmarks in the appropriate tables that will be a part of this group and click the  button
    checkmarks
  6. Click Create Schedules on the ribbon strip 
  7. Click Next when the window appears
    create schedule
  8. Choose Create new scheduled task for Table Groups and click Next (you will choose the table group(s) on the next step)
    task for table groups
  9. Choose the table group you created earlier or any number of table groups then click Next
    table group
  10. Give your schedule task a name and a frequency then click Next
    name the task
  11. Choose the time of day (based on the server's time) that the scheduled task will run and click Next
    start time
  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
    first date to run
  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.
    user name and password
  14. Open Windows Scheduled Tasks, right-click on the newly created task, and choose Properties.
    open windows
  15. Navigate to the Actions tab and click the Edit button
    actions tab
  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.
    edit action