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:

`#O.DATA#`	`#FC.JRNDATTIM#`
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.

#O.DATA#

#FC.JRNDATTIM#

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.

Note: Do not forget to include the associated metadata (see Environment metadata).

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here