MySQL/MariaDB extension

Plugin ID

The plugin ID for MySQL/MariaDB is fr.cantor.c4i.MySQLDelivery

Properties

Property key	Description	Mandatory	Default value
debug	true to display debug log	No	false
host	Host of the MySQL/MariaDB database	Yes
port	Port of the MySQL/MariaDB database	Yes
dbName	The name of the database	Yes
username	The username to connect to the database	No
password	The password to connect to the database in standalone mode only	No
configAssetId	The ID of the asset containing the YAML mappings	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	Yes
emptyDatabaseBeforeImport	true will reset the tables before inserting data. Only use for full IEP	Yes
cacheConfig	The ID of the asset containing the JCS configuration	No

Configuration example

extensions.[0].pluginId=fr.cantor.c4i.MySQLDelivery
extensions.[0].host=localhost
extensions.[0].port=3307
extensions.[0].dbName=step
extensions.[0].username=c4i
extensions.[0].configAssetId=C4I-Configuration
extensions.[0].prefixTableNamesWithContextId=true
extensions.[0].batchSize=100
extensions.[0].isStepOwner=true
extensions.[0].deleteElementsNotMatchingFilters=false
extensions.[0].emptyDatabaseBeforeImport=false

pluginId=fr.cantor.c4i.MySQLDelivery
host=localhost
port=3307
dbName=step
username=c4i
password=secure_password
configAssetId=/Path/to/C4I/Configuration.yml
prefixTableNamesWithContextId=true
batchSize=100
isStepOwner=true
deleteElementsNotMatchingFilters=false
emptyDatabaseBeforeImport=false
licenseAssetId=/Path/to/C4I/License.cat
cacheConfig=/Path/to/JCS/Config.ccf