System and method for providing recommended mappings for use by a mapper in an integration cloud service design time

A method for providing recommended mappings for use by a cloud-based integration service, comprising:

• providing a cloud service, executing on the computer comprising one or more microprocessors, wherein the cloud service comprises:
• a web interface application for creating an integration flow between a source application and a target application, the integration flow using an actual mapping between the source and target applications stored in a database;
• and
• a runtime for executing the integration flow;
• invoking, by the web interface application, a recommendation engine that parses files associated with the integration flow, and stores mapping information of the files associated with the integration flow as one or more mapping records to a database, wherein the database stores one or more other mapping records from a plurality of sources associated with the system, wherein each of the one or more parsed and the one or more other mapping records are stored in the database associated with a rating based on their sources and use frequencies;
• determining, by the recommendation engine, that a particular parsed mapping record to be stored exists in the database;
• updating the particular parsed mapping record in the database by increasing its use frequency;
• presenting by the recommendation engine a recommended mapping between the source and target applications and a rating of the recommended mapping;
• and
• replacing by the recommendation engine the actual mapping between the source and target applications in the database with the recommended mapping as a new actual mapping between the source and target applications based on an acceptance of the recommended mapping.

A non-transitory computer-readable storage medium storing a set of instructions for providing recommended mappings for use by an integration cloud service, said instructions, when executed by one or more processors, causing the one or more processors to perform the steps comprising:

• providing a cloud service, executing on the computer, wherein the cloud service comprises:
• a web interface application for creating an integration flow between a source application and a target application, the integration flow using an actual mapping between the source and target applications stored in a database;
• and
• a runtime for executing the integration flow;
• invoking, by the web interface application, a recommendation engine that parses files associated with the integration flow, and stores mapping information of the files associated with the integration flow as one or more mapping records to a database, wherein the database stores one or more other mapping records from a plurality of sources associated with the system, wherein each of the one or more parsed and the one or more other mapping records are stored in the database associated with a rating based on their sources and use frequencies;
• determining, by the recommendation engine, that a particular parsed mapping record to be stored exists in the database;
• updating the particular parsed mapping record in the database by increasing its use frequency;
• presenting by the recommendation engine a recommended mapping between the source and target applications and a rating of the recommended mapping;
• and
• replacing by the recommendation engine the actual mapping between the source and target applications in the database with the recommended mapping as a new actual mapping between the source and target applications based on an acceptance of the recommended mapping.