{"id":307,"date":"2016-09-19T10:24:58","date_gmt":"2016-09-19T01:24:58","guid":{"rendered":"http:\/\/www.climb.co.jp\/blog_dbmoto\/?p=307"},"modified":"2020-07-30T23:01:37","modified_gmt":"2020-07-30T14:01:37","slug":"netezza-dwh%ef%bc%86%e5%88%86%e6%9e%90%e3%82%a2%e3%83%97%e3%83%a9%e3%82%a4%e3%82%a2%e3%83%b3%e3%82%b9%e3%82%92%e3%82%b5%e3%83%9d%e3%83%bc%e3%83%88%e8%bf%bd%e5%8a%a0%e3%80%90%e3%83%aa%e3%82%a2%e3%83%ab","status":"publish","type":"post","link":"https:\/\/www.climb.co.jp\/blog_dbmoto\/archives\/307","title":{"rendered":"Netezza (\u73feIBM PureData System) DWH&\u5206\u6790\u30a2\u30d7\u30e9\u30a4\u30a2\u30f3\u30b9\u3092\u30b5\u30dd\u30fc\u30c8\u8ffd\u52a0\u3010\u30ea\u30a2\u30eb\u30bf\u30a4\u30e0\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u30c4\u30fc\u30ebDBMoto\u3011"},"content":{"rendered":"

DBMoto7\u3067\u306fNetezza DWH\uff06\u5206\u6790\u30a2\u30d7\u30e9\u30a4\u30a2\u30f3\u30b9(TwinFin)\u3092\u6b63\u5f0f\u306b\u30b5\u30dd\u30fc\u30c8\u3057\u307e\u3059\u3002
\n\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u30e2\u30fc\u30c9<\/strong><\/a>\u306f\u3001Netezza\u3078\u306e\u30df\u30e9\u30fc\u30ea\u30f3\u30b0\u3001\u53ca\u3073Netezza\u304b\u3089\u306e\u30ea\u30d5\u30ec\u30c3\u30b7\u30e5\u306b\u5bfe\u5fdc\u3057\u3066\u304a\u308a\u307e\u3059\u3002\u3053\u308c\u306b\u3088\u308a\u4ed6\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u304b\u3089Netezza\u3078\u306e\u30ea\u30a2\u30eb\u30bf\u30a4\u30e0\u306a\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u304c\u53ef\u80fd\u306b\u306a\u308a\u307e\u3057\u305f\u3002\u3055\u3089\u306bDBMoto\u304b\u3089Netezza\u306b\u30c7\u30fc\u30bf\u3092\u9ad8\u901f\u306b\u8ee2\u9001\u3059\u308b\u305f\u3081\u306e\u6a5f\u80fd\u304c\u7d44\u307f\u8fbc\u307e\u308c\u3066\u3044\u307e\u3059\u3002\uff08Netezza\u306fIBM PureData System\u306b\u540d\u79f0\u304c\u5909\u308f\u3063\u3066\u3044\u307e\u3059\u3002\uff09<\/p>\n

\u25bc\u524d\u63d0\u6761\u4ef6<\/p>\n

\u3042\u3089\u304b\u3058\u3081DBMoto\u5c02\u7528\u30de\u30b7\u30f3\u306b\u3001Netezza ODBC\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u304a\u304f\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n

\u25bcDBMoto\u30b3\u30cd\u30af\u30b7\u30e7\u30f3\u8a2d\u5b9a\u4f8b<\/p>\n

DB\u306fNetezza\u3092\u9078\u629e\u3057\u307e\u3059\u3002
\n\"\"<\/p>\n

\u8d64\u3044\u7b87\u6240\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u30fb\u30fb\u30fb
\n\"\"<\/p>\n

Netezza ODBC\u30c9\u30e9\u30a4\u30d0\u306e\u8a2d\u5b9a\u753b\u9762\u304c\u958b\u304d\u307e\u3059\u306e\u3067\u3001\u5fc5\u8981\u306a\u63a5\u7d9a\u60c5\u5831\u3092\u8a2d\u5b9a\u3057\u3001\u300cTest Connection\u300d\u3092\u62bc\u4e0b\u3057\u3066\u63a5\u7d9a\u306b\u554f\u984c\u304c\u306a\u3044\u3053\u3068\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002
\n\"\"<\/p>\n

\u65e5\u672c\u8a9e\u30c7\u30fc\u30bf\u3092\u6271\u3046\u5834\u5408\u306fDriver Options\u30bf\u30d6\u306e\u300cOptimize for ASCII character set\u300d\u306b\u306f\u30c1\u30a7\u30c3\u30af\u3092\u5165\u308c\u306a\u3044\u3088\u3046\u306b\u3057\u307e\u3059\u3002
\n\"\"<\/p>\n

\u25bcDBMoto\u306eCreate\u30a6\u30a3\u30b6\u30fc\u30c9\u3092\u4f7f\u7528\u3057\u3066Netezza\u306b\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u6210\u3059\u308b\u5834\u5408\u306e\u6ce8\u610f\u70b9<\/p>\n

\u30fbPrimary Key\u304c\u8a2d\u5b9a\u3055\u308c\u306a\u3044\u305f\u3081\u3001DBMoto\u304b\u3089Set Primary Key\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002
\n\"\"<\/p>\n

\u30fb\u65e5\u672c\u8a9e\u30c7\u30fc\u30bf\u3092\u6271\u3046\u30d5\u30a3\u30fc\u30eb\u30c9\u306f\u5fc5\u305a\u300cNVARCHAR\u300d\u306b\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002
\n\"\"<\/p>\n","protected":false},"excerpt":{"rendered":"

DBMoto7\u3067\u306fNetezza DWH\uff06\u5206\u6790\u30a2\u30d7\u30e9\u30a4\u30a2\u30f3\u30b9(TwinFin)\u3092\u6b63\u5f0f\u306b\u30b5\u30dd\u30fc\u30c8\u3057\u307e\u3059\u3002 \u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u30e2\u30fc\u30c9\u306f\u3001Netezza\u3078\u306e\u30df\u30e9\u30fc\u30ea\u30f3\u30b0\u3001\u53ca\u3073Netezza\u304b\u3089\u306e\u30ea\u30d5\u30ec\u30c3\u30b7\u30e5\u306b\u5bfe\u5fdc\u3057\u3066\u304a\u308a\u307e\u3059\u3002\u3053 … \u7d9a\u304d\u3092\u8aad\u3080 →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[199,200],"class_list":["post-307","post","type-post","status-publish","format-standard","hentry","category-syniti","tag-ibm-puredata-system","tag-netezza"],"_links":{"self":[{"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/posts\/307","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/comments?post=307"}],"version-history":[{"count":4,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/posts\/307\/revisions"}],"predecessor-version":[{"id":5275,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/posts\/307\/revisions\/5275"}],"wp:attachment":[{"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/media?parent=307"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/categories?post=307"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/tags?post=307"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}