Script
This tab is used to insert a JSON script when creating the model to distribute for any kind of source database.
This JSON script which will be stored on a streaming system (e.g. Kafka or Kinesis) so that it can easily be used by another business process, or sent to a Snowflake target database.
The JSON structure is in multi-blocks. It includes static and dynamic parts.
It is user-defined. No specific predefined pattern has to be followed.
Example of script:
"flowFuncName": "RAW_CBR_SF",
"flowTechName": {
"db": {
"alias": "VENUS",
"server": "VENUS.server",
"instance": "",
"base": "",
"engine": "AS400",
"source": "",
"zone": "",
"techName": ""
},
"flatfile": {
"serverType": "",
"connexionString": "",
"sourceFolder": "",
"souceApplication": "",
"techName": ""
},
"realtime": {
"siteName": "",
"engine": "",
"captor": "",
"sourceApplication": "",
"techName": ""
}
},
"instanceType": "",
"modType": {
mod: "",
"batchNumber": ""
},
"eventTimestamp": "#FC.JRNDATTIM#",
"flowTimestamp": " ",
"transformTimestamp": " ",
"eventUniqueReferenceID": " ",
"eventType": "INSERT",
"sourceReference": {
"table": "",
"filename": "",
"realtime": ""
},
"schemaVersion": "",
"data": {
#O.DATA#
},Dynamic parts are:
|
|
|---|---|
|
Standard variable that contains all the desired columns from the source table and the O. buffer of the transformation tool. Its output structure is as follows: { "column1_alpha":"xxxxxxx", "column2_num":-999.999, "column3_date":"20201201" } |
System variable that contains the date and time of the transaction for the table. It can be found in the S. buffer of the transformation tool. |