Business Objects Software Limited

Sap Se

Sap France S.a.

Sap Ag

Wu Cao

Anil Samudrala

Vikram Kunniyur

YunKei Tsang

Freda Xu

Sridhar Ganti

Andrey Belyy

Hui Xu

Balaji Gadhiraju

Monfor Yee

Alexander Ocher

Min He

Awez Syed

David Kung

Enping Tu

Frank Buchholz

Yung-Yin Chen

Werner Daehn

MonFor Yee

Xiaofan Zhou

Ben Hofmans

Chien Ming Yueh

Thomas Herdan

Kurinchi Kumaran

Duc Tran

A method and system of retrying to load data from a data source to a cloud target system are disclosed. A server receives a first data packet from a device via a communication network. The first data packet comprises first data. The server stores the first data in one or more databases. The server receives a second data packet from the device. The second data packet comprises second data and is marked with a retry flag. The server determines that the second data packet has been marked with the retry flag, and performs an upsert operation with the second data in the second data packet based on the determining that the second data packet has been marked with the retry flag.

Retry mechanism for data loading from on-premise datasource to cloud

A method and system of retrying to load data from a data source to a cloud target system are disclosed. A client device sends a data packet to a cloud server via a communication connection. The data packet comprises data. The client device receives an indication of a failure in the communication connection. The client device configures, in response to receiving the indication of the failure in the communication connection, the data packet to prompt the cloud server to perform an upsert operation with the data in the data packet. The client device sends the configured data packet to the cloud server. The client device can wait a predetermined amount of time before sending the configured data packet to the cloud server.

Systems and methods for resuming data transformations, such as broken or otherwise unsuccessful data transformations, are described. In some example embodiments, the systems and methods receive a message that indicates a broken data transformation of a data table between a source database and a destination database, identify a maximum and/or largest and greatest value for a date attribute contained within an index column for all rows of the data table that were successfully loaded to the destination database during the data transformation, and select a group of rows of data of the data table stored in the source database by querying the source database to identify rows that include a value for the date attribute that is greater than the identified value.

Resuming big data transformations

A computer-implemented method of profiling a data set in a parallel processing environment includes vertically partitioning an initial data set. One or more attribute subsets are then profiled. A list of subjects is generated each corresponding to a specific attribute value identified in the profiling. Values of multiple attributes are extracted for each identified subject, and the sample results are assembled and merged.

Profiling in a massive parallel processing environment

A system and method of querying data. The method includes transforming first data according to a unified data model. The unified data model has a hierarchical structure with tree nodes and leaf nodes. A leaf node contains a table. The method further includes executing a unified data model query on the first data (having been transformed) to result in second data. The method further includes outputting the second data.

System and method of querying data

Methods, systems, and apparatuses for processing function calls using a hooking routines to perform pre-execution tasks are disclosed. A server computer receives a function call including a hooking routine and a request to run a particular function from a client computer. Based on a function group identifier and the credentials of the user or client computer, the server computer can perform various pre-execution tasks. The tasks can be common to all functions in the function group or be customized Both pre-execution tasks can be stored remotely from the client computer, so that updates to the pre-execution task can be made without the need to update computer readable code stored on the client computer. If the pre-execution tasks, such as an authorization, passes, then the server computer can execute the requested function, the server computer can reject or abort the requested function.

System and method for performing centralized common tasks for a set of functions

A computer readable medium with executable instructions to receive a job and correlate a data store with each data source associated with the job. A first configuration profile is associated with the data store. A second configuration profile is specified for the data store. Dependent flows are identified. The dependent flow is updated to include additional configuration information derived from the second configuration profile.

Apparatus and method for creating portable ETL jobs

A dataflow design tool allows users to provide data mappings from source database tables to a target database table. The tool provides metadata-driven views of the database tables and data-driven views of the database tables. Views of the database tables may be flipped between the metadata driven format and the data-driven format.

Alternating between data-driven and metadata-driven view for dataflow design

Disclosed is a user interface on a display for editing data transformations comprising an ETL process. A first display area presents a data representation of a data transformation. A second display area presents a view of input data, and a third display are presents a view of output data. User input to modify the data transformation is received. In response to receiving the user input, the third display area is updated with output data generated by applying the modified data transformation to the input data.

Dataset previews for ETL transforms

A computer readable storage medium includes executable instructions to assess system cache resources, inter-process communication requirements and staging requirements to divide an extract, transform, load (ETL) dataflow task into a plurality of sub-tasks. The sub-tasks are then executed in parallel on distributed resources.

Apparatus and method for dataflow execution in a distributed environment using directed acyclic graph and prioritization of sub-dataflow tasks

Embodiments of the present invention include a computer-implemented systems and methods for accessing metadata across a network. A metadata server receives requests to access a data source from one or more clients. The metadata server is coupled between one or more backend servers and the clients. The backend servers may be coupled to the data sources of interest. The metadata server provides a metadata service proxy for establishing communications with the backend servers and for signaling the backend servers to establish connections to data sources. Data sources may be stateful or stateless. For stateless data sources, the metadata server may dynamically create reusable metadata service provider proxies that receive metadata from metadata service providers on the backend servers. For stateful data sources, unique metadata service provider proxies may be dynamically created and used to service client requests.

Growing community of inventors

Redwood City, CA, United States of America

Wu Cao