The software components Database Export (FSCDBEXP) and Database Export (Virtual Application) (FSCVDBEXP) from the software product Fabasoft Folio/Data allow the export of Fabasoft Folio objects to a relational database.
There are two ways to carry out the export:
- Read objects from the standard Fabasoft Folio Kernel Interfaces
A Fabasoft Folio query is generated and object data is fetched through standard attribute access. The values are written to the target database in chunks of 1000 objects at a time. The Fabasoft Folio security model is recognized and GET methods are used to compute properties.
- Direct access to Fabasoft Folio COO Service database
Database export issues queries directly to the source database of the Fabasoft Folio COO Service to get the source data. Values are written in chunks of 10000 lines to the target database. The Fabasoft Folio security model is ignored and no methods are triggered to evaluate computed properties.
This document describes the export of Fabasoft Folio objects into a Microsoft SQL Server database.