Depending on your needs, you can enable specific files in your database to be continually synced for replication or you can leave some files out of the syncing process. For example, if you do not need to report on Activity Based Costing (ABC) codes, you can remove the ABC files from replication process.
Use the SQL Server Sync Maintenance screen to turn on or off Eclipse files that sync over to the Data Warehouse. Turning a file off disables it and no changes to that file are synchronized over to the Data Warehouse. Turning a file back on triggers a full replication of that file over to the Data Warehouse and turns file change tracking back on for near-real time synchronization.
If you use user-defined files, you cannot have a user-defined table and a standard Eclipse table sync off the same file. The sync process is mutually exclusive. If both tables are sync-enabled, such as product_class and product_class_ud, the system syncs the standard table only. In this example, only product_class is synced.
Important: Before beginning this procedure you should enable data replication on your system. |
To maintain your Eclipse files:
From the System > User Custom Menu menu, select SQL Server Configuration to register the Eclipse instance with the Epicor Data Warehouse.
The Eclipse files in your database display in the Eclipse File column. The associated table in which the files live displays in the Table column.
Use the S column (Sync) to enter an asterisk (*) for each file you want regularly synced to the data warehouse.
From the System > User Custom Menu menu, select SQL Server Database Maintenance to view which Eclipse files are configured for replication along with the SWL tables into which the data is being stored.
Select a table to display in view-only mode which columns are replicating over to the table from the Eclipse file.
The system displays the column name used in the SQL table and its attributes from the Eclipse file, including the data for the column and column data type.
If you have user-defined Eclipse files, you can create new columns of data in the SQL table from an existing File Attribute in an Eclipse file. You can define the column name in SQL, the data type, and whether it is a primary key or foreign key on that SQL table.
To add a user-defined Eclipse column or table:
From the System > User Custom Menu menu, select SQL Server Column Maintenance.
Display the column or table you want to update.
Use the Properties hot key to display the properties screen.
Use the following fields to indicate where to get the information for the table:
Field |
Description |
Getter Subroutine |
|
Setter Subroutine |
|
Eclipse File Record |
(For table properties only) |
See Also: