Transformation configuration data is set for a consumer replication set on a consumer instance to replicate on the consumer instance data of a source table included in a producer replication set on a producer instance. The transformation configuration data includes configuration data of at least one of: (i) a target table from among a plurality of tables on the consumer instance that is specified in the consumer replication set as a table for loading on the consumer instance, incoming data from the source table; and (ii) a specified mapping of incoming fields of the source table with respective fields of the target table. Replication event data of a data modification event associated with a record on the source table is received. The received replication event data is transformed based on the set transformation configuration data, and loaded on the target table.