DATAEXPORTENABLEBATCHINSERT

This Essbase configuration setting specifies whether to use the batch-insert method, instead of the default row-insert method, when the DATAEXPORT calculation command is used to export data for direct insertion into a relational database.

The DATAEXPORTENABLEBATCHINSERT and DEXPSQLROWSIZE configuration settings apply to block storage cubes only.

DATAEXPORTENABLEBATCHINSERT TRUE | FALSE

TRUE—Enables batch insert of exported data into a relational database
FALSE—(Default) Inserts exported data row-by-row into a relational database

Description

When DATAEXPORTENABLEBATCHINSERT is set to TRUE, Essbase determines whether the relational database and the ODBC driver permit batch insert. If they do, Essbase uses the batch-insert method, and, thus, performance is optimized.

Essbase determines the batch size; however, you can control the number of rows (from 2 to 1000) that are inserted at one time by using the DEXPSQLROWSIZE configuration setting.

If Essbase cannot determine whether the relational database and the ODBC driver support batch insert, it uses the row-insert method, and DEXPSQLROWSIZE (if set) is ignored.

When DATAEXPORTENABLEBATCHINSERT is set to FALSE, an INSERT command is called for each row of exported data, and, thus, performance is slowed.

Notes

If DATAEXPORTENABLEBATCHINSERT is set to TRUE and DEXPSQLROWSIZE is set to 1, batch insert is disabled (as a DEXPSQLROWSIZE setting of 1 inserts one row at a time).
When using DATAEXPORT to export data for direct insertion into a relational database:
- The table to which the data is to be written must exist prior to the data export
- Table and column names cannot contain spaces