Abstract: Confirming enforcement of business rules specified in a data access tier of a multi-tier enterprise application. In an embodiment, a testing tool programmatically identifies the attributes in the data access tier that are accessible from a set of higher/interface tiers and provides the identified attributes to a user using a suitable interface. The user then specifies a set of test cases based on the provided attributes, with each test case including data elements associated with respective attributes and an expected result if the data elements are sought to be stored in the respective attributes of a data storage. The testing tool determines a validation result of operation of business rules against the combination of data elements and respective attributes. The testing tool then indicates that the business rules are enforced as desired, if the validation result is the same as the expected result.

Abstract: Presented herein are systems and methods that facilitate the portability and management of user data maintained at two or more services. In embodiments, a configurable profile management interface or interfaces are provided to a user, which enable the user to identify data elements that may be maintained across one or more services. In embodiments, a user has the ability to set precedence values by identifying which elements from which service or services should be considered as sources of truth. In embodiments, those sources of truth may be used to propagate changes to one or more services. In embodiments, the profile synchronization functionality may be incorporated within a human resources (HR) system. In embodiments, the user can also configure a schedule for transferring data, can import some or all of the data, and/or can export all or some of the data.

Abstract: An aspect of the present invention performs offline validation of data in database system for foreign key constraints. In an embodiment, a foreign key constraint defined for a database system is identified and an SQL script designed to verify whether data values stored in a foreign key column of a detail table is present in a primary key column of a master table (corresponding to the identified foreign key constraint), is generated. The SQL script is executed to determine whether the data stored in the database system satisfies the identified foreign key constraint.

Abstract: Confirming enforcement of business rules specified in a data access tier of a multi-tier enterprise application. In an embodiment, a testing tool programmatically identifies the attributes in the data access tier that are accessible from a set of higher/interface tiers and provides the identified attributes to a user using a suitable interface. The user then specifies a set of test cases based on the provided attributes, with each test case including data elements associated with respective attributes and an expected result if the data elements are sought to be stored in the respective attributes of a data storage. The testing tool determines a validation result of operation of business rules against the combination of data elements and respective attributes. The testing tool then indicates that the business rules are enforced as desired, if the validation result is the same as the expected result.

Abstract: Presented herein are systems and methods that facilitate the portability and management of user data maintained at two or more services. In embodiments, a configurable profile management interface or interfaces are provided to a user, which enable the user to identify data elements that may be maintained across one or more services. In embodiments, a user has the ability to set precedence values by identifying which elements from which service or services should be considered as sources of truth. In embodiments, those sources of truth may be used to propagate changes to one or more services. In embodiments, the profile synchronization functionality may be incorporated within a human resources (HR) system. In embodiments, the user can also configure a schedule for transferring data, can import some or all of the data, and/or can export all or some of the data.

Abstract: An aspect of the present invention performs offline validation of data in database system for foreign key constraints. In an embodiment, a foreign key constraint defined for a database system is identified and an SQL script designed to verify whether data values stored in a foreign key column of a detail table is present in a primary key column of a master table (corresponding to the identified foreign key constraint), is generated. The SQL script is executed to determine whether the data stored in the database system satisfies the identified foreign key constraint.