Skip to main content
Avalara Help Center

Excise Data Replication Service

 

This site is only for Avalara customers licensed for Returns Excise, AvaTax Excise and Government. 
Documentation of operation, usage and release dates is confidential and proprietary information of Avalara.

This document applies to Enterprise customers.  Content last updated 2021-03-25.

​Data Replication Service (DRS) replicates key data tables from the Avalara Returns Excise SaaS environment to an on-premise database to enable local reporting and analytics.  Additional Avalara licensing is required.

Overview

 

DRS chart.png

  • User initiates sync of  Master Data and Tax Sessions on demand or on a configurable schedule.
  • Replication data is written to an on-premise database owned by the customer.
  • Avalara product updates provide schema changes to keep the replication data identical to the ARE SaaS tables.
  • Custom reporting can be done on the DRS database.
  • Secure protocols to specific URLs are configured by the customer's IT department.

Types of Data Synchronized

Sync is a complete overwrite of previous data.

  • Tables with Tax Session-related data.
    • Examples: Schedule Transactions, Header Sequences, and Business Entity/Accounts
  • Master Data - not necessarily associated with a Tax Session.
    • Examples: Business Entity/Accounts, Locations

NOTE: Master Data Export/Import can be used to copy specific tables between Production and Sandbox without affecting the Sync data.

Setting up Replication

An Administrative login is required.

  1. Click Maintenance > Replication Service
  2. There are 5 tabs to configure and monitor DRS

tabs.png

Queue

Displays pending and completed items

  1. The dropdown filter displays Pending (default), All Items or Completed Items
  2. Replicated Tax Session information displays in the Key column
  3. Change the order of the Queue using the Up or Down arrows on the task's grid line
  4. Cancel a job by clicking the red X
  5. Click Add New Record to initiate an immediate one-time Replication Service Event, using the check boxes and dropdowns to select preferencesevents.png

Calendar

Schedule, view and maintain replication events.

  1. Click Add New Record.
  2. Populate the Replication Service Event, then click Insert.  The asterisk * indicates required information
  3. The options you see will depend on the Replication Object Type selected 
  4. When replicating Tax Session, if the Include Supporting Data box is checked, then the Business Entity/Accounts, Locations, Products, Companies, Company Accounts and Company Information will also be replicated.  Only check this box if changes have been made since the last Sync, to streamline the replication.

event.png

Settings

Customize the default values, shown below.settings.png

Heartbeats

Check the health of the Replication Service.

  1. Green checkmark - Service is active and running.
  2. Red X - Service is not running.
  3. Critical stop - the last Heartbeat was missed.
    • After 3 missed Heartbeats, the status will change to a red X

heartbeat.png

Scheduled Tasks

View status and download the file from Export as Scheduled Task via Excel or CSV run from any of the tabs.

Troubleshooting

Understanding how DRS works will help you trace event errors or Heartbeat issues.

  1. DRS makes data requests to Avalara SaaS using API.
  2. DRS receives data to be replicated from the API call.
  3. Data is received in chunks and loads them into the on-premise replication database.
  4. Success/Failure message is returned with a timestamp.

When a Replication Event fails

  1. Is the Settings tab set to the specific company you want to replicate?
  2. Is the Calendar tab set to valid dates and the specific company you want to replicate?
  3. Are there pending or active jobs in the Queue tab? If not check:
    • the Heartbeat tab
    • if any changes been made to the Avalara Excise\Replication appsettings.config file in the install
    • if there were network interruptions during the schedule replication time
    • if SaaS has had a schema change in the quarterly release
      • If so, you may need to take the corresponding DRS upgrade to current version

When the heartbeat fails

  1. that the Avalara Excise Replication is in a Running status in the "services" interface on the server hosting the DRS database
  2. the application.log file from the Avalara\Excise Replication folder for errors
  3. the log file from your Replication database for errors

Test the API access

  1. Launch the Avalara_Excise_Replication Installer
  2. Click Configure on the Welcome screen
  3. Click the Settings Configuration tab
  4. Click Validate Access - you will get either Valid Access or Unable to Validate with an error code
  5. Close the Installer

screenshot_21.png

SQL Replication database views

You can use Views > Schedule_information, which combines data from:

  • business_entities 
  • business_accounts
  • business_entity_id_codes
  • schedule_transactions
  • schedule_transactions_supp
  • schedule_transactions_custom 

Views SQL.png

 

 

 

 

 

 

 

 

 

  • Was this article helpful?