公开(公告)号：US12197456B2

公开(公告)日：2025-01-14

申请号：US17479952

申请日：2021-09-20

Applicant: Salesforce, Inc.

Inventor： Ignacio Agustin Manzano ,  Jiang Wu ,  Daniel Fujii ,  Rodrigo Pazos ,  Ezequiel Block ,  Luis Contreras

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

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.

公开(公告)号：US12277133B2

公开(公告)日：2025-04-15

申请号：US18080268

申请日：2022-12-13

Applicant: Salesforce, Inc.

Inventor： Ignacio Agustin Manzano ,  Subhash Periasamy ,  Berkay Polat ,  Anand Nair ,  Udayakumar Dhansingh ,  Vijay Gopalakrishnan ,  Saebom Kwon

IPC: G06F16/20 ,  G06F16/25

Abstract: In the present disclosure, systems and methods are described for allowing a non-code user to create to transform a database in an ETL pipeline. Specifically, as disclosed herein, a user can take a database and receive a ruleset to apply to the database in an ETL pipeline. The data linting system may take the database and extract a schema and a data sample from it. Further, the data linting system may use the schema and data sample to create two rulesets. With these rulesets, the data linting system combines them to create a final ruleset which may be validated using the data sample. The data linting system then sends the final ruleset and the validation report to the user. With this system, the user only needs to give it a database and will receive a ruleset that is able to be immediately used in an ETL pipeline.