ManPageW Replication

From ADempiere ERP Wiki

Jump to: navigation, search

Return to Index

Enjoy it, and help to fill it! But please, always respecting copyright.

Please write your contributions under the Contributions Section



Contents

Window: Replication

= BETA FUNCTIONALITY =

Description : Maintain Data Replication Targets

Help : Data Replication Target Details. Set up your system completely on the central system, before setting up the replication. Define the Replication target here and export the database and import it on the remote system.

Before(!) entering transactions, Start the Replication Run to set up the remote system.


Tab: Replication Target

Description : Data Replication Target

Help : Data Replication Target Details. Maintained on the central server. Make sure that the IP range is unique for every remote system - Otherwise you will loose data!!

Table Name  : AD_Replication

Fields

Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_Client_ID

NUMBER(10)

TableDir

Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID

NUMBER(10)

TableDir

Name Alphanumeric identifier of the entity The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. Name

NVARCHAR2(60)

String

Description Optional short description of the record A description is limited to 255 characters. Description

NVARCHAR2(255)

String

Comment/Help Comment or Hint The Help field contains a hint, comment or help about the use of this item. Help

NVARCHAR2(2000)

Text

Active The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

IsActive

CHAR(1)

YesNo

Replication Strategy Data Replication Strategy The Data Replication Strategy determines what and how tables are replicated AD_ReplicationStrategy_ID

NUMBER(10)

TableDir

Host Address Host Address URL or DNS The Host Address identifies the URL or DNS of the target host HostAddress

NVARCHAR2(60)

String

Tunnel via HTTP Connect to Server via HTTP Tunnel If selected, the connection to the server is via a HTTP tunnel, otherwise it uses an RMI/JNP connection IsRMIoverHTTP

CHAR(1)

YesNo

Host port Host Communication Port The Host Port identifies the port to communicate with the host. HostPort

NUMBER(10)

Integer

Remote Client Remote Client to be used to replicate / synchronize data with. The remote client used for data replication. Remote_Client_ID

NUMBER(10)

Table

Remote Organization Remote Organization to be used to replicate / synchronize data with. The remote organization used for data replication. If not selected, all organizations are replicated/synchronized. Remote_Org_ID

NUMBER(10)

Table

ID Range Start Start of the ID Range used The ID Range allows to restrict the range of the internally used IDs. The standard rages are 0-899,999 for the Application Dictionary 900,000-999,999 for Application Dictionary customizations/extensions and > 1,000,000 for client data. The standard system limit is 9,999,999,999 but can easily be extended. The ID range is on a per table basis.

Please note that the ID range is NOT enforced.

IDRangeStart

NUMBER

Number

ID Range End End if the ID Range used The ID Range allows to restrict the range of the internally used IDs. Please note that the ID range is NOT enforced. IDRangeEnd

NUMBER

Number

Prefix Prefix before the sequence number The Prefix indicates the characters to print in front of the document number. Prefix

NVARCHAR2(10)

String

Suffix Suffix after the number The Suffix indicates the characters to append to the document number. Suffix

NVARCHAR2(10)

String

Start Replication Run Start Replication with Remote Host Processing

CHAR(1)

Button

Date last run Date the process was last run. The Date Last Run indicates the last time that a process was run. DateLastRun

DATE

DateTime


Tab: Replication Run

Description : Data Replication Run

Help : Historic Info

Table Name  : AD_Replication_Run

Fields

Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_Client_ID

NUMBER(10)

TableDir

Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID

NUMBER(10)

TableDir

Replication Data Replication Target Data Replication Target Details. Maintained on the central server. AD_Replication_ID

NUMBER(10)

TableDir

Name Alphanumeric identifier of the entity The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. Name

NVARCHAR2(60)

String

Description Optional short description of the record A description is limited to 255 characters. Description

NVARCHAR2(255)

String

Active The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

IsActive

CHAR(1)

YesNo

Replicated The data is successfully replicated The data replication was successful. IsReplicated

CHAR(1)

YesNo


Tab: Run Log

Description : Data Replication Run Log

Help : Detail Info

Table Name  : AD_Replication_Log

Fields

Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_Client_ID

NUMBER(10)

TableDir

Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID

NUMBER(10)

TableDir

Replication Run Data Replication Run Data Replication Run information AD_Replication_Run_ID

NUMBER(10)

TableDir

Replication Table Data Replication Strategy Table Info Determines how the table is replicated AD_ReplicationTable_ID

NUMBER(10)

TableDir

Active The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

IsActive

CHAR(1)

YesNo

Replicated The data is successfully replicated The data replication was successful. IsReplicated

CHAR(1)

YesNo

Process Message P_Msg

NVARCHAR2(2000)

String

Contributions

Personal tools