Incremental and Fast Extraction of Bizview Planning Data

Bizview stores all planning data within the Bizview SQL Server database. But to enable easy access to the planning data, Bizview provides a database extraction mechanism in the form of a procedure that can be used in other systems load script. With just one line of code in a load script, it's possible to extract planning data.

The example above retrieves the data for company 10, budget version "B1", and only "AMOUNT", per month.

If the Bizview model contains much data, it's possible to increase other systems reload speed by extracting only the Bizview data that has changed from the last reload (incremental load, 'insert-only'). By adding an application code, for example "My App" to the procedure, only new and updated data from last reload by the "MyApp"- application will be delivered (Bizview keeps track per application the delta between each reload).

It's also possible to limit the extraction by providing other parameters. For example, only extract specific time intervals etc.