Systems and Methods for Performing Data Fixes

1. A method of modifying data stored in a plurality of schemas comprising: receiving a list of a plurality of schemas, the plurality of schemas storing data for a plurality of tenants, wherein data corresponding to different tenants are stored in different schemas in one or more databases; dividing the plurality of schemas into a plurality of batches, each batch comprising a portion of the schemas; for the plurality of batches: automatically, without user intervention, applying a plurality of pre-configured SQL commands to the portion of the schemas in parallel; and returning a plurality of results in response to executing the pre-configured SQL commands, the plurality of results indicating that the portion of the schemas were either successfully modified or unsuccessfully modified; and receiving an initiation of an application deployment, wherein the application deployment is blocked from starting when the plurality of results indicates at least one schema was unsuccessfully modified, and wherein the application deployment starts when the plurality of results indicates the plurality of batches were successfully modified, wherein the list of the plurality of schemas is received from a schema manager, the schema manager comprising a separate encrypted object storing administrative credentials for the plurality of schemas, the schema manager providing access to the plurality of schemas to apply the plurality of pre-configured SQL commands without exposing the administrative credentials to a user, and wherein automatically applying a plurality of pre-configured SQL commands to the portion of the schemas in parallel comprises: generating a thread for each schema of the portion of the schemas; connecting, by each thread, to one or more databases using the administrative credentials from the schema manager; and applying, by each thread, the plurality of pre-configured SQL commands to a particular one of the portion of the schema.

2. The method of claim 1, wherein the data stored in each schema is master data corresponding to each tenant, and wherein the master data comprises a uniform set of identifiers and attributes that uniquely describe each tenant for processing operations that identify an identity of a particular tenant.

3. The method of claim 1, wherein the plurality of schemas has a same structure of schemas comprising tables and views, and wherein different schemas have different connection credentials.

4. The method of claim 1, wherein the pre-configured SQL commands are predefined queries comprising placeholders for input values and are not recompiled on each execution.

5. The method of claim 4, wherein the pre-configured SQL commands are SQL data manipulation language (DML) commands that modify data and do not modify a structure of the schema.

6. The method of claim 4, wherein the pre-configured SQL commands are stored in a single file, the file further comprising values for running the application.

7. The method of claim 1, wherein the application deployment is executed through one or more containers and said method of modifying data is executed as a job separate from the execution of the one or more containers.

8. The method of claim 1, further comprising, before receiving the initiation of the application deployment, and when one of plurality of results indicates that one or more schemas were unsuccessfully modified, automatically re-applying the plurality of pre-configured SQL commands to the one or more schemas.

9. The method of claim 1, wherein the received list of a plurality of schemas is a pre-determined list of schemas.

10. The method of claim 1, wherein the plurality of schemas are stored in a same database.

11. The method of claim 1, wherein each schema is stored in a different database.

12. A computer system comprising: at least one processor; at least one non-transitory computer readable medium storing computer executable instructions that, when executed by the at least one processor, cause the computer system to perform a method of modifying data comprising: receiving a list of a plurality of schemas, the plurality of schemas storing data for a plurality of tenants, wherein data corresponding to different tenants are stored in different schemas in one or more databases; dividing the plurality of schemas into a plurality of batches, each batch comprising a portion of the schemas; for the plurality of batches: automatically, without user intervention, applying a plurality of pre-configured SQL commands to the portion of the schemas in parallel; and returning a plurality of results in response to executing the pre-configured SQL commands, the plurality of results indicating that the portion of the schemas were either successfully modified or unsuccessfully modified; and receiving an initiation of an application deployment, wherein the application deployment is blocked from starting when the plurality of results indicates at least one schema was unsuccessfully modified, and wherein the application deployment starts when the plurality of results indicates the plurality of batches were successfully modified, wherein the list of the plurality of schemas is received from a schema manager, the schema manager comprising a separate encrypted object storing administrative credentials for the plurality of schemas, the schema manager providing access to the plurality of schemas to apply the plurality of pre-configured SQL commands without exposing the administrative credentials to a user, and wherein automatically applying a plurality of pre-configured SQL commands to the portion of the schemas in parallel comprises: generating a thread for each schema of the portion of the schemas; connecting, by each thread, to one or more databases using the administrative credentials from the schema manager; and applying, by each thread, the plurality of pre-configured SQL commands to a particular one of the portion of the schema.

13. The computer system of claim 12, wherein the data stored in each schema is master data corresponding to each tenant, and wherein the master data comprises a uniform set of identifiers and attributes that uniquely describe each tenant for processing operations that identify an identity of a particular tenant.

14. The computer system of claim 12, wherein the pre-configured SQL commands are predefined queries comprising placeholders for input values and are not recompiled on each execution.

15. A non-transitory computer-readable medium storing computer-executable instructions that, when executed by at least one processor, perform a method of modifying data, the method comprising: receiving a list of a plurality of schemas, the plurality of schemas storing data for a plurality of tenants, wherein data corresponding to different tenants are stored in different schemas in one or more databases; dividing the plurality of schemas into a plurality of batches, each batch comprising a portion of the schemas; for the plurality of batches: automatically, without user intervention, applying a plurality of pre-configured SQL commands to the portion of the schemas in parallel; and returning a plurality of results in response to executing the pre-configured SQL commands, the plurality of results indicating that the portion of the schemas were either successfully modified or unsuccessfully modified; and receiving an initiation of an application deployment, wherein the application deployment is blocked from starting when the plurality of results indicates at least one schema was unsuccessfully modified, and wherein the application deployment starts when the plurality of results indicates the plurality of batches were successfully modified, wherein the list of the plurality of schemas is received from a schema manager, the schema manager comprising a separate encrypted object storing administrative credentials for the plurality of schemas, the schema manager providing access to the plurality of schemas to apply the plurality of pre-configured SQL commands without exposing the administrative credentials to a user, and wherein automatically applying a plurality of pre-configured SQL commands to the portion of the schemas in parallel comprises: generating a thread for each schema of the portion of the schemas; connecting, by each thread, to one or more databases using the administrative credentials from the schema manager; and applying, by each thread, the plurality of pre-configured SQL commands to a particular one of the portion of the schema.

16. The non-transitory computer-readable medium of claim 15, wherein the data stored in each schema is master data corresponding to each tenant, and wherein the master data comprises a uniform set of identifiers and attributes that uniquely describe each tenant for processing operations that identify an identity of a particular tenant.