US 11,733,990 B2
Generating software artifacts from a conceptual data model
Lars Martinsson, Sunnyvale, CA (US)
Assigned to Salesforce, Inc., San Francisco, CA (US)
Filed by salesforce.com, inc., San Francisco, CA (US)
Filed on Aug. 27, 2019, as Appl. No. 16/552,755.
Prior Publication US 2021/0064355 A1, Mar. 4, 2021
Int. Cl. G06F 8/61 (2018.01); G06F 16/2458 (2019.01); G06F 16/25 (2019.01)
CPC G06F 8/64 (2013.01) [G06F 16/2458 (2019.01); G06F 16/256 (2019.01)] 17 Claims
OG exemplary drawing
 
1. A computer implemented method, comprising:
receiving, by one or more processors, a conceptual data model that depicts a data landscape comprising an entity and a plurality of platforms;
adding, to the conceptual data model, first metadata comprising platform-specific access requirements for authenticating with each platform in the plurality of platforms and syntactical requirements to create a table and an index on each storage mechanism available in each platform, wherein the platform-specific access requirements indicate authentication protocol information comprising a parameter needed to execute software artifacts in each platform in the plurality of platforms;
automatically creating, by the one or more processors, for each platform in the plurality of platforms, a logical data model comprising second metadata that specifies a particularized syntax to create the entity on each storage mechanism available in each platform using the first metadata;
deriving randomized data based on the first metadata and an entity type corresponding to the entity;
generating, by the one or more processors, for each platform in the plurality of platforms, platform-specific installation scripts and platform-specific data population scripts for each storage mechanism available in each platform based on the second metadata, wherein the platform-specific installation scripts create the entity as one or more data structures in a database and an index on the one or more data structures using the particularized syntax in the second metadata, and wherein the platform-specific data population scripts populate the one or more data structures with the randomized data; and
deploying, by the one or more processors, the one or more data structures into each platform in the plurality of platforms by engaging a service offered by each platform using the platform-specific access requirements and the parameter to execute the platform-specific installation scripts and the platform-specific data population scripts.