Using the extract to DB task and the publish to DB task, you can use an analysis file to extract data from a DAT file and store it in a database. Unlike the extract to DB task, the publish to DB task allows you to write only calculated columns and info field columns to the database. You can create the analysis file for this in ibaAnalyzer.
To use the task types, you need a corresponding license ibaDatCoordinator-DB . Alternatively, you can use the ibaDatCoordinator-Publish license for the publish task, see Licenses.
Other documentation |
|
|---|---|
 |
Further information on data extraction with ibaAnalyzer can be found in the ibaAnalyzer documentation. |
The task-specific settings are explained below. For all other settings, see General task settings.
Analysis file for extraction
See Task analysis file.
Target
Extract to database/Extract to file
The “Extract to database” option is selected by default.
To extract data into a database, all you need is a PDO file containing all the relevant settings for the extraction. The additional option Extract only "Computed Columns" and "Info Columns” is enabled for the publish to DB task. In this case, ibaAnalyzer ignores the profile settings in the PDO file and extracts only the calculated columns and info columns to the database, but no channel or segment data. So only the "file table" is filled.