Data Replication

From FloristWiki

Revision as of 13:39, 26 June 2014 by MercTechUAdmin (Talk | contribs)
Jump to: navigation, search

You can now access data from your FTD Mercury database without impacting your system’s performance. With data replication, key tables from the FTD Mercury database are replicated into a secondary, read only database.

Once your system has been configured for the user database, you will receive read only access to the user_data database. This database contains relevant information from the FTD Mercury database. After the system is licensed for the user database, a snapshot of the current information populates the user_data database. When information within the applicable tables is added, updated, or deleted, the user_data database is updated.

Image:ImportantInfoIcon.png

If your license for the user_data database is removed, you will continue to have read access to the existing data but will not receive updates.


At a basic level, you will have access to the following information in the user_data database:

  • Customer information (who sent the order)
  • Payment information (credit card and tax details)
  • Employee and store information (who took the order and where the order was taken)
  • Item information
  • Product information (the products included in the order)
  • Recipient information (who the order is going to)
  • Sale information (details on the sale)
  • Ticket information (delivery details and additional order details)
  • Filling florist information (for wire/phoned-out orders)

Image:ImportantInfoIcon.png

Additional descriptions for tables are provided in the user_data database.



Back to FTD Mercury Documentation

Personal tools