Criteria-based API selection for data access

An apparatus for data access, comprising:

• a network interface controller (NIC);
• and
• a processor configured:
• to identify a set of tables in a database to be accessed by an application,
• to identify first and second application programming interface (API) calls having different, respective access properties for accessing records in the tables via an API, wherein the first API call is subject to a predefined limit on calls made during a specified time period,
• to count respective numbers of the records in the tables,
• to partition the set of tables into first and second subsets by adding the tables to the first subset responsively to the respective numbers until the tables in the first subset reach the predefined limit and adding the remaining tables to the second subset,
• to access the records in the first subset of the tables by conveying, by the application over a data network via the NIC, the first API call to the API, and
• to access the records in the second subset of the tables by conveying, by the application over a data network via the NIC, the second API call to the API.

A computer software product for data access, the product comprising a non-transitory computer-readable medium, in which program instructions are stored, which instructions, when read by a computer, cause the computer:

• to identify a set of tables in a database to be accessed by an application;
• to identify first and second application programming interface (API) calls having different, respective access properties for accessing records in the tables via an API, wherein the first API call is subject to a predefined limit on calls made during a specified time period;
• to count respective numbers of the records in the tables;
• to partition the set of tables into first and second subsets by adding the tables to the first subset responsively to the respective numbers until the tables in the first subset reach the predefined limit and adding the remaining tables to the second subset;
• to access the records in the first subset of the tables by conveying, by the application, the first API call to the API;
• and
• to access the records in the second subset of the tables by conveying, by the application, the second API call to the API.