etl for couchdb to MySQL - kwantu/platformconfiguration GitHub Wiki

back

#Setting up ETL for elasticSearch to MySQL

Defining the table names and structures from the Configuration files

There is an <etl/mysql> tag in the configuration file that holds the settings needed to generate tables and the inserts. These options have the following parameters

Attribute name Attribute type Is Required? Default value Description
tableName xs:string true If this is present, use the tablename specified here for the core table
tableCode xs:string false This is a prefix code that is added to the repeat structure for repeat (detail tables)
primaryKey xs:string true uuid This specified which field should be the primary key here. uuid means that the document UUID will become the primary key for the record
ignore xs:boolean false This is set to true if this should not be transferred to the database
addProfile xs:string true true This is a prefix code that is added to the repeat structure for repeat (detail tables)
addSubProfile xs:string true false This is a prefix code that is added to the repeat structure for repeat (detail tables)
addCommunity xs:string true true This is a prefix code that is added to the repeat structure for repeat (detail tables)
addUUID xs:string true false This specifies that a UUID field should be added to the table as a key. Set to false if the default UUID is the primary key
addAppId xs:string true false This specifies if the appid should be added to the table. Only needed if the SDO is used in multiple applications and you want to be able to separate them

Here is an example of the tag with some data

<etl>
   <mysql tableName="EDV_ENTERPRISES" addProfile="true" addSubProfile="false" addCommunity="true" addUUID="true" primaryKey="uuid"/>
</etl>
⚠️ **GitHub.com Fallback** ⚠️