Setting up ETL for couchdb to Oracle - kwantu/platformconfiguration GitHub Wiki
#Setting up ETL for elasticSearch to Oracle
There is an <etl/oracle> 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>
<oracle tableName="EDV_ENTERPRISES" addProfile="true" addSubProfile="false" addCommunity="true" addUUID="true" primaryKey="uuid"/>
</etl>