Systems and methods for exporting, publishing, browsing and installing on-demand applications in a multi-tenant database environment

• US 10,521,211 B2
• Filed: 03/08/2017
• Issued: 12/31/2019
• Est. Priority Date: 09/09/2005
• Status: Active Grant

• Current Assignee: Salesforce.com, Inc.
• Original Assignee: Salesforce.com, Inc.
• Inventors: Brooks, David, Tucker, Lewis Wiley, Jasik, Benji, Mason, Timothy, Bezar, Eric David, Wong, Simon, Chasman, Douglas, Tzuo, Tien, Hansma, Scott, Gross, Adam, Tamm, Steven
• Primary Examiner(s): Cao, Phuong Thao
• Application Number:
  US15/453,539
• Publication Number:
  US 20170177326A1
• Time in Patent Office: 1,028 Days
• Field of Search: 707756
• CPC Class Codes: G06F 15/173 using an interconnection network, e.g. matrix, shuffle, pyramid, star, snowflake
• CPC Class Codes: G06F 16/176 Support for shared access to files; File sharing support
• CPC Class Codes: G06F 16/211 Schema design and management
• CPC Class Codes: G06F 16/214 Database migration support
• CPC Class Codes: G06F 16/2329 using versioning
• CPC Class Codes: G06F 16/24573 using data annotations, e.g. user-defined metadata
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
• CPC Class Codes: G06F 16/289 Object oriented databases
• CPC Class Codes: G06F 16/40 of multimedia data, e.g. slideshows comprising image and additional audio data retrieval of still image data G06F16/50; retrieval of audio data G06F16/60; retrieval of video data G06F16/70
• CPC Class Codes: G06F 16/904 Browsing; Visualisation therefor for navigating the web G06F16/954; browsing optimisation for the web G06F16/957
• CPC Class Codes: G06F 16/9566 URL specific, e.g. using aliases, detecting broken or misspelled links
• CPC Class Codes: G06F 16/972 Access to data in other repository systems, e.g. legacy data or dynamic Web page generation
• CPC Class Codes: G06F 3/0482 Interaction with lists of selectable items, e.g. menus
• CPC Class Codes: G06F 3/0483 Interaction with page-structured environments, e.g. book metaphor
• CPC Class Codes: G06F 8/60 Software deployment
• CPC Class Codes: G06F 8/61 Installation
• CPC Class Codes: G06F 8/658 Incremental updates; Differential updates
• CPC Class Codes: H04L 12/50 Circuit switching systems, i.e. systems in which the path is physically permanent during the communication
• CPC Class Codes: H04L 63/1433 Vulnerability analysis
• CPC Class Codes: H04L 67/34 : involving the movement of software or configuration parameters network booting or remote initial program loading [RIPL] G06F9/4416

Abstract

In accordance with embodiments, there are provided mechanisms and methods for creating, exporting, viewing and testing, and importing custom applications in a multitenant database environment. These mechanisms and methods can enable embodiments to provide a vehicle for sharing applications across organizational boundaries. The ability to share applications across organizational boundaries can enable tenants in a multi-tenant database system, for example, to easily and efficiently import and export, and thus share, applications with other tenants in the multi-tenant environment.

Claims

1. A computer-based method of transporting an application package to at least one server of a hosted online service provider system, the method including:

preparing an application package for an application created by a source organization that is a tenant of the hosted online service provider system using an application builder, the application package including;

(i) at least one object implementing a customer relationship management (CRM) solution to install onto the at least one server of the hosted online service provider system,

(ii) metadata customizing one or more fields of the at least one object according to attributes imported into the application package, and

(iii) logic implemented with code that executes in conjunction with the at least one object to implement the application; and

publishing the application package as a customer specific solution for accessing and installing by one or more target organizations onto the at least one server of the hosted online service provider system;

marking the at least one object as being manageable to enable customization of the at least one object by the one or more target organizations; and

transporting the application package to the at least one server of the hosted online service provider system to enable a user of the one or more target organizations to select to import the application package to the one or more target organizations,

wherein the hosted online service provider system is a multi-tenant system and the one or more target organizations and the source organization are separate tenants of the hosted online service provider system.

2. The method of claim 1, further including detecting an attempt to delete an object that has been transported;

and blocking the attempt to delete the object.

3. The method of claim 1, further including maintaining a version history of transported objects.

4. The method of claim 1, wherein the application package further includes one or more files for customizing the application package at the one or more target organizations.

5. The method of claim 1, further including:

detecting a conflict between existing data and a data portion for an object to be transported; and

blocking transporting the conflicting data.

6. The method of claim 1, further including:

checking whether a transport user has appropriate organization permissions to transport the application package.

7. The method of claim 1, further including:

prompting a transport user for mapping between source organization specific references in the application package to values appropriate to the one or more target organizations.

8. The method of claim 1, further including migrating adaptations using a web format document.

9. The method of claim 1, further including enabling deploying the application package from a test system to a production system.

10. The method of claim 1, further including:

checking a credential indicating whether a transport user is authorized to transport the application package.

11. The method of claim 1, further including:

locking the one or more target organizations during transport thereby preventing inconsistent updates.

12. The method of claim 1, further including:

copying setup data of the application package in a development mode,

thereby enabling a transport user to verify the application functions prior to deploying the application to users.

13. The method of claim 1, further including:

scanning the application package for malicious functionality.

14. The method of claim 1, further including:

restricting a transport user from changing setup data after the application package is transported.

15. A computer system to execute a database system to service an application builder in communication with at least one server of a hosted online service provider system, the computer system comprising:

a non-transitory computer-readable medium having stored therein the database system and the application builder; and

a processor coupled to the non-transitory computer-readable medium, the processor to execute the database system to;

prepare an application package for an application created by a source organization that is a tenant of the hosted online service provider system using the application builder, the application package including;

(i) at least one object implementing a customer relationship management (CRM) solution to install onto the at least one server of the hosted online service provider system,

(ii) metadata customizing one or more fields of the at least one object according to attributes imported into the application, and

(iii) logic implemented with code that executes in conjunction with the at least one object to implement the application; and

publish the application package as a customer specific solution for accessing and installing by one or more target organizations onto the at least one server of the hosted online service provider system;

mark the at least one object as being manageable to enable customization of the at least one object by the one or more target organizations; and

transport the application package to the at least one server of the hosted online service provider system to enable a user of the one or more target organizations to select to import the application package to the one or more target organizations,

wherein the hosted online service provider system is a multi-tenant system and the one or more target organizations and the source organization are separate tenants of the hosted online service provider system.

16. A non-transitory computer readable storage medium impressed with computer program instructions, the instructions, when executed on a processor, implement a method including:

preparing an application package for an application created by a source organization that is a tenant of the hosted online service provider system using an application builder, the application package including;

(i) at least one object implementing a customer relationship management (CRM) solution to install onto at least one server of the hosted online service provider system,

(ii) metadata customizing one or more fields of the at least one object according to attributes imported into the application, and

(iii) logic implemented with code that executes in conjunction with the at least one object to implement the application; and

publishing the application package as a customer specific solution for accessing and installing by one or more target organizations onto the at least one server of the hosted online service provider system;

marking the at least one object as being manageable to enable customization of the at least one object by the one or more target organizations; and

transporting the application package to the at least one server of the hosted online service provider system to enable a user of the one or more target organizations to select to import the application package to the one or more target organizations,

wherein the hosted online service provider system is a multi-tenant system and the one or more target organizations and the source organization are separate tenants of the hosted online service provider system.

17. The non-transitory computer readable storage medium of claim 16, further including detecting an attempt to delete an object that has been transported;

and blocking the attempt to delete the object.

18. The non-transitory computer readable storage medium of claim 16, further including maintaining a version history of transported objects.

19. The non-transitory computer readable storage medium of claim 16, wherein the application package further includes one or more files for customizing the application package at the one or more target organizations.

20. The non-transitory computer readable storage medium of claim 16, further including:

detecting a conflict between existing data and a data portion for an object to be transported; and

blocking transporting the conflicting data.