Patent ID: 7865459

Claim:
A computer-implemented method comprising: receiving, at a data integration component, a first change and a subsequent second change to transactional data of one or more data objects in a first data model of a service-oriented transactional system, the service-oriented transactional system comprising a first data format, the data integration component comprising a data transformation interface comprising a program agent and a data transfer interface comprising an agent controller; transforming, by the program agent, the transactional data of the data object from the first format into a second format of a business data warehousing system that comprises a business intelligence view derived from the first data model, the business intelligence view relating to the data object in the first data model such that changing the data object induces changing the business intelligence view; creating, by the program agent, a first delta record indicating first changes from a current instance of the business intelligence view caused by the first change to the transactional data, and a second delta record indicating second changes from the current instance of the business intelligence view caused by the second change to the transactional data; joining the second delta record with the first delta record and any other previously created delta records that have not yet been applied to the current instance of the business intelligence view, the joining generating a joined delta record; calculating an aggregated new instance of the business intelligence view based on the current instance of the business intelligence view and the joined delta record; determining, by the agent controller, one or more locations to write the transactional data for transfer to the business data warehousing system based on the aggregated new instance of the business intelligence view; and transferring, by the agent controller interacting with the program agent, the transactional data of the data object in the second format from the service-oriented transactional system to the one or more locations at the business data warehousing system.