Creating a test dataset with financial data - Cloud

Talend Cloud Pipeline Designer Getting Started Guide

EnrichVersion
Cloud
EnrichProdName
Talend Cloud
EnrichPlatform
Talend Pipeline Designer
task
Deployment > Deploying > Executing Pipelines
Design and Development > Designing Pipelines
Talend Pipeline Designer allows you to create a dataset based on a schema that you enter manually.

Procedure

  1. In the Add a new dataset panel, give a name to your test dataset, financial data for example and select Test connection (previously created) as the connection in which you want to add your data.
  2. Add a description if needed, and select the format of your data: in this case, select JSON.
  3. In the values area, copy-paste the content of the sample data.
    {
      "transaction": {
        "id": "0",
        "this_account": {
          "id": "1001",
          "bank_routing": {
            "bscheme": "Bank_ID",
            "address": "gh.29.uk"
          },
          "account_routing": {
            "ascheme": "IBAN",
            "address": "GB76LFZB49988909369549"
          },
          "holders": [
            {
              "name": "OBP",
              "is_alias": true
            }
          ]
        },
        "other_account": {
          "id": "String",
          "holder": {
            "name": "OBP",
            "is_alias": true
          },
          "bank_routing": {
            "bscheme": "Bank_ID",
            "address": "gh.29.uk"
          },
          "account_routing": {
            "ascheme": "IBAN",
            "address": "GB96YKDK59692689157588"
          }
        },
        "details": {
          "type": "AC",
          "description": "OBP",
          "posted": "2018-03-28T04:23:33.000Z",
          "completed": "2018-03-18T12:23:17.000Z",
          "new_balance": {
            "currency": "EUR",
            "amount": 71
          },
          "value": {
            "currency": "EUR",
            "amount": 81
          }
        }
      }
    }
    {
      "transaction": {
        "id": "1",
        "this_account": {
          "id": "1002",
          "bank_routing": {
            "bscheme": "Bank_ID",
            "address": "gh.29.fr"
          },
          "account_routing": {
            "ascheme": "IBAN",
            "address": "FR8513439527444624681766695"
          },
          "holders": [
            {
              "name": "OBP",
              "is_alias": true
            }
          ]
        },
        "other_account": {
          "id": "String",
          "holder": {
            "name": "OBP",
            "is_alias": true
          },
          "bank_routing": {
            "bscheme": "Bank_ID",
            "address": "gh.29.uk"
          },
          "account_routing": {
            "ascheme": "IBAN",
            "address": "FR8077386641683499174588483"
          }
        },
        "details": {
          "type": "DC",
          "description": "OBP",
          "posted": "2018-03-07T13:42:55.000Z",
          "completed": "2018-03-04T17:59:04.000Z",
          "new_balance": {
            "currency": "EUR",
            "amount": 100
          },
          "value": {
            "currency": "EUR",
            "amount": 63
          }
        }
      }
    }
    {
      "transaction": {
        "id": "2",
        "this_account": {
          "id": "1003",
          "bank_routing": {
            "bscheme": "Bank_ID",
            "address": "op.02.fi"
          },
          "account_routing": {
            "ascheme": "IBAN",
            "address": "FI6476661028523953"
          },
          "holders": [
            {
              "name": "OBP",
              "is_alias": true
            }
          ]
        },
        "other_account": {
          "id": "String",
          "holder": {
            "name": "OBP",
            "is_alias": true
          },
          "bank_routing": {
            "bscheme": "Bank_ID",
            "address": "gh.29.uk"
          },
          "account_routing": {
            "ascheme": "IBAN",
            "address": "FI6889853185824999"
          }
        },
        "details": {
          "type": "DC",
          "description": "OBP",
          "posted": "2018-03-27T07:42:12.000Z",
          "completed": "2018-03-22T16:01:10.000Z",
          "new_balance": {
            "currency": "EUR",
            "amount": 100
          },
          "value": {
            "currency": "EUR",
            "amount": 50
          }
        }
      }
    }
    {
      "transaction": {
        "id": "3",
        "this_account": {
          "id": "1004",
          "bank_routing": {
            "bscheme": "Bank_ID",
            "address": "gh.29.uk"
          },
          "account_routing": {
            "ascheme": "IBAN",
            "address": "GB05UKDA71695820095764"
          },
          "holders": [
            {
              "name": "OBP",
              "is_alias": true
            }
          ]
        },
        "other_account": {
          "id": "String",
          "holder": {
            "name": "OBP",
            "is_alias": true
          },
          "bank_routing": {
            "bscheme": "Bank_ID",
            "address": "gh.29.uk"
          },
          "account_routing": {
            "ascheme": "IBAN",
            "address": "GB65NPZK15493976545773"
          }
        },
        "details": {
          "type": "AC",
          "description": "OBP",
          "posted": "2018-03-03T14:17:09.000Z",
          "completed": "2018-03-14T21:55:15.000Z",
          "new_balance": {
            "currency": "EUR",
            "amount": 99
          },
          "value": {
            "currency": "EUR",
            "amount": 16
          }
        }
      }
    }
    {
      "transaction": {
        "id": "4",
        "this_account": {
          "id": "1005",
          "bank_routing": {
            "bscheme": "Bank_ID",
            "address": "gh.29.de"
          },
          "account_routing": {
            "ascheme": "IBAN",
            "address": "DE89 3704 0044 0532 0130 00"
          },
          "holders": [
            {
              "name": "OBP",
              "is_alias": true
            }
          ]
        },
        "other_account": {
          "id": "String",
          "holder": {
            "name": "OBP",
            "is_alias": true
          },
          "bank_routing": {
            "bscheme": "Bank_ID",
            "address": "gh.29.uk"
          },
          "account_routing": {
            "ascheme": "IBAN",
            "address": "DE89 3704 0044 0532 0130 00"
          }
        },
        "details": {
          "type": "AC",
          "description": "OBP",
          "posted": "2018-03-15T04:53:13.000Z",
          "completed": "2018-03-23T05:13:38.000Z",
          "new_balance": {
            "currency": "EUR",
            "amount": 62
          },
          "value": {
            "currency": "EUR",
            "amount": 80
          }
        }
      }
    }
    {
      "transaction": {
        "id": "5",
        "this_account": {
          "id": "1006",
          "bank_routing": {
            "bscheme": "Bank_ID",
            "address": "gh.29.de"
          },
          "account_routing": {
            "ascheme": "IBAN",
            "address": "DE89 3704 0045 0532 0130 00"
          },
          "holders": [
            {
              "name": "OBP",
              "is_alias": true
            }
          ]
        },
        "other_account": {
          "id": "String",
          "holder": {
            "name": "OBP",
            "is_alias": true
          },
          "bank_routing": {
            "bscheme": "Bank_ID",
            "address": "gh.29.uk"
          },
          "account_routing": {
            "ascheme": "IBAN",
            "address": "DE89 3704 0045 0532 0130 00"
          }
        },
        "details": {
          "type": "DC",
          "description": "OBP",
          "posted": "2018-03-25T13:35:34.000Z",
          "completed": "2018-03-20T11:23:21.000Z",
          "new_balance": {
            "currency": "EUR",
            "amount": 100
          },
          "value": {
            "currency": "EUR",
            "amount": 67
          }
        }
      }
    }
    {
      "transaction": {
        "id": "6",
        "this_account": {
          "id": "1007",
          "bank_routing": {
            "bscheme": "Bank_ID",
            "address": "gh.29.fr"
          },
          "account_routing": {
            "ascheme": "IBAN",
            "address": "FR5537581636921195789485931"
          },
          "holders": [
            {
              "name": "OBP",
              "is_alias": true
            }
          ]
        },
        "other_account": {
          "id": "String",
          "holder": {
            "name": "OBP",
            "is_alias": true
          },
          "bank_routing": {
            "bscheme": "Bank_ID",
            "address": "gh.29.uk"
          },
          "account_routing": {
            "ascheme": "IBAN",
            "address": "FR4432812773642019978325014"
          }
        },
        "details": {
          "type": "AC",
          "description": "OBP",
          "posted": "2018-03-09T07:40:25.000Z",
          "completed": "2018-03-05T18:35:20.000Z",
          "new_balance": {
            "currency": "EUR",
            "amount": 81
          },
          "value": {
            "currency": "EUR",
            "amount": 26
          }
        }
      }
    }
    {
      "transaction": {
        "id": "7",
        "this_account": {
          "id": "1008",
          "bank_routing": {
            "bscheme": "Bank_ID",
            "address": "gh.29.fr"
          },
          "account_routing": {
            "ascheme": "IBAN",
            "address": "FR0927793667926055290687622"
          },
          "holders": [
            {
              "name": "OBP",
              "is_alias": true
            }
          ]
        },
        "other_account": {
          "id": "String",
          "holder": {
            "name": "OBP",
            "is_alias": true
          },
          "bank_routing": {
            "bscheme": "Bank_ID",
            "address": "gh.29.uk"
          },
          "account_routing": {
            "ascheme": "IBAN",
            "address": "FR4977447561846755098777662"
          }
        },
        "details": {
          "type": "DC",
          "description": "OBP",
          "posted": "2018-03-06T09:10:02.000Z",
          "completed": "2018-03-24T07:48:36.000Z",
          "new_balance": {
            "currency": "EUR",
            "amount": 30
          },
          "value": {
            "currency": "EUR",
            "amount": 20
          }
        }
      }
    }
    {
      "transaction": {
        "id": "8",
        "this_account": {
          "id": "1009",
          "bank_routing": {
            "bscheme": "Bank_ID",
            "address": "gh.29.uk"
          },
          "account_routing": {
            "ascheme": "IBAN",
            "address": "GB45NAAG13514531088144"
          },
          "holders": [
            {
              "name": "OBP",
              "is_alias": true
            }
          ]
        },
        "other_account": {
          "id": "String",
          "holder": {
            "name": "OBP",
            "is_alias": true
          },
          "bank_routing": {
            "bscheme": "Bank_ID",
            "address": "gh.29.uk"
          },
          "account_routing": {
            "ascheme": "IBAN",
            "address": "GB08GPQI02436060300396"
          }
        },
        "details": {
          "type": "AC",
          "description": "OBP",
          "posted": "2018-03-13T06:47:43.000Z",
          "completed": "2018-03-19T17:08:47.000Z",
          "new_balance": {
            "currency": "EUR",
            "amount": 29
          },
          "value": {
            "currency": "EUR",
            "amount": 45
          }
        }
      }
    }
    {
      "transaction": {
        "id": "9",
        "this_account": {
          "id": "1010",
          "bank_routing": {
            "bscheme": "Bank_ID",
            "address": "op.02.fi"
          },
          "account_routing": {
            "ascheme": "IBAN",
            "address": "FI6104157151295139"
          },
          "holders": [
            {
              "name": "OBP",
              "is_alias": true
            }
          ]
        },
        "other_account": {
          "id": "String",
          "holder": {
            "name": "OBP",
            "is_alias": true
          },
          "bank_routing": {
            "bscheme": "Bank_ID",
            "address": "gh.29.uk"
          },
          "account_routing": {
            "ascheme": "IBAN",
            "address": "FI9149180342136836"
          }
        },
        "details": {
          "type": "AC",
          "description": "OBP",
          "posted": "2018-03-25T08:01:19.000Z",
          "completed": "2018-03-15T05:18:25.000Z",
          "new_balance": {
            "currency": "EUR",
            "amount": 37
          },
          "value": {
            "currency": "EUR",
            "amount": 85
          }
        }
      }
    }
    Note: The size of the sample cannot exceed 32 kilobytes.
  4. Click VIEW SAMPLE to preview your data.
  5. Click VALIDATE to save your dataset.

Results

On the Datasets page, the new dataset is added to the list and can be used in your pipeline.

To preview it, click its name in the dataset list. You are redirected to the dataset view where you can check that your data is valid.