AnterraDataCenter 5.x Prerequisites Documentation

AnterraDataCenter 5.x Prerequisites Documentation

AnterraDataCenter™ Prerequisites Documentation


Contents


Required Software Components

Sage ODBC


Sage ODBC is required to be fully operational for each computer running the AnterraDataCenter™ tools. This requires a Sage server or client install with a purchased ODBC license, and the option to install it selected.  Specific DSN names are not required to be set up, as AnterraDataCenter™ uses a clientless ODBC connection. Anterra supports the current version of Sage and the immediately prior version, in line with the support policy of Sage.

Firebird ODBC (Optional)

Firebird Database engine has to be installed (locally on the same computer as AnterraDataCenter™) in order to extract data from either Firebird (.FDB) database files or Interbase (.GDB) database files.
Furthermore, both the Firebird ODBC driver and Firebird .NET provider have to be installed for the extraction to work.  All the components are accessible through the Firebird website. 

Microsoft SQL Server™


At a minimum, two separate SQL Server databases are required – one for the Sage extracted data, and one for the Extraction set up and management data.  Each Management/Extraction tool combination requires its own Extraction Management database.  The Sage extracted data can reside in one or more centrally located SQL databases, while the Extraction Management database(s) can reside either on the central SQL Server or on a local machine.

AnterraDataCenter supports SQL Server 2010 R2 to SQL Server 2022, including Express editions.

All SQL Server installations should be set up with the latest Microsoft SQL Server Service Packs. 

 

Microsoft .NET Framework 4.6.2 or newer


All AnterraDataCenter™ tools require Microsoft’s .NET Framework 4.6.2 to be installed and functional on the machine AnterraDataCenter™ is installed on.  Link:  https://www.microsoft.com/en-us/download/details.aspx?id=53344 .


Scheduled Tasks


Windows Scheduled Tasks should be set up and operational on the machine where AnterraDataCenter™ is installed if automated updates are a required feature.  Scheduled Tasks are normally accessed through the control panel.  AnterraDataCenter™ administrators can set up and modify scheduled tasks from within the AnterraDataCenter™ interface.


Network Configuration and Permissions


The following network configuration connections and permissions are required:

Sage Security


If Sage Security is used, you must have a valid Sage login and password available to access the data.  We strongly recommend that an account be set up for the sync separate from your system admin account.  We have many support calls from clients that use their system admin account.  When the system admin account password is changed the sync fails.

To test whether the login and password are valid, start up and log in to Sage.  Permissions within Sage itself have no impact – all logins have equal access through ODBC and are not limited by the levels of Sage Security.

Sage Data Folder

It is recommended that AnterraDataCenter™ be installed on the same computer as the Sage data server.  However, it is possible to set up AnterraDataCenter™ on another computer and access the Sage Data folder(s) through a UNC connection path, but this configuration is not supported for scheduled updates.   The AnterraDataCenter™ management tool can browse for this location and needs to point at the Sage file “ts.ctl”, which is located at the root of every Sage data folder.  If the Sage data is not on the same computer as AnterraDataCenter™, mapped drives should not be used, as they will not be present unless a user is physically logged on to a computer.  If Scheduled Tasks are used to run the extraction process, this can occur when a user is not logged on to a computer.

A minimum of read permissions is required for the user ID which AnterraDataCenter™ will be running under for the root of each Sage data folder and all subfolders.


AnterraDataCenter™ Installation Folder


Full permissions are required for the user ID which AnterraDataCenter™ will be running under, both for the Management tool and the Extraction tool.


MSSQL Service Security Account


If the SQL Server is located on a different server than AnterraDataCenter™, the MS SQL Service must be set to log on using a Domain account, rather than the Local Service account.  This is necessary for the Bulk Insert process, which requires access to the share where the bulk insert temporary files are located.  The domain account that is used must have permission to access this folder location.  For more information on SQL Server security, please consult the following Microsoft document for SQL Server. 

Temporary Folder


AnterraDataCenter will require a Shared folder, such as \\SQLServer\ADCTemp,  on the SQL Server if the SQL Server is not on the same server as Sage Server.  The SQL Service Account will need full read access to this folder and the Windows Account running AnterraDataCenter in Task Scheduler will need full read/write access to the Shared folder. 
If the SQL Server is on the same server as Sage, then you can use a local drive such as D:\ADCTemp


Scheduled Tasks


A scheduled task to run the automatic update should be able to run under a User ID that has all of the permissions for Sage and SQL Server access as described in the above processes.


System Requirements

The system requirements for the computer running AnterraDataCenter™ are similar to the Sage System Requirements.  These are as follows:

Sage 300 - Sage Construction and Real Estate

  1. 17.1 to 20.x
Operating System
  1. Windows 10, and Windows Server 2008, 2008 R2, 2012, 2012 R2, 2016, 2019, 2022. All in x86 as well as x64

Processor

  1. 2 GHz multi-core CPU minimum, 2.5+ GHz multi-core CPU is recommended

RAM

  1. 6GB minimum, 8GB recommended
  1. Hard Disk Space:
  2. For the computer where AnterraDataCenter™ is installed requires approximately 100MB of disk space.
  3. SQL hard drive space is roughly equivalent to the hard drive space for your Sage data.  For safety, space should be at least double the immediate maximum requirement to take into account room for SQL transaction logs, indexes, and temporary files.

Network

  1. WiFi 802.11a/ac/b/g/n
  2. Ethernet 100/1000MB


Pre-Installation Checklist


The following items must be performed before installing AnterraDataCenter™:

  • Microsoft .NET framework 4.6.2 or newer installed
  • Computer meets or exceeds minimum hardware System Requirements
  • Sage ODBC installed and functional.
  • SQL Server installed, configured, and functional.
  • Sage security account and password for the data sync available.  Do not use the sys admin account.
  • Sage data folder location is accessible for user account which will install and run AnterraDataCenter™.
  • SQL or Integrated Security set up for user account that will administer AnterraDataCenter™
  • Scheduled Tasks functional (requires local administrator privileges)

If the SQL Server is on a different computer than AnterraDataCenter™, you must additionally check the following:

  • Share for bulk insert files set up on SQL Server which is fully accessible by the account which will be running AnterraDataCenter™
  • MS SQL Service running under a domain account with a minimum of read access to the temporary folder share, and with at least minimum security required to run SQL Server. 

Anterra Technology Contact Information 

Support@anterratech.com

Fill out the following form to get a link to set up your ADC install:


    • Related Articles

    • 'Timberline Version Changed' appears when anterraDataCenter opens

      Background When anterraDataCenter opens, a dialog box with the title "Timberline Version Changed" appears Each time anterraDataCenter opens, a message appears that has the following text in it: "Timberline version has recently been updated. SQL ...

    • Resolving Pervasive.SQL 3006 error found in AnterraDataCenter Log files

      The Pervasive.SQL.3006 error is a result of a timeout between the Pervasive Client and Server which creates a broken or interrupted connection. This can happen if AnterraDataCenter is on a different server from the Sage Pervasive database, or if the ...

    • AP/AR Invoice Image Upload Service Install and Prerequisites

      Overview The Anterra Signed Upload Sync Service is a Windows Service that runs on a server in your environment with access to the locations on your internal network which contain PDF or TIF/TIFF images for AP and/or AR invoices. The service supports ...

    • 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 ...

    • Anterra Version v25.2 Release Notes

      Anterra Version 25.2 Release Notes Updates to Anterra Pivot Grids These are general updates that apply to most of the grids through every module (Finance, Construction, and Service Management) Setting the Default Date for a Pivot Grid - KB Pivot ...