The plugin ID for SQL is fr.cantor.c4i.SQLDelivery
| Property key | Description | Mandatory | Default value |
|---|
| configAssetId | The ID of the asset containing the YAML mappings | Yes | |
| connection | The name of the connection in the c4i.properties file | Yes | |
| prefixTableNamesWithContextId | true or false to indicate whether or not to prefix the table names with the context IDs | Yes | |
| batchSize | The maximum number of elements to send in a single query | Yes | |
| isStepOwner | true or false to indicate if STEP can perform table creations and table structure updates or not | Yes | |
| deleteElementsNotMatchingFilters | true or false to indicate if elements not matching filters should be deleted from the database | No | false |
| emptyDatabaseBeforeImport | true will reset the tables before inserting data. Only use for full IEP | No | false |
| cacheConfig | The ID of the asset containing the JCS configuration | No | |
| displayPerfStat | true to display performance statistics (see Performance statistics dedicated page) | No | false |
| Property key | Description | Mandatory | Default value |
|---|
| connectionUrl | The SQL database connection URL | Yes | |
| username | The username to connect to the database | No | |
| password | The password to connect to the database in standalone mode only | No | |
