Data Replication

From FloristWiki

(Difference between revisions)
Jump to: navigation, search
(New page: 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 ...)
Current revision (12:41, 27 June 2014) (edit) (undo)
 
(2 intermediate revisions not shown.)
Line 1: Line 1:
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.
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.
+
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.
<br>
<br>
<table>
<table>
Line 9: Line 9:
</td>
</td>
<td>
<td>
-
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.</td>
+
If your license for the user_data database is removed, you will continue to have read-only access to the existing data but will not receive updates.</td>
</tr>
</tr>
</table>
</table>
<br>
<br>
At a basic level, you will have access to the following information in the user_data database:
At a basic level, you will have access to the following information in the user_data database:
-
*'''Customer information''' (who sent the order)
+
*'''Customer information''': who sent the order
-
*'''Payment information''' (credit card and tax details)
+
*'''Payment information''': credit card and tax details
-
*'''Employee and store information''' (who took the order and where the order was taken)
+
*'''Employee and store information''': who took the order and where the order was taken
*'''Item information'''
*'''Item information'''
-
*'''Product information''' (the products included in the order)
+
*'''Product information''': the products included in the order
-
*'''Recipient information''' (who the order is going to)
+
*'''Recipient information''': who the order is going to
-
*'''Sale information''' (details on the sale)
+
*'''Sale information''': details on the sale
-
*'''Ticket information''' (delivery details and additional order details)
+
*'''Ticket information''': delivery details and additional order details
-
*'''Filling florist information''' (for wire/phoned-out orders)
+
*'''Filling florist information''': for wire/phoned-out orders
-
<br>
+
<table>
<table>
<tr>
<tr>
Line 30: Line 29:
</td>
</td>
<td>
<td>
-
Additional descriptions for tables are provided in the user-data database.</td>
+
Additional descriptions for tables are provided in the user_data database.</td>
</tr>
</tr>
</table>
</table>
<br>
<br>
 +
 +
<hr>
 +
[[FTD Mercury Documentation|Back to FTD Mercury Documentation]]

Current revision

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-only 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