Talend Pipeline Designerを使用すると、手動で入力したスキーマに基づいてデータセットを作成できます。
手順
- [Add a new dataset] (新しいデータセットの追加)パネルで、テストデータセットにfinancial dataというような名前を付け、データを追加する接続として[Test connection] (テスト接続)(以前に作成済み)を選択します。
- 必要に応じて説明を追加し、データの形式を選択します: この場合、JSONを選択します。
-
[values] (値)エリアで、サンプルデータのコンテンツをコピーして貼り付けます。
{ "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 } } } }注: サンプルのサイズは32KBを超えることはできません。 -
[VIEW SAMPLE] (サンプルの表示)をクリックすればデータをプレビューできます。
- [VALIDATE] (検証)をクリックしてデータセットを保存します。
タスクの結果
[Datasets] (データセット)ページで、新しいデータセットがリストに追加され、パイプラインで使用できるようになります。
プレビューするには、データセットリストの名前をクリックします。データセットビューにリダイレクトされ、データが有効であることを確認できます。