Erstellen eines Testdatensatzes mit Finanzdaten - Cloud

Einführungshandbuch für Talend Cloud Pipeline Designer

Version
Cloud
Language
Deutsch (Deutschland)
Product
Talend Cloud
Module
Talend Pipeline Designer
Content
Design und Entwicklung > Konzeption von Pipelines
Implementierung > Implementierung > Pipeline-Ausführung
Talend Pipeline Designer ermöglicht es Ihnen, einen Datensatz basierend auf einem Schema zu erstellen, das Sie manuell eingeben.

Prozedur

  1. Geben Sie im Fensterbereich Add a new dataset (Neuen Datensatz hinzufügen) einen Namen für den Testdatensatz an (z. B. financial data (Finanzdaten)) und wählen Sie test connection (Testverbindung) (zuvor erstellt) als die Verbindung aus, in der Sie Ihre Daten hinzufügen möchten.
  2. Fügen Sie bei Bedarf eine Beschreibung hinzu und wählen Sie das Format der Daten aus: Wählen Sie in diesem Fall JSON aus.
  3. Kopieren Sie im Bereich values (Werte) den Inhalt der Beispieldaten und fügen Sie ihn ein.
    {
      "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
          }
        }
      }
    }
    Anmerkung: Das Sample darf nicht größer sein als 32 Kilobyte.
  4. Klicken Sie auf VIEW SAMPLE (SAMPLE ANZEIGEN), um eine Vorschau der Daten anzuzeigen.
  5. Klicken Sie auf VALIDATE (VALIDIEREN), um den Datensatz zu speichern.

Ergebnisse

Der neue Datensatz wird auf der Seite Datasets (Datensätze) in der Liste hinzugefügt und kann in Ihrer Pipeline verwendet werden.

Um eine Vorschau anzuzeigen, klicken Sie auf den Namen in der Liste der Datensätze. Sie können wieder zur Datensatzansicht wechseln, in der Sie prüfen können, ob Ihre Daten gültig sind.