{"id":5587,"date":"2024-11-20T09:07:58","date_gmt":"2024-11-20T00:07:58","guid":{"rendered":"http:\/\/dandelions.co.jp\/blog\/?p=5587"},"modified":"2024-11-20T09:07:58","modified_gmt":"2024-11-20T00:07:58","slug":"2024-11-20","status":"publish","type":"post","link":"https:\/\/dandelions.co.jp\/blog\/blog\/2024\/11\/20\/2024-11-20\/","title":{"rendered":"\u6280\u8853\u8005\u30d6\u30ed\u30b0\uff1aOutsystems\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u5916\u90e8DB\u5316"},"content":{"rendered":"\n

\u6280\u8853\u8005\u30d6\u30ed\u30b0\u3068\u3057\u3066\u65e5\u3054\u308d\u53d6\u308a\u7d44\u3093\u3067\u3044\u308b\u5b66\u7fd2\u5185\u5bb9\u3092\u3054\u7d39\u4ecb\u3057\u307e\u3059\u3002
\u4eca\u56de\u306f\u3001\u30ed\u30fc\u30b3\u30fc\u30c9\u958b\u767a\u3092\u30c6\u30fc\u30de\u306b\u3057\u3066\u3044\u308b\u7b2c\uff12\u30e6\u30cb\u30c3\u30c8\u3067\u3059\u3002<\/p>\n\n\n\n

\u4eca\u56de\u306e\u30c6\u30fc\u30de\uff1aOutsystems\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u5916\u90e8DB\u5316<\/h2>\n\n\n\n

Outsystems\u3067\u306f\u3001\u30a2\u30ab\u30a6\u30f3\u30c8\u3092\u4f5c\u6210\u3059\u308b\u3053\u3068\u3067\u3001\u7121\u6599\u306e\u30af\u30e9\u30a6\u30c9\u7248\u3067\u3042\u308b”Personal Environment(PE)”\u3092\u30ea\u30af\u30a8\u30b9\u30c8\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\uff08\u53c2\u8003<\/a>\uff09
\u3053\u308c\u3092\u7528\u3044\u3066\u3001\u5c0f\u898f\u6a21\u30e6\u30fc\u30b6\u30fc\u5411\u3051\u306e\u500b\u4eba\u7528\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u958b\u767a\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u3001\u305d\u306e\u969b\u306b\u306f2GB\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30b9\u30c8\u30ec\u30fc\u30b8\u304c\u4e0e\u3048\u3089\u308c\u307e\u3059\u3002
\u305f\u3060\u3057\u3001\u5bb9\u91cf\u306b\u9650\u308a\u304c\u3042\u308b\u3053\u3068\u306b\u52a0\u3048\u3066\u3001\u5916\u90e8\u3088\u308a\u76f4\u63a5\u30a2\u30af\u30bb\u30b9\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u306a\u3044\u306a\u3069\u3001\u3044\u304f\u3064\u304b\u4e0d\u4fbf\u306a\u70b9\u3082\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n

\u305d\u3053\u3067\u4eca\u56de\u306f\u3001Outsystems\u3067\u4f5c\u6210\u3057\u305f\u5185\u90e8DB\u3092\u3001\u30c6\u30fc\u30d6\u30eb\u5b9a\u7fa9\u306f\u305d\u306e\u307e\u307e\u306b\u5916\u90e8DB\u3078\u3068\u79fb\u884c\u3059\u308b\u3053\u3068\u306b\u3057\u307e\u3057\u305f\u3002
\u4ee5\u4e0b\u306f\u305d\u306e\u7d50\u679c\u3068\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n

\u74b0\u5883\u60c5\u5831<\/h2>\n\n\n\n

Personal Environment: Version 11.31.0 (Build 43948)
Service Studio: Version 11.54.80 \/ Build 63652
Data Extractor<\/a>: 1.4.0<\/p>\n\n\n\n

Data Extractor\u306b\u3064\u3044\u3066<\/h2>\n\n\n\n

Forge<\/a>\u306b\u3066\u7121\u6599\u3067\u516c\u958b\u3055\u308c\u3066\u3044\u308bData Extractor\u3092\u7528\u3044\u308b\u3053\u3068\u3067\u3001Outsystems\u3067\u4f5c\u6210\u3057\u305fEntity\u306b\u5bfe\u5fdc\u3057\u305f\u5b9f\u30c6\u30fc\u30d6\u30eb\u306eDDL\u3092\u53d6\u5f97\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002
\u4f7f\u3044\u65b9\u306f\u4ee5\u4e0b\u306e\u901a\u308a\u3067\u3059\uff1a<\/p>\n\n\n\n

  1. Forge\u3088\u308a”Data Extractor”\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/li>
  2. Open In Browser\u3088\u308a\u753b\u9762\u3092\u8d77\u52d5
    \"\"<\/li>
  3. ID\u30fb\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u5165\u529b\u3057\u3001\u30ed\u30b0\u30a4\u30f3<\/li>
  4. \u30c8\u30c3\u30d7\u30da\u30fc\u30b8\u306e”New Snapshot”\u3088\u308a\u3001\u65b0\u3057\u3044\u30b9\u30ca\u30c3\u30d7\u30b7\u30e7\u30c3\u30c8\u3092\u4f5c\u6210\u3059\u308b\"\"<\/li>
  5. \u65b0\u898f\u30b9\u30ca\u30c3\u30d7\u30b7\u30e7\u30c3\u30c8\u753b\u9762\u3067\u3001\u4ee5\u4e0b\u3092\u8a2d\u5b9a\u3059\u308b\uff1a
    \u30fbSnapshot Name: \u30b9\u30ca\u30c3\u30d7\u30b7\u30e7\u30c3\u30c8\u306e\u540d\u79f0\u3002\u4efb\u610f\u306e\u540d\u79f0\u3067OK
    \u30fbExtract Configurations: “Table DDL”\u306b\u30c1\u30a7\u30c3\u30af\u3002\u305d\u308c\u4ee5\u5916\u306e\u9805\u76ee\u306f\u4efb\u610f
    \u30fbExtract Entities: DDL\u3092\u51fa\u529b\u3057\u305f\u3044Entity\u3092\u30ea\u30b9\u30c8\u306b\u8ffd\u52a0\u3059\u308b\u3002
    \u3000”Search Entity to Add”\u30ea\u30b9\u30c8\u3088\u308a\u524d\u65b9\u4e00\u81f4\u3067Entity\u540d\u3092\u691c\u7d22\u3067\u304d\u308b\u306e\u3067\u3001
    \u3000\u9078\u629e\u2192Add\u3059\u308b\u3053\u3068\u3067\u30ea\u30b9\u30c8\u306b\u8ffd\u52a0\u3055\u308c\u308b\u3002
    \u30fb\u4e0a\u8a18\u4ee5\u5916\u306e\u9805\u76ee: \u4efb\u610f\u3002\u5fc5\u8981\u306b\u5fdc\u3058\u3066\u8a2d\u5b9a\u3002
    \"\"<\/li>
  6. “Run”\u30dc\u30bf\u30f3\u3092\u62bc\u4e0b\u3059\u308b\u3068\u3001\u30c8\u30c3\u30d7\u30da\u30fc\u30b8\u306e\u4e00\u89a7\u306b\u3001
    \u5148\u307b\u3069\u5165\u529b\u3057\u305f\u4f5c\u6210\u3057\u305fSnapshot Name\u3092\u6301\u3064\u30b9\u30ca\u30c3\u30d7\u30b7\u30e7\u30c3\u30c8\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002
    \u4f5c\u6210\u76f4\u5f8c\u306f”Status: Created”\u3067\u3059\u304c\u3001\u3053\u308c\u304c”Status: Done”\u306b\u306a\u308b\u3068\u53f3\u7aef\u306e”\u2193”\u3088\u308a\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u53ef\u80fd\u3068\u306a\u308a\u307e\u3059\u3002
    \"\"<\/li>
  7. \u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u305fZip\u30d5\u30a1\u30a4\u30eb\u306e\u4e2d\u8eab\u306f\u4ee5\u4e0b\u306e\u901a\u308a\u3067\u3059\uff1a
    \u30fb[\u30c6\u30fc\u30d6\u30eb\u540d].csv.gz: Entity\u306b\u767b\u9332\u3055\u308c\u3066\u3044\u308b\u30c7\u30fc\u30bf\u306e\u30a8\u30af\u30b9\u30dd\u30fc\u30c8
    \u3000\u203b\u624b\u5143\u74b0\u5883\u3067\u8a66\u3057\u305f\u969b\u3001\u65e5\u672c\u8a9e\u306f”?”\u3067\u8868\u793a\u3055\u308c\u3066\u304a\u308a\u6b63\u3057\u304f\u8aad\u307f\u53d6\u308c\u307e\u305b\u3093\u3067\u3057\u305f\u2026
    \u30fbTableDDL.Create.sql.gz: Entity\u306b\u5bfe\u5fdc\u3059\u308b\u5b9f\u30c6\u30fc\u30d6\u30eb\u306eDDL
    \u3000\u203b\u4ee5\u4e0b\u306e\u5185\u5bb9\u3092\u542b\u3080\uff1a
    \u3000\u3000\u30fbCreate Table\u6587
    \u3000\u3000\u30fbEntity Identifier\u578b\u306e\u5217\u306b\u5bfe\u3059\u308b\u5916\u90e8\u30ad\u30fc\u5236\u7d04\u3092\u4ed8\u4e0e\u3059\u308b\u3001Alter Table\u6587
    \u3000\u3000\u30fbEntity Identifer\u578b\u306e\u5217\u306b\u5bfe\u3059\u308b\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3092\u4ed8\u4e0e\u3059\u308b\u3001Create Index\u6587<\/li><\/ol>\n\n\n\n

    \u4e0a\u8a18\u624b\u9806\u3067\u5165\u624b\u3057\u305fCreate Table\u6587\u3092\u5b9f\u884c\u3059\u308b\u3053\u3068\u3067\u3001
    \u81ea\u524d\u3067\u7528\u610f\u3057\u305fSQLServer\u4e0a\u306b\u5185\u90e8DB\u3068\u540c\u3058\u30ec\u30a4\u30a2\u30a6\u30c8\u306e\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u6210\u3067\u304d\u307e\u3059\u3002
    \"\"<\/p>\n\n\n\n

    \u5916\u90e8DB\u306b\u4f5c\u6210\u3057\u305f\u30c6\u30fc\u30d6\u30eb\u3092Outsystems\u3088\u308a\u53c2\u7167\u3059\u308b\u306b\u306f\u3001Service Center\u3088\u308aDatabase Connection\u3092\u4f5c\u6210\u3057\u3001\u305d\u306e\u5f8c\u3001Integration Studio<\/a>\u3088\u308a”Connect to External Table or View”\u306b\u3066\u8a2d\u5b9a\u3092\u884c\u3046\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002
    \"\"<\/p>\n\n\n\n


    \"\"
    <\/p>\n\n\n\n

    \u307e\u3068\u3081<\/h2>\n\n\n\n