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 | |
extensions.[0].pluginId=fr.cantor.c4i.SQLDelivery
extensions.[0].configAssetId=C4I-Configuration
extensions.[0].connection=mysql
extensions.[0].prefixTableNamesWithContextId=true
extensions.[0].batchSize=100
extensions.[0].isStepOwner=true
extensions.[0].deleteElementsNotMatchingFilters=false
extensions.[0].emptyDatabaseBeforeImport=false
pluginId=fr.cantor.c4i.SQLDelivery
configAssetId=/Path/to/C4I/Configuration.yml
connection=mysql
prefixTableNamesWithContextId=true
batchSize=100
isStepOwner=true
deleteElementsNotMatchingFilters=false
emptyDatabaseBeforeImport=false
licenseAssetId=/Path/to/C4I/License.cat
cacheConfig=/Path/to/JCS/Config.ccf
mysql.connectionUrl=jdbc:mariadb://localhost:3307/step
mysql.username=c4i
