Créer un jeu de données de test avec des données financières - Cloud

Guide de prise en main de Talend Cloud Pipeline Designer

EnrichVersion
Cloud
EnrichProdName
Talend Cloud
EnrichPlatform
Talend Pipeline Designer
task
Création et développement > Création de Pipelines
Déploiement > Déploiement > Exécution de Pipelines
Talend Pipeline Designer vous permet de créer un jeu de données basé sur un schéma saisi manuellement.

Procédure

  1. Dans le panneau Add a new dataset (Ajouter un jeu de données), nommez votre jeu de données de test financial data par exemple et sélectionnez Test connection (précédemment créée) comme connexion dans laquelle ajouter vos données.
  2. Ajoutez une description si nécessaire, puis sélectionnez le format de vos données : Dans cet exemple, sélectionnez JSON.
  3. Dans la zone values (valeurs), copiez-collez le contenu des données d'échantillon.
    {
      "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
          }
        }
      }
    }
    Remarque : La taille de l’échantillon ne doit pas dépasser 32 kilooctets.
  4. Cliquez sur VIEW SAMPLE (VOIR L'ÉCHANTILLON) pour prévisualiser vos données.
  5. Cliquez sur VALIDATE pour sauvegarder votre jeu de données.

Résultats

Dans la page Datasets (Jeux de données), le nouveau jeu de données est ajouté à la liste et peut être utilisé dans votre pipeline.

Pour le prévisualiser, cliquez sur son nom dans la liste des jeux de données. Vous êtes redirigé(e) vers la vue des jeux de données, dans laquelle vous pouvez vérifier que vos données sont valides.