公开(公告)号：US20230091775A1

公开(公告)日：2023-03-23

申请号：US17479849

申请日：2021-09-20

Applicant: salesforce.com, Inc.

Inventor： Ignacio Manzano ,  Gustavo Battistoni ,  Luis Contreras ,  Ezequiel Block ,  Daniel Fujii ,  Rodrigo Pazos ,  Tomas Fox

IPC: G06F16/28 ,  G06F16/21

Abstract: A computer-based system may be configured to collect metadata for each source and target defined for a data pipeline and formatting information (e.g., schemas, transformations, etc.) associated with each entity and field. During the definition of the pipeline, how the data will end up in the target may be defined, for example, by a user of the computer-based system via a GUI/interface and/or the like. Information (e.g., modification information, etc.) describing how the data will end up in the target may be defined, stored, and accessed to determine and/or track over which fields and entities are affected by the user-defined mutations and over which schemas. Lineage information (e.g., a genealogical tree, data lineage tracing, etc.) describing a data, version, and transformation may be generated and used to determine a source for a data record, how changes to the data record are related, how lineage evolved, and/or the like.

公开(公告)号：US20230089365A1

公开(公告)日：2023-03-23

申请号：US17479952

申请日：2021-09-20

Applicant: salesforce.com, inc.

Inventor： Ignacio Agustin MANZANO ,  Jiang WU ,  Daniel Fujii ,  Rodrigo Pazos ,  Ezequiel Block ,  Luis Contreras

IPC: G06F16/25 ,  G06F9/54 ,  G06F16/28 ,  G06F16/21

Abstract: Disclosed herein are system, method, and device embodiments for a data bridge adapter in a data integration platform that models any application programming interface as an entity-relationship model. This technique allows an individual using an integration platform to map and transform the entity-relationship model without having to create any custom code. The user may specify target parameters as part of an ETL process, and the entity relationship model may allow appropriate data and API calls to be generated to pass the data to the specified target. By creating an entity-relationship model from any API, the technique further supports versioning, schema change resolution, compatibility detection and other features. Furthermore, data visualization software may use the entity-relationship model to allow users to explore and analyze the data represented in the entity-relationship model.