How To Set Up DRS

Owned by Curtis Green
Jun 04, 2024
5 min read

How to setup DRS in Agris

Data Replication Service, known commonly by its abbreviation DRS, is a method by which database tables at scale sites can be updated with new data entered on the server AGRIS dataset.

 

In order to use DRS, the System Support Extended Option #15 needs to be turned on. For datasets with security, this also requires setting an appropriate security level under SYS - System Support/Utilities/Data Replication Service.

DRS was launched in AGRIS 9.6.0.13. We do recommend Agris and oneWeigh version to be on 10.3.2 or higher for better success rate.

Version history

 

9.6.0.13

10.1.1

17.2 (E1.1)

17.3 (E1.2)

Supported between PSQL datasets

Yes

Discount Table, Name ID, and Contract extracts

Yes

Farm Field extract

No

Yes

Supported between SQL Server datasets

No

Yes

Supported across database types

No

Yes

 

Information needed before you begin…

  • Agris license file for number of sites updated with DRS – New Server license should be set to unlimited. License file only needs to be loaded on the server ( no license change is necessary on the oneWeigh)

  • Server Com Plus user account info (name and password) – ONE matches server settings.

  • oneWeigh computer name

  • Matching Agris user on both server and oneWeigh security settings to give them access to name and grain files.

  • Agris Server and oneWeigh have to be on the same domain!

 

OneWeigh PC Setup

 

Agris>Maintenance>Dataset Maintenance and set (Y unless integrating with D.R.S) to N (live dataset)

 

 

 

  • Server Com Plus user account info (name and password) on 4 oneWeigh com plus components (see last section for detail steps)

  • Matching Agris user on both server and oneWeigh security settings to give them access to name and grain files.

  • MUST have firewall off on oneWeigh pc.

  • Make sure PC is shared by other devices

 

Server Setup

  • Agris license file should have unlimited sites with DRS turn on.

  • Matching Agris user on both server and oneWeigh security settings to give them access to name and grain files.

  • Turn on Document Tracking for options to transfer

(NAM-Name/Address Info, GRN-Discount tables, Sales and Purchase contracts)

 

DRS Site Configuration

 

  • Agris/utilities

  • Select Data Replication Service

  • You will be prompted to add a new site

  • Sequence will start with 0001

  • Fill in the Remote component Server name of the oneWeigh PC

  • Fill in the Remote Data Path with the Directory where Agris is installed (C:\Agris or C:\Apps\Agris)

  • Use the magnifying glass to find live oneWeigh dataset (001, 002, etc.)

  • Click OK and it will attempt to validate connection to remote oneWeigh PC

  • If it fails validation test, troubleshoot com plus on oneWeigh pc (Com plus user should be member of local admin group on oneWeigh PC). Once validation is successful you will get the options for Grain and Name extractions

  • Click Save/Exit

  • Select site to be edited. Determine what changes need to be made with activate or inactivate Grain, Name or contract info or setting filters for info to be passed.

 

 

Message Setup

  • This feature allows you to customize what data is being sent/received to the site using DRS.

  • Utilities > Data Replication Services > Site Configuration > Select the site(Double-Click) > Edit each message.

  • The data option(s) that you would like to send with DRS need to be set to A(Active).

  • Set the priority sequence in the order of “priority” you would like for DRS to send updates.

  • Be sure to set the “Last Date Time” to the latest or most recent date and time you would like the OneWeigh to pull data from.

  • **Note** DRS has the option to block out Social Security No.’s and Federal Id No.’s. Just switch this to a “N”.

 

 

Process Sites

This Option will manually process data on demand to the active sites

Communications Inquiry

Choose this option to display sites that have processed. You can select the different sites for a detailed overview of status. This can be used to troubleshoot failed processes.

Communications Report

This will give you the ability to run reports based on the selection criteria for begging and ending including dates, Stations, User ID’s. Site numbers, etc.,

Recent Rejection Details

Selection will give you an XML message screen

 

Component server settings

(Firewalls need to be shut off)

  • Go to control panel

    • Administrative tool

  • Component Server

  • Computers

  • Right click on My Computer-click properties

  • Com Security

  • Launch and Activation Permissions-click on edit limits

  • Select Everyone

  • All 4 boxes below- allow permissions by checking the boxes

  • Cancel out of this window

  • Double click on My Computer

  • COM + Applications folder- click on it

  • On all 4 Agris components- right click on each one at a time

  • Click on properties

  • Identity tab

  • Click on This user- Browse

  • Click on Advanced

  • Click on Find Now

  • Click on the Server name- Ok, Ok (must be the same for ONE and server)

  • Password- Type and confirm (must be the same for ONE and server)

  • Repeat the other 3

 

 

By: Travis Jerke & Curtis Green