Selective synchronization of linked records
Systems, devices, and techniques are disclosed selective synchronization of linked records. A criteria may be received for a primary database that includes records. Records of the primary database may be linked to records of a first instance database. The criteria may include an inclusion of an expression or value in a specified field of a record. Records of the primary database may be determined to meet the criteria by determining that the records of the primary database include the expression or value of the criteria in the specified field. Records of the primary database that meet the criteria may be synchronized with the first instance database. The synchronization of records of the primary database that do not meet the criteria may be prevented.
1. A computer-implemented method comprising:
receiving a criteria for a primary database comprising records belonging to a first tenant, wherein one or more of the records of the primary database are linked to records of a first instance database that is part of a first database system and wherein the criteria comprises the inclusion of an expression or value in at least one specified field of a record, wherein the criteria is received through a user interface;
determining one or more of the records of the primary database that meet the criteria by determining that each of the one or more of the records of the primary database comprise the expression or value of the criteria in the specified field;
synchronizing the one or more of the records of the primary database that meet the criteria with the first instance database:
for a record in the primary database that is one of the one or more records that is linked to a record of the first instance database, synchronizing record data between the record in the primary database and the record in the first instance database to which the record in the primary database is linked,
for a record in the primary database that is not one of the one or more records that is linked to a record of the first instance database, generating a new record in the first instance database using record data from the record in the primary database, and linking the new record in the first instance database to the record in the primary database: and
preventing the synchronization of records of the primary database that do not meet the criteria by limiting the visibility of the records of the primary database that do not meet the criteria to a synchronization component of the first database system by hiding, by a primary application of the primary database, the records of the primary database that do not meet the criteria from the synchronization component of the first database system wherein the synchronization component has access to records belonging to the first tenant that are not hidden.
2. A computer-implemented system for selective synchronization of linked records comprising:
one or more storage devices; and
a processor;
receives a criteria for a primary database comprising records belonging to a first tenant, wherein one or more of the records of the primary database are linked to records of a first instance database that is part of a first database system and wherein the criteria comprises the inclusion of an expression or value in at least one specified field of a record, wherein the criteria is received through a user interface,
determines one or more of the records of the primary database that meet the criteria by determining that each of the one or more of the records of the primary database comprise the expression or value of the criteria in the specified field,
synchronizes the one or more of the records of the primary database that meet the criteria with the first instance database:
for a record in the primary database that is one of the one or more records that is linked to a record of the first instance database, synchronizing record data between the record in the primary database and the record in the first instance database to which the record in the primary database is linked,
for a record in the primary database that is not one of the one or more records that is linked to a record of the first instance database, generating a new record in the first instance database using record data from the record in the primary database and linking the new record in the first instance database to the record in the primary database, and;
prevents the synchronization of records of the primary database that do not meet the criteria by limiting the visibility of the records of the primary database that do not meet the criteria to a synchronization component of the first database system by hiding, by a primary application of the primary database, the records of the primary database that do not meet the criteria from the synchronization component of the first database system wherein the synchronization component has access to records belonging to the first tenant that are not hidden.
3. A system comprising: one or more computers and one or more storage devices storing instructions which are operable, when executed by the one or more computers, to cause the one or more computers to perform operations comprising:
receiving a criteria for a primary database comprising records belonging to a first tenant, wherein one or more of the records of the primary database are linked to records of a first instance database that is part of a first database system and wherein the criteria comprises the inclusion of an expression or value in at least one specified field of a record, wherein the criteria is received through a user interface;
determining one or more of the records of the primary database that meet the criteria by determining that each of the one or more of the records of the primary database comprise the expression or value of the criteria in the specified field;
synchronizing the one or more of the records of the primary database that meet the criteria with the first instance database:
for a record in the primary database that is one of the one or more records that is linked to a record of the first instance database, synchronizing record data between the record in the primary database and the record in the first instance database to which the record in the primary database is linked,
for a record in the primary database that is not one of the one or more records that is linked to a record of the first instance database, generating a new record in the first instance database using record data from the record in the primary database;
and linking the new record in the first instance database to the record in the primary database; and
preventing the synchronization of records of the primary database that do not meet the criteria by limiting the visibility of the records of the primary database that do not meet the criteria to a synchronization component of the first database system by hiding, by a primary application of the primary database, the records of the primary database that do not meet the criteria from the synchronization component of the first database system wherein the synchronization component has access to records belonging to the first tenant that are not hidden.