{"id":6769,"date":"2026-07-12T02:08:50","date_gmt":"2026-07-12T10:08:50","guid":{"rendered":"https:\/\/www.gudusoft.com\/sap-hana-data-lineage\/"},"modified":"2026-07-12T02:08:50","modified_gmt":"2026-07-12T10:08:50","slug":"sap-hana-data-lineage","status":"publish","type":"page","link":"https:\/\/www.gudusoft.com\/ko\/%ec%82%ac%ed%94%84%ed%95%98%eb%82%98-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ea%b3%84%eb%b3%b4\/","title":{"rendered":"SAP HANA \ub370\uc774\ud130 \uacc4\ubcf4: HANA SQL \ubc0f \ubdf0\uc5d0 \ub300\ud55c \uc5f4 \uacc4\ubcf4"},"content":{"rendered":"<p><strong>SAP HANA \ub370\uc774\ud130 \uacc4\ubcf4<\/strong> \uc774\ub294 HANA SQL\uc5d0\uc11c \ub370\uc774\ud130\uac00 \uc774\ub3d9\ud558\ub294 \ubc29\uc2dd\uc744 \uc5f4 \uc218\uc900\uc5d0\uc11c \ubcf4\uc5ec\uc8fc\ub294 \uc9c0\ub3c4\uc785\ub2c8\ub2e4. \uc989, \uac01 SQL \ubdf0, \uacc4\uc0b0 \uc5f4 \ubc0f \ud558\uc704 \ubcf4\uace0\uc11c\uc5d0 \uc5b4\ub5a4 \uc18c\uc2a4 \ud14c\uc774\ube14\uacfc \uc5f4\uc774 \uc0ac\uc6a9\ub418\ub294\uc9c0, \uadf8\ub9ac\uace0 \uadf8 \uacfc\uc815\uc5d0\uc11c \uc5b4\ub5a4 \uc870\uc778, \ud544\ud130, \ud615\ubcc0\ud658 \ubc0f \ud568\uc218\uac00 \ub370\uc774\ud130\ub97c \ubcc0\ud658\ud558\ub294\uc9c0\ub97c \ub098\ud0c0\ub0c5\ub2c8\ub2e4. <strong>Gudu SQLFlow<\/strong> \uc774 \uae30\ub2a5\uc740 \uc804\uc6a9 SAP HANA \ubc29\uc5b8 \ud30c\uc11c(\uc77c\ubc18 ANSI \ubb38\ubc95\uc774 \uc544\ub2cc 39\uac1c\uc758 \ubc29\uc5b8\ubcc4 \ud30c\uc11c \uc911 \ud558\ub098)\ub97c \uc0ac\uc6a9\ud558\uc5ec HANA SQL\uc744 \uad6c\ubb38 \ubd84\uc11d\ud568\uc73c\ub85c\uc368 \ud574\ub2f9 \ub9f5\uc744 \uc790\ub3d9\uc73c\ub85c \uad6c\ucd95\ud558\uace0, \uac1c\ubcc4 \uc5f4\uae4c\uc9c0 \uc790\uc138\ud788 \uc0b4\ud3b4\ubcfc \uc218 \uc788\ub294 \ub300\ud654\ud615 \uacc4\ubcf4 \ub2e4\uc774\uc5b4\uadf8\ub7a8\uc744 \ub80c\ub354\ub9c1\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained\" style=\"background-color:#eef7fb;padding-top:24px;padding-bottom:24px\"><div class=\"wp-block-group__inner-container\">\n\n<p><strong>\uc9c0\uae08 \ubc14\ub85c \uc2dc\ub3c4\ud574 \ubcf4\uc138\uc694:<\/strong> HANA\ub97c \ubd99\uc5ec\ub123\uc73c\uc138\uc694 <code>\ubdf0 \uc0dd\uc131<\/code> \uccb4\uc778\uc744 <a href=\"https:\/\/sqlflow.gudusoft.com\/?utm_source=gudusoft&amp;utm_medium=website&amp;utm_campaign=sap-hana-data-lineage\" target=\"_blank\" rel=\"noreferrer noopener\">\ubb34\ub8cc SQLFlow \uacc4\ubcf4 \uc2dc\uac01\ud654 \ub3c4\uad6c<\/a>SAP HANA \ubc29\uc5b8\uc744 \uc120\ud0dd\ud558\uba74 \uba87 \ucd08 \ub9cc\uc5d0 \uc5f4 \uc218\uc900 \ub2e4\uc774\uc5b4\uadf8\ub7a8\uc744 \uc5bb\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ubb34\ub8cc \ud2f0\uc5b4\uc774\uba70 \uc124\uce58\uac00 \ud544\uc694 \uc5c6\uc2b5\ub2c8\ub2e4.<\/p>\n\n<\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\uacc4\ubcf4 \uad00\ub828 \uc9c8\ubb38\uc774 HANA\uc5d0 \uc9d1\uc911\ub418\ub294 \uc774\uc720\ub294 \ubb34\uc5c7\uc77c\uae4c\uc694?<\/h2>\n\n\n\n<p>HANA\ub294 \ub2e8\ub3c5\uc73c\ub85c \uc874\uc7ac\ud558\ub294 \uacbd\uc6b0\uac00 \ub4dc\ubb45\ub2c8\ub2e4. \uc77c\ubc18\uc801\uc73c\ub85c S\/4HANA \ubc0f BW \ud658\uacbd \uc544\ub798\uc5d0 \ub098\ub780\ud788 \ubc30\uce58\ub418\uc5b4 \uc7ac\ubb34 \ubc0f \uac10\uc0ac \uae30\ub2a5\uc774 \uc758\uc874\ud558\ub294 \ub370\uc774\ud130 \ub9c8\ud2b8\uc640 \ubcf4\uace0 \uacc4\uce35\uc744 \uad6c\uc131\ud569\ub2c8\ub2e4. \uac10\uc0ac\uc790\uac00 \uc9c8\ubb38\ud560 \ub54c <em>\u201c\uc774 \uc218\uce58\ub294 \uc5b4\ub5a4 \uc18c\uc2a4 \ud544\ub4dc\uc5d0\uc11c \uac00\uc838\uc628 \uac83\uc785\ub2c8\uae4c?\u201d<\/em> \ub610\ub294 \ucee8\ud2b8\ub864\ub7ec\uac00 \ubb3b\uc2b5\ub2c8\ub2e4 <em>&quot;\uc9c0\ub09c\ub2ec \ubc1c\ud45c \uc774\ud6c4 \uc774 KPI\uac00 \ubcc0\uacbd\ub41c \uc774\uc720\ub294 \ubb34\uc5c7\uc778\uac00\uc694?&quot;<\/em>\ub2f5\uc740 SQL\uc758 \uc5ec\ub7ec \uacc4\uce35, \uc989 \ubdf0 \uc704\uc5d0 \uad6c\ucd95\ub41c \ubdf0, \uacc4\uc0b0 \uc5f4, \ud1b5\ud654 \ubcc0\ud658 \ubc0f \uc2a4\ud0a4\ub9c8 \uac04 \uc870\uc778\uc5d0 \uc228\uaca8\uc838 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>SQL \ubb38\uc744 \uc218\ub3d9\uc73c\ub85c \uc77d\uc5b4 \uc774\ub7ec\ud55c \uc9c8\ubb38\uc5d0 \ub2f5\ud558\ub294 \ubc29\uc2dd\uc740 \ubdf0\uc758 \uc218\uac00 \uba87 \uac1c\uc5d0 \ubd88\uacfc\ud558\uba74 \ud655\uc7a5\uc131\uc774 \ub5a8\uc5b4\uc9d1\ub2c8\ub2e4. SQL \uc218\uc900\uc758 \uacc4\ubcf4 \ucd94\uc801 \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud558\uba74 \uc774 \uacfc\uc815\uc744 \uc790\ub3d9\ud654\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ubaa8\ub4e0 \ubdf0 \uc815\uc758\uc640 \uc2a4\ud06c\ub9bd\ud2b8\ub97c \ud55c \ubc88\ub9cc \ud30c\uc2f1\ud558\uba74 \ud14c\uc774\ube14\uc5d0\uc11c \ubdf0, \ubdf0\uc5d0\uc11c \ubcf4\uace0\uc11c\ub85c \uc774\uc5b4\uc9c0\ub294 \uc885\uc18d\uc131 \uadf8\ub798\ud504\ub97c \uc5f4 \ub2e8\uc704\uae4c\uc9c0 \uc138\ubd84\ud654\ud558\uc5ec \ud544\uc694\uc5d0 \ub530\ub77c \uc601\ud5a5 \ubd84\uc11d, \uadfc\ubcf8 \uc6d0\uc778 \ub514\ubc84\uae45 \ubc0f \uac10\uc0ac \uc99d\uac70\ub85c \ud65c\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">SQLFlow\ub294 \uc5b4\ub5bb\uac8c SAP HANA \ub370\uc774\ud130 \uacc4\ubcf4\ub97c \uad6c\ucd95\ud558\ub294\uac00<\/h2>\n\n\n\n<p>SQLFlow\ub294 \ub2e4\uc74c\uc744 \uae30\ubc18\uc73c\ub85c \uad6c\ucd95\ub418\uc5c8\uc2b5\ub2c8\ub2e4. <a href=\"https:\/\/www.sqlparser.com\/\">\uc77c\ubc18 SQL \ud30c\uc11c(GSP)<\/a>2000\ub144\ub300 \uc911\ubc18\ubd80\ud130 \uac1c\ubc1c\ub418\uc5b4 \uc57d 13,600\uac1c\uc758 \ubc29\uc5b8\ubcc4 SQL \ud14c\uc2a4\ud2b8 \ud53d\uc2a4\ucc98\ub97c \ud1b5\ud574 \uac80\uc99d\ub41c \uc0c1\uc6a9 SQL \ucef4\ud30c\uc77c\ub7ec \ud504\ub7f0\ud2b8\uc5d4\ub4dc\uc785\ub2c8\ub2e4. SAP HANA \ud30c\uc11c\ub294 HANA\uc758 SQL \uad6c\ubb38\uc744 \ud2b9\ubcc4\ud788 \uc774\ud574\ud569\ub2c8\ub2e4. <code>&quot;\uc2a4\ud0a4\ub9c8&quot;.&quot;\uac1d\uccb4&quot;<\/code> \uc2dd\ubcc4\uc790, HANA \ud568\uc218 \ubc0f \ud615\ubcc0\ud658, HANA \uc870\uc778 \ubc0f \uc9d1\ud569 \uc5f0\uc0b0\uc790 \ud615\uc2dd\uc744 \uc0ac\uc6a9\ud558\ub294 \uac83\uc774\uc9c0, \uc77c\ubc18 \ubb38\ubc95\uc73c\ub85c \uadfc\uc0ac\ud654\ud558\ub294 \uac83\uc774 \uc544\ub2d9\ub2c8\ub2e4.<\/p>\n\n\n\n<p>GSP\ub294 \uac01 \ubb38\uc7a5\uc5d0 \ub300\ud574 \uc644\uc804\ud55c \uc758\ubbf8 \ubaa8\ub378\uc744 \uad6c\ucd95\ud569\ub2c8\ub2e4. \ubaa8\ub4e0 \uc5f4 \ucc38\uc870\ub294 CTE, \uc11c\ube0c\ucffc\ub9ac, \ubdf0 \ub4f1\uc744 \ud1b5\ud574 \ud574\uc11d\ub429\ub2c8\ub2e4. <code>\uc120\ud0dd\ud558\ub2e4 *<\/code> \ud655\uc7a5 \uacfc\uc815\uc5d0\uc11c \ub370\uc774\ud130 \ud750\ub984 \ubd84\uc11d\uae30\ub294 \uac01 \ucd9c\ub825 \uc5f4\uc5d0 \ub300\ud574 \uc5b4\ub5a4 \uc18c\uc2a4 \uc5f4\uc774 \uc5b4\ub5a4 \ud568\uc218\uc640 \ud45c\ud604\uc2dd\uc744 \ud1b5\ud574 \ud574\ub2f9 \uc5f4\ub85c \ub370\uc774\ud130\ub97c \uc804\ub2ec\ud558\ub294\uc9c0 \uc815\ud655\ud558\uac8c \ucd94\ucd9c\ud569\ub2c8\ub2e4. \uadf8 \uacb0\uacfc, \ud14c\uc774\ube14 \uc218\uc900\uc758 \uac1c\ub7b5\uc801\uc778 \uc815\ubcf4\uac00 \uc544\ub2cc, \uc2a4\ud0a4\ub9c8 \ubcc0\uacbd\uc5d0 \ub300\ud574 \uc2e0\ub8b0\ud560 \uc218 \uc788\ub294 \uc5f4 \uc218\uc900\uc758 \ub370\uc774\ud130 \uacc4\ubcf4\ub97c \uc5bb\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>HANA SQL\uc744 SQLFlow\uc5d0 \uc785\ub825\ud558\ub294 \ubc29\ubc95\uc740 \uc138 \uac00\uc9c0\uc785\ub2c8\ub2e4. SQL \ubb38\uc744 \uc9c1\uc811 \ubd99\uc5ec\ub123\uac70\ub098, \ubdf0 \uc815\uc758 \ubc0f \uc2a4\ud06c\ub9bd\ud2b8 \ud30c\uc77c\uc744 \uc5c5\ub85c\ub4dc\ud558\uac70\ub098, JDBC\ub97c \ud1b5\ud574 \uc5f0\uacb0\ud558\uc5ec SQLFlow\uac00 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uce74\ud0c8\ub85c\uadf8\uc5d0\uc11c \uac1d\uccb4 \uc815\uc758\ub97c \uac00\uc838\uc624\ub3c4\ub85d \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ubaa8\ub4e0 \uc791\uc5c5\uc740 SQL \ud14d\uc2a4\ud2b8\uc5d0 \ub300\ud55c \uc815\uc801 \ubd84\uc11d\uc774\uba70, SQLFlow\ub294 \ud14c\uc774\ube14\uc758 \ud589\uc744 \uc77d\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\uc608\uc2dc: \uacc4\uce35\ud615 HANA SQL \ubdf0 \uccb4\uc778 \ucd94\uc801<\/h2>\n\n\n\n<p>\uacc4\uce35\ud615 SQL \ubdf0\ub294 \ud45c\uc900 HANA \ud328\ud134\uc785\ub2c8\ub2e4. \uc6d0\uc2dc \ud14c\uc774\ube14 \uc704\uc5d0 \ud074\ub80c\uc9d5 \ubdf0\uac00 \uc788\uace0, \uadf8 \uc704\uc5d0 \ubcf4\uac15 \ubdf0\uac00 \uc788\uc73c\uba70, \ubcf4\uace0\ub97c \uc704\ud55c \uc9d1\uacc4 \ubdf0\uac00 \uc788\uc2b5\ub2c8\ub2e4. \ub2e4\uc74c\uc740 \uc77c\ubc18\uc801\uc778 3\uacc4\uce35 \uad6c\uc870\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE VIEW &quot;FIN&quot;.&quot;V_ORDERS_CLEAN&quot; AS SELECT ORDER_ID, CUSTOMER_ID, TO_DECIMAL(GROSS_AMOUNT, 15, 2) AS GROSS_AMOUNT, IFNULL(CURRENCY, &#039;EUR&#039;) AS CURRENCY, ORDER_DATE FROM &quot;FIN&quot;.&quot;ORDERS_RAW&quot; WHERE STATUS &lt;&gt; &#039;CANCELLED&#039;; CREATE VIEW &quot;FIN&quot;.&quot;V_ORDERS_EUR&quot; AS SELECT o.ORDER_ID, o.CUSTOMER_ID, o.GROSS_AMOUNT * r.RATE AS AMOUNT_EUR, o.ORDER_DATE FROM &quot;FIN&quot;.&quot;V_ORDERS_CLEAN&quot; o JOIN &quot;FIN&quot;.&quot;FX_RATES&quot; r ON r.CURRENCY = o.CURRENCY AND r.RATE_DATE = o.ORDER_DATE; CREATE VIEW &quot;FIN&quot;.&quot;V_REVENUE_MONTHLY&quot; AS SELECT CUSTOMER_ID, YEAR(ORDER_DATE) AS FISCAL_YEAR, MONTH(ORDER_DATE) AS FISCAL_MONTH, SUM(AMOUNT_EUR) AS REVENUE_EUR FROM &quot;FIN&quot;.&quot;V_ORDERS_EUR&quot; GROUP BY CUSTOMER_ID, YEAR(ORDER_DATE), MONTH(ORDER_DATE);<\/code><\/pre>\n\n\n\n<p>SQLFlow\uc5d0 \ubb38\uc758\ud558\uc138\uc694 <code>V_\uc6d4\uac04\uc218\uc775.\uc218\uc775\uc720\ub85c<\/code> \ucd9c\ucc98\uc5d0\uc11c \uc720\ub798\ud558\uba70 \uc790\ub3d9\uc73c\ub85c \uccb4\uc778\uc744 \ub530\ub77c\uac11\ub2c8\ub2e4. <code>\uc218\uc775_\uc720\ub85c<\/code> ~\uc774\ub2e4 <code>\ud569\uacc4(\uae08\uc561_\uc720\ub85c)<\/code>\uc989, <code>\ucd1d\uc561 * \ube44\uc728<\/code>, \uc5b4\ub514 <code>\ucd1d\uc561<\/code> ~\uc774\ub2e4 <code>\uc8fc\ubb38_\uc6d0\uac00.\ucd1d\uc561<\/code> \ud1b5\uacfc\ud588\ub2e4 <code>\uc18c\uc218\uc810 \ubcc0\ud658<\/code>\uc18c\uc2a4 \uc5f4 \ub450 \uac1c, \ubdf0 \uae4a\uc774 \uc138 \uac1c, \ubaa8\ub4e0 \uc911\uac04 \uacc4\uc0b0 \uc774\ub984 \uc9c0\uc815. \ucd94\uc801\uc744 \ubc18\ub300\ub85c \uc2e4\ud589\ud558\uba74 \uc601\ud5a5 \ubd84\uc11d\uc774 \ud45c\uc2dc\ub429\ub2c8\ub2e4: \ub2e4\uc2dc \uc785\ub825 <code>\uc8fc\ubb38_\uc6d0\uac00.\ucd1d\uc561<\/code> SQLFlow\ub294 \ubcc0\uacbd \uc0ac\ud56d\uc744 \uc0c1\uc18d\ubc1b\ub294 \ubaa8\ub4e0 \ud558\uc704 \uc5f4\uc744 \ub098\uc5f4\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p>SQL \ubdf0\uc758 \uacc4\uc0b0 \uc5f4 \u2014 <code>\uc18c\uc218\uc810 \ubcc0\ud658<\/code> \uce90\uc2a4\ud305, <code>IFNULL<\/code> \uae30\ubcf8\uc801\uc73c\ub85c \uacf1\uc148\uc740 \uacc4\ubcf4 \uadf8\ub798\ud504\uc5d0\uc11c \uc77c\uae09 \uac1d\uccb4\uc774\ubbc0\ub85c \ub2e4\uc774\uc5b4\uadf8\ub7a8\uc740 \ub2e8\uc21c\ud788 \ubfd0\ub9cc \uc544\ub2c8\ub77c <em>\uc800\uac83<\/em> \uae30\ub465\uc774 \ud750\ub974\uc9c0\ub9cc <em>\uadf8\uac83\uc5d0 \ubb34\uc2a8 \uc77c\uc774 \uc77c\uc5b4\ub098\ub294\uac00<\/em> \uac01 \uce35\ub9c8\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\uc9c1\uacc4 \ud608\ud1b5 vs. \uac04\uc811 \ud608\ud1b5<\/h2>\n\n\n\n<p>\uc608\uc2dc\ub97c \ub2e4\uc2dc \uc0b4\ud3b4\ubcf4\uc138\uc694. <code>ORDERS_RAW.STATUS<\/code> \uc5b4\ub5a4 \ucd9c\ub825 \uc5f4\uc5d0\ub3c4 \ub098\ud0c0\ub098\uc9c0 \uc54a\uc9c0\ub9cc, <code>\uc0c1\ud0dc\uac00 &#039;\ucde8\uc18c\ub428&#039;\uc774 \uc544\ub2cc \uacbd\uc6b0<\/code> \ud544\ud130\ub294 \ub9e4\ucd9c\uc561 \uc218\uce58\uc5d0 \uc808\ub300\uc801\uc73c\ub85c \uc601\ud5a5\uc744 \ubbf8\uce69\ub2c8\ub2e4. \ub2e4\ub978 \ud544\ud130\ub3c4 \ub9c8\ucc2c\uac00\uc9c0\uc785\ub2c8\ub2e4. <code>\ud1b5\ud654<\/code>, <code>\uc694\uae08_\ub0a0\uc9dc<\/code>, \uadf8\ub9ac\uace0 <code>\uc8fc\ubb38\uc77c<\/code> \uacb0\ud569 \uc870\uac74\uc5d0\uc11c \uadf8\ub9ac\uace0 <code>\uadf8\ub8f9\ud654 \uae30\uc900<\/code>.<\/p>\n\n\n\n<p>SQLFlow\ub294 \uc774\ub7ec\ud55c \uac83\ub4e4\uc744 \ub2e4\uc74c\uacfc \uac19\uc774 \ubaa8\ub378\ub9c1\ud569\ub2c8\ub2e4. <strong>\uac04\uc811\uc801 (\uc601\ud5a5) \uacc4\ubcf4<\/strong>\uc774\ub294 \uc9c1\uc811\uc801\uc778 \ub370\uc774\ud130 \ud750\ub984\uacfc\ub294 \uad6c\ubcc4\ub418\ub294 \uad00\uacc4 \uc720\ud615\uc73c\ub85c, \ub2e4\uc774\uc5b4\uadf8\ub7a8\uc5d0\uc11c \ubcc4\ub3c4\ub85c \ucf1c\uace0 \ub04c \uc218 \uc788\uc2b5\ub2c8\ub2e4. &quot;\uc774 \uaddc\uc81c \ubd84\uc57c\uac00 \uc774 \ubcf4\uace0\uc11c\uc5d0 \uc601\ud5a5\uc744 \ubbf8\uce58\ub294\uac00?&quot;\uc640 \uac19\uc740 \uac10\uc0ac \uc9c8\ubb38\uc758 \uacbd\uc6b0, \uac04\uc811\uc801\uc778 \uc5f0\uacb0\uc774 \uc804\uccb4 \ud574\ub2f5\uc774 \ub418\ub294 \uacbd\uc6b0\uac00 \ub9ce\uc9c0\ub9cc, \ub300\ubd80\ubd84\uc758 \uacbd\uc7c1 \uacc4\ubcf4 \ub3c4\uad6c\ub294 \uc9c1\uc811\/\uac04\uc811 \uc5f0\uacb0\uc744 \uad6c\ubd84\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">SQLFlow\ub294 SAP \uae30\ubcf8 \ub3c4\uad6c\uc640 \uc5b4\ub5bb\uac8c \uc870\ud654\ub97c \uc774\ub8f0\uae4c\uc694?<\/h2>\n\n\n\n<p>SAP \uc790\uccb4 \ubaa8\ub378\ub9c1 \ubc0f \uce74\ud0c8\ub85c\uadf8 \ub3c4\uad6c\ub294 \uac1c\ubc1c \ubaa9\uc801\uc5d0 \ub9de\uac8c SAP \ubaa8\ub378\ub9c1 \ub808\uc774\uc5b4 \ub0b4\uc5d0\uc11c \uc0dd\uc131\ub41c \uc544\ud2f0\ud329\ud2b8\ub97c \ucd94\uc801\ud558\ub294 \ub370\ub294 \ud0c1\uc6d4\ud569\ub2c8\ub2e4. \ud558\uc9c0\ub9cc SQL \ub808\ubca8\uc5d0\uc11c \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud569\ub2c8\ub2e4. \uc218\ub3d9\uc73c\ub85c \uc791\uc131\ub41c SQL \ubdf0, \ub9c8\uc774\uadf8\ub808\uc774\uc158 \uc2a4\ud06c\ub9bd\ud2b8, \uc608\uc57d\ub41c \uc791\uc5c5\uc758 DML, \uadf8\ub9ac\uace0 HANA\ub97c SAP \uc774\uc678\uc758 \uc2dc\uc2a4\ud15c\uc5d0 \uc5f0\uacb0\ud558\ub294 SQL\uc740 \ubaa8\ub378\ub9c1\ub41c \uc544\ud2f0\ud329\ud2b8\ub85c \ub4f1\ub85d\ub418\uc9c0 \uc54a\uc558\uae30 \ub54c\ubb38\uc5d0 \ubaa8\ub378 \uae30\ubc18 \uacc4\ubcf4 \ucd94\uc801\uc5d0\uc11c \ubcf4\uc774\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>SQLFlow\uac00 \ub2e4\ub8e8\ub294 \uc601\uc5ed\uc740 \ubc14\ub85c \uc774 \ubd80\ubd84\uc785\ub2c8\ub2e4. SQLFlow\ub294 SQL \uc790\uccb4\ub97c \ud30c\uc2f1\ud558\ubbc0\ub85c \uc5b4\ub5a4 \ub3c4\uad6c\ub85c \uc791\uc131\ud588\ub294\uc9c0\uc5d0 \uad00\uacc4\uc5c6\uc774 SQL \ud14d\uc2a4\ud2b8\ub85c \ud45c\ud604\ub41c \ubaa8\ub4e0 \uac83\uc744 \ucd94\uc801\ud569\ub2c8\ub2e4. \uc54c\uc544\ub450\uc5b4\uc57c \ud560 \ub450 \uac00\uc9c0 \uc911\uc694\ud55c \ud55c\uacc4\uc810\uc774 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<ul><li><strong>\uadf8\ub798\ud53d \uacc4\uc0b0 \ubcf4\uae30<\/strong> \ud574\ub2f9 \ub370\uc774\ud130\ub294 SQL\uc774 \uc544\ub2cc XML \ubaa8\ub378\ub85c \uc800\uc7a5\ub418\ubbc0\ub85c SQL \uad6c\ubb38 \ubd84\uc11d \ubc94\uc704\uc5d0\uc11c \uc81c\uc678\ub429\ub2c8\ub2e4. \ud558\uc9c0\ub9cc \ud574\ub2f9 \ub370\uc774\ud130\ub97c \uac10\uc2f8\ub294 SQL \ubdf0\uc640 \uc774\ub97c \ucffc\ub9ac\ud558\ub294 \ubaa8\ub4e0 SQL \ubb38\uc740 \uc644\ubcbd\ud558\uac8c \ucd94\uc801\ub429\ub2c8\ub2e4.<\/li>\n<li><strong>SQLScript \ud504\ub85c\uc2dc\uc800:<\/strong> SQLFlow\uc758 \uc804\uc6a9 \uc808\ucc28 \ubb38\ubc95\uc740 \ud604\uc7ac Oracle PL\/SQL \ubc0f SQL Server T-SQL\uc744 \uc9c0\uc6d0\ud569\ub2c8\ub2e4. HANA\uc758 \uacbd\uc6b0 \uc2e4\uc9c8\uc801\uc778 \uc811\uadfc \ubc29\uc2dd\uc740 SQLScript \ubcf8\ubb38 \ub0b4\uc758 SQL \ubb38\uc744 \ubd84\uc11d\ud558\ub294 \uac83\uc785\ub2c8\ub2e4. <code>\uc120\ud0dd\ud558\ub2e4<\/code>, <code>\ub07c\uc6cc \ub123\ub2e4<\/code>\uadf8\ub9ac\uace0 \uacc4\ubcf4\uac00 \uc2e4\uc81c\ub85c \uc874\uc7ac\ud558\ub294 \ubdf0 \uc815\uc758\ub294 \ud45c\uc900 HANA SQL\uc785\ub2c8\ub2e4.<\/li><\/ul>\n\n\n\n<p>\ub450 \uac00\uc9c0 \uc811\uadfc \ubc29\uc2dd\uc744 \ud568\uaed8 \uc0ac\uc6a9\ud558\uba74 \uc11c\ub85c\ub97c \ubcf4\uc644\ud569\ub2c8\ub2e4. \ubaa8\ub378\ub9c1\ub41c \uacc4\uce35\uc5d0\ub294 SAP \ub124\uc774\ud2f0\ube0c \ud234\uc744 \uc0ac\uc6a9\ud558\uace0, SQL\ub85c \uc791\uc131\ub41c \ubaa8\ub4e0 \ud56d\ubaa9\uc5d0\ub294 SQL \uc218\uc900\uc758 \uacc4\ubcf4\ub97c \uc81c\uacf5\ud569\ub2c8\ub2e4. \ub610\ud55c SQLFlow\ub294 39\uac1c\uc758 \ubc29\uc5b8\uc744 \uc9c0\uc6d0\ud558\ubbc0\ub85c \ub3d9\uc77c\ud55c \uacc4\ubcf4 \uadf8\ub798\ud504\uac00 HANA\ub97c \ub118\uc5b4 Oracle, DB2 \ub610\ub294 Snowflake \uc2dc\uc2a4\ud15c\uae4c\uc9c0 \ud655\uc7a5\ub429\ub2c8\ub2e4. \uc790\uc138\ud55c \ub0b4\uc6a9\uc740 \ub2e4\uc74c\uc744 \ucc38\uc870\ud558\uc2ed\uc2dc\uc624. <a href=\"https:\/\/www.gudusoft.com\/ko\/%ec%98%a4%eb%9d%bc%ed%81%b4-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ea%b3%84%eb%b3%b4-%eb%8f%84%ea%b5%ac\/\">Oracle \ub370\uc774\ud130 \uacc4\ubcf4<\/a> \uadf8\ub9ac\uace0 <a href=\"https:\/\/www.gudusoft.com\/ko\/db2-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ea%b3%84%eb%b3%b4\/\">DB2 \ub370\uc774\ud130 \uacc4\ubcf4<\/a> \ud574\ub2f9 \uc5b8\uc5b4\uc5d0 \ub300\ud55c \ud398\uc774\uc9c0\uac00 \uc81c\uacf5\ub429\ub2c8\ub2e4. \uc5d4\ud130\ud504\ub77c\uc774\uc988 \ubc30\ud3ec \ud658\uacbd\uc5d0\uc11c\ub294 \ub0b4\uc7a5\ub41c \ub0b4\ubcf4\ub0b4\uae30 \uc5b4\ub311\ud130\ub97c \ud1b5\ud574 \uacb0\uacfc\ub97c DataHub, Microsoft Purview \ub610\ub294 OpenMetadata\ub85c \ub0b4\ubcf4\ub0bc \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">SAP \ud658\uacbd\uc744 \uc704\ud55c \ubc30\ud3ec \uc635\uc158<\/h2>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>\ud310<\/th><th>~\uc5d0 \uac00\uc7a5 \uc801\ud569\ud568<\/th><th>\uba54\ubaa8<\/th><\/tr><\/thead><tbody>\n<tr><td><a href=\"https:\/\/sqlflow.gudusoft.com\/?utm_source=gudusoft&amp;utm_medium=website&amp;utm_campaign=sap-hana-data-lineage\">SQLFlow \ud074\ub77c\uc6b0\ub4dc<\/a><\/td><td>\ud3c9\uac00, \uc784\uc2dc \ubcf4\uae30 \ucd94\uc801<\/td><td>\ubb34\ub8cc \ud2f0\uc5b4; \ud504\ub9ac\ubbf8\uc5c4 $49.99\/\uc6d4; HANA SQL\uc744 \ube0c\ub77c\uc6b0\uc800\uc5d0 \ubd99\uc5ec\ub123\uac70\ub098 \uc5c5\ub85c\ub4dc\ud558\uc138\uc694<\/td><\/tr>\n<tr><td><a href=\"https:\/\/www.gudusoft.com\/ko\/sqlflow-on-premise-%eb%b2%84%ec%a0%84\/\">\uc628\ud504\ub808\ubbf8\uc2a4 SQLFlow<\/a><\/td><td>\uaddc\uc81c \uc0b0\uc5c5 \ubd84\uc57c\uc758 SAP \uc0dd\uc0b0 \ud658\uacbd<\/td><td>\ub124\ud2b8\uc6cc\ud06c \ub0b4\ubd80\uc5d0 Docker\/Kubernetes \ud658\uacbd\uc744 \uad6c\ucd95\ud560 \uc218 \uc788\uc73c\uba70, \uc5d0\uc5b4\uac2d(air-gap) \ud658\uacbd\ub3c4 \uc9c0\uc6d0\ud569\ub2c8\ub2e4. \uc6d4 $500 \ub610\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc720\ud615\ubcc4 \uc77c\ud68c\uc131 $4,800 \uc694\uae08\uc73c\ub85c \uc774\uc6a9 \uac00\ub2a5\ud569\ub2c8\ub2e4.<\/td><\/tr>\n<tr><td>REST API \/ \uc790\ubc14 \ub77c\uc774\ube0c\ub7ec\ub9ac<\/td><td>CI \ub610\ub294 \ub370\uc774\ud130 \ud50c\ub7ab\ud3fc\uc5d0\uc11c \ub370\uc774\ud130 \uacc4\ubcf4 \uc790\ub3d9\ud654<\/td><td>\ub3d9\uc77c\ud55c \ubd84\uc11d \uc5d4\uc9c4\uc744 \uc0ac\uc6a9\ud558\uba70, \ud30c\uc774\ud504\ub77c\uc778 \ubc0f JVM \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc5d0\uc11c \ud638\ucd9c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/td><\/tr>\n<\/tbody><\/table><\/figure>\n\n\n\n<p>\ub300\ubd80\ubd84\uc758 HANA \ud658\uacbd\uc5d0\uc11c\ub294 \uae30\ub2a5\ub9cc\ud07c\uc774\ub098 \uac1c\uc778\uc815\ubcf4 \ubcf4\ud638 \uc815\ucc45\uc774 \uc911\uc694\ud569\ub2c8\ub2e4. SQLFlow\ub294 SQL \ucf54\ub4dc\uc640 \uc2a4\ud0a4\ub9c8 \uba54\ud0c0\ub370\uc774\ud130\uc5d0 \ub300\ud55c \uc815\uc801 \ubd84\uc11d\ub9cc \uc218\ud589\ud558\uba70, \uc628\ud504\ub808\ubbf8\uc2a4 \ud658\uacbd\uc5d0\uc11c\ub294 SQL \ud14d\uc2a4\ud2b8\uc870\ucc28 \ub124\ud2b8\uc6cc\ud06c\ub97c \ubc97\uc5b4\ub098\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \ubc30\uce58 \uc2a4\uce94\uc740 100\uac1c \uc774\uc0c1\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \ubc31\ub9cc \uac1c \uc774\uc0c1\uc758 \uc5f4\uc744 \uac00\uc9c4 \ud658\uacbd\uc744 \ucc98\ub9ac\ud560 \uc218 \uc788\uc73c\uba70, \uc99d\ubd84 \uc7ac\uc2a4\uce94 \ubc0f \uc601\uad6c\uc801\uc778 \ub370\uc774\ud130 \uacc4\ubcf4 \uc800\uc7a5\uc18c\ub97c \uc81c\uacf5\ud569\ub2c8\ub2e4. \uc790\uc138\ud55c \ub0b4\uc6a9\uc740 \ub2e4\uc74c\uc5d0\uc11c \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <a href=\"https:\/\/www.gudusoft.com\/ko\/%ea%b0%80%ea%b2%a9\/\">\uac00\uaca9 \ud398\uc774\uc9c0<\/a>\uadf8\ub9ac\uace0 <a href=\"https:\/\/www.gudusoft.com\/ko\/sql-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ea%b3%84%eb%b3%b4-%eb%8f%84%ea%b5%ac\/\">SQL \ub370\uc774\ud130 \uacc4\ubcf4 \ub3c4\uad6c \uac1c\uc694<\/a> \ubaa8\ub4e0 \uae30\ub2a5\uc744 \ub2e4\ub8f9\ub2c8\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\uc790\uc8fc \ubb3b\ub294 \uc9c8\ubb38<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">SQLFlow\ub294 SAP HANA\ub97c \uc9c0\uc6d0\ud569\ub2c8\uae4c?<\/h3>\n\n\n<p>\uc608. SAP HANA\ub294 SQLFlow\uc5d0\uc11c \uc790\uccb4 \ubc29\uc5b8\ubcc4 \ud30c\uc11c\ub97c \uc81c\uacf5\ud558\ub294 39\uac1c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc911 \ud558\ub098\uc774\uba70, \ub530\uc634\ud45c\ub85c \ubb36\uc778 \uc2a4\ud0a4\ub9c8 \ud55c\uc815 \uc2dd\ubcc4\uc790\ub97c \ud3ec\ud568\ud55c HANA SQL \uad6c\ubb38\uacfc HANA \ud568\uc218 \ub4f1\uc744 \uc9c0\uc6d0\ud569\ub2c8\ub2e4. <code>IFNULL<\/code> \uadf8\ub9ac\uace0 <code>\uc18c\uc218\uc810 \ubcc0\ud658<\/code>\uc815\uc758\ub97c \ud655\uc778\ud558\uc138\uc694.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">SQLFlow\ub294 \uacc4\uce35\ud615 HANA SQL \ubdf0\ub97c \ud1b5\ud574 \ucd94\uc801 \uacc4\ubcf4\ub97c \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\uae4c?<\/h3>\n\n\n<p>\uc608. \uceec\ub7fc \ucc38\uc870\ub294 \ubdf0, CTE, \uc11c\ube0c\ucffc\ub9ac \ub4f1\uc744 \ud1b5\ud574 \ud574\uacb0\ub429\ub2c8\ub2e4. <code>\uc120\ud0dd\ud558\ub2e4 *<\/code> \ud655\uc7a5\uc131\uc774 \ub6f0\uc5b4\ub098\ubbc0\ub85c \ucd5c\uc0c1\uc704 \ubcf4\uace0 \ubcf4\uae30\uc758 \uc5f4\uc740 \ubaa8\ub4e0 \uc911\uac04 \ubcf4\uae30\ub97c \uac70\uccd0 \ubb3c\ub9ac\uc801 \uc18c\uc2a4 \uc5f4\uae4c\uc9c0 \ucd94\uc801\ub418\uba70 \uacbd\ub85c\ub97c \ub530\ub77c \uac01 \uacc4\uc0b0\uc774 \ud45c\uc2dc\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">SQLFlow\ub294 HANA \uacc4\uc0b0 \ubdf0\ub97c \uc9c0\uc6d0\ud569\ub2c8\uae4c?<\/h3>\n\n\n<p>\uadf8\ub798\ud53d \uacc4\uc0b0 \ubdf0\ub294 SQL\uc774 \uc544\ub2cc XML \ubaa8\ub378\uc774\ubbc0\ub85c SQL \uad6c\ubb38 \ubd84\uc11d \ubc94\uc704\uc5d0\uc11c \uc81c\uc678\ub429\ub2c8\ub2e4. SQLFlow\ub294 SQL\ub85c \ud45c\ud604\ub41c \ubaa8\ub4e0 \uac83\uc744 \ucd94\uc801\ud569\ub2c8\ub2e4. \uc989, \uacc4\uc0b0 \ubdf0\ub97c \ub458\ub7ec\uc2fc SQL \ubdf0\uc640 \uc774\ub97c \ucffc\ub9ac\ud558\ub294 \ubaa8\ub4e0 SQL \ubb38\uc744 \ucd94\uc801\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">SQLFlow\ub294 HANA \ud14c\uc774\ube14\uc758 \ub370\uc774\ud130\uc5d0 \uc811\uadfc\ud574\uc57c \ud558\ub098\uc694?<\/h3>\n\n\n<p>\uc544\ub2c8\uc694. SQLFlow\ub294 SQL \ucf54\ub4dc\uc5d0 \ub300\ud55c \uc815\uc801 \ubd84\uc11d\uc744 \uc218\ud589\ud558\uace0 \uc120\ud0dd\uc801\uc73c\ub85c JDBC\ub97c \ud1b5\ud574 \uc2a4\ud0a4\ub9c8 \uba54\ud0c0\ub370\uc774\ud130\ub97c \uc77d\uc2b5\ub2c8\ub2e4. \ud14c\uc774\ube14 \ud589 \ub370\uc774\ud130\ub294 \uc808\ub300 \uc77d\uc9c0 \uc54a\uc73c\uba70, \uc628\ud504\ub808\ubbf8\uc2a4 \ubc84\uc804\uc740 SQL \ud14d\uc2a4\ud2b8\uc870\ucc28\ub3c4 \ub124\ud2b8\uc6cc\ud06c \ub0b4\ubd80\uc5d0 \ubcf4\uad00\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">HANA SQL\uc744 SQLFlow\ub85c \uac00\uc838\uc624\ub824\uba74 \uc5b4\ub5bb\uac8c \ud574\uc57c \ud558\ub098\uc694?<\/h3>\n\n\n<p>\uc138 \uac00\uc9c0 \ubc29\ubc95\uc774 \uc788\uc2b5\ub2c8\ub2e4. SQL \ucffc\ub9ac\ub97c \ube0c\ub77c\uc6b0\uc800\uc5d0 \uc9c1\uc811 \ubd99\uc5ec\ub123\uac70\ub098, \ubdf0 \uc815\uc758 \ubc0f \uc2a4\ud06c\ub9bd\ud2b8 \ud30c\uc77c\uc744 \uc5c5\ub85c\ub4dc\ud558\uac70\ub098, JDBC\ub97c \ud1b5\ud574 HANA\uc5d0 \uc5f0\uacb0\ud558\uc5ec SQLFlow\uac00 \uce74\ud0c8\ub85c\uadf8\uc5d0\uc11c \uac1d\uccb4 \uc815\uc758\ub97c \uac00\uc838\uc624\ub3c4\ub85d \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uacb0\uacfc\ub294 JSON, CSV, PNG \ud615\uc2dd\uc73c\ub85c \ub0b4\ubcf4\ub0b4\uac70\ub098 REST API\ub97c \ud1b5\ud574 \uc804\uc1a1\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">SQLFlow \uac00\uaca9\uc740 \uc5bc\ub9c8\uc778\uac00\uc694?<\/h3>\n\n\n<p>SQLFlow Cloud\ub294 \ubb34\ub8cc\ub85c \uc2dc\uc791\ud558\uba70, \ud504\ub9ac\ubbf8\uc5c4 \uacc4\uc815\uc740 \uc6d4 $49.99\uc785\ub2c8\ub2e4. SQLFlow On-Premise\ub294 \uc120\ud0dd\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc720\ud615\ub2f9 \uc6d4 $500 \ub610\ub294 \uc77c\ud68c\uc131 $4,800\uc774\uba70, \ub450 \ub300\uc758 \uc11c\ubc84\uc5d0 \uc124\uce58\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ucd94\uac00 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc720\ud615\uc740 \uac01\uac01 \uc6d4 $100 \ub610\ub294 \uc77c\ud68c\uc131 $1,000\uc5d0 \ucd94\uac00\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained\" style=\"background-color:#60d5f6;padding-top:32px;padding-bottom:32px\"><div class=\"wp-block-group__inner-container\">\n\n<h2 class=\"wp-block-heading\">\uc9c0\uae08 HANA \ubdf0\ub97c \ucd94\uc801\ud558\uc138\uc694<\/h2>\n\n\n<p>\ubdf0 \uccb4\uc778\uc744 \ubb34\ub8cc \uc2dc\uac01\ud654 \ub3c4\uad6c\uc5d0 \ubd99\uc5ec\ub123\uc5b4 \uc5f4 \uc218\uc900\uc758 \uacc4\ubcf4\ub97c \ud655\uc778\ud558\uac70\ub098, \uc628\ud504\ub808\ubbf8\uc2a4 HANA \ud658\uacbd \uc804\uccb4\ub97c \uc2a4\uce94\ud558\ub294 \uac83\uc5d0 \ub300\ud574 \ubb38\uc758\ud574 \uc8fc\uc138\uc694.<\/p>\n\n\n<div class=\"wp-block-buttons is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/sqlflow.gudusoft.com\/?utm_source=gudusoft&amp;utm_medium=website&amp;utm_campaign=sap-hana-data-lineage\" target=\"_blank\" rel=\"noreferrer noopener\">SQLFlow\ub97c \ubb34\ub8cc\ub85c \uc0ac\uc6a9\ud574 \ubcf4\uc138\uc694.<\/a><\/div>\n<\/div>\n\n\n<div class=\"wp-block-buttons is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/www.gudusoft.com\/ko\/%ec%97%b0%eb%9d%bd%ed%95%98%eb%8b%a4\/\">\uae30\uc5c5\uc6a9 \ub370\ubaa8\ub97c \uc694\uccad\ud558\uc138\uc694<\/a><\/div>\n<\/div>\n\n<\/div><\/div>\n\n\n\n<script type=\"application\/ld+json\">{\n    \"@context\": \"https:\\\/\\\/schema.org\",\n    \"@graph\": [\n        {\n            \"@type\": \"SoftwareApplication\",\n            \"name\": \"Gudu SQLFlow\",\n            \"applicationCategory\": \"DeveloperApplication\",\n            \"applicationSubCategory\": \"SQL Data Lineage Tool\",\n            \"operatingSystem\": \"Web, Linux, Windows, macOS\",\n            \"url\": \"https:\\\/\\\/www.gudusoft.com\\\/sap-hana-data-lineage\\\/\",\n            \"description\": \"Automated SQL data lineage tool with a dedicated SAP HANA dialect parser. Traces column-level lineage through layered HANA SQL views and calculated columns across 39 supported databases.\",\n            \"featureList\": \"SAP HANA dialect parser, column-level lineage, indirect\\\/impact lineage, layered view resolution, JDBC metadata import, JSON\\\/CSV\\\/PNG export, REST API, DataHub\\\/Purview\\\/OpenMetadata export\",\n            \"softwareVersion\": \"8.2.3\",\n            \"offers\": [\n                {\n                    \"@type\": \"Offer\",\n                    \"name\": \"SQLFlow Cloud Free\",\n                    \"price\": \"0\",\n                    \"priceCurrency\": \"USD\"\n                },\n                {\n                    \"@type\": \"Offer\",\n                    \"name\": \"SQLFlow Cloud Premium\",\n                    \"price\": \"49.99\",\n                    \"priceCurrency\": \"USD\",\n                    \"priceSpecification\": {\n                        \"@type\": \"UnitPriceSpecification\",\n                        \"price\": \"49.99\",\n                        \"priceCurrency\": \"USD\",\n                        \"billingIncrement\": 1,\n                        \"unitText\": \"MONTH\"\n                    }\n                },\n                {\n                    \"@type\": \"Offer\",\n                    \"name\": \"SQLFlow On-Premise\",\n                    \"price\": \"4800\",\n                    \"priceCurrency\": \"USD\"\n                }\n            ],\n            \"publisher\": {\n                \"@type\": \"Organization\",\n                \"name\": \"Gudu Software\",\n                \"url\": \"https:\\\/\\\/www.gudusoft.com\\\/\"\n            }\n        },\n        {\n            \"@type\": \"FAQPage\",\n            \"mainEntity\": [\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"Does SQLFlow support SAP HANA?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"Yes. SAP HANA is one of 39 databases with its own dialect-specific parser in SQLFlow, covering HANA SQL syntax including quoted schema-qualified identifiers, HANA functions such as IFNULL and TO_DECIMAL, and view definitions.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"Can SQLFlow trace lineage through layered HANA SQL views?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"Yes. Column references are resolved through views, CTEs, subqueries, and SELECT * expansion, so a column in a top-level reporting view is traced through every intermediate view down to the physical source columns, with each calculation shown along the path.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"Does SQLFlow handle HANA calculation views?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"Graphical calculation views are XML models rather than SQL, so they are outside the scope of SQL parsing. SQLFlow traces everything expressed as SQL: the SQL views layered around calculation views, and any SQL statements that query them.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"Does SQLFlow need access to the data in my HANA tables?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"No. SQLFlow performs static analysis of SQL code and optionally reads schema metadata over JDBC. It never reads table row data, and the On-Premise edition keeps even the SQL text inside your network.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"How do I get my HANA SQL into SQLFlow?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"Three ways: paste SQL directly into the browser, upload files of view definitions and scripts, or connect to HANA over JDBC so SQLFlow pulls object definitions from the catalog. Results export as JSON, CSV, or PNG, or through the REST API.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"How much does SQLFlow cost?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"SQLFlow Cloud starts free; premium accounts are $49.99\\\/month. SQLFlow On-Premise is $500\\\/month or $4,800 one-time per selected database type, installable on two servers, with additional database types at $100\\\/month or $1,000 one-time each.\"\n                    }\n                }\n            ]\n        }\n    ]\n}<\/script>","protected":false},"excerpt":{"rendered":"<p>SAP HANA data lineage is the column-level map of how data moves through your HANA SQL: which source tables and columns feed each SQL view, calculated column, and downstream report, and which joins, filters, casts, and functions transform the data along the way. Gudu SQLFlow builds that map automatically by parsing your HANA SQL with a dedicated SAP HANA dialect parser \u2014 one of 39 dialect-specific parsers, not a generic ANSI grammar \u2014 and rendering an interactive, drillable lineage diagram down to individual columns. Try it now: paste a HANA CREATE VIEW chain into the free SQLFlow lineage visualizer, select\u2026<\/p>","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":5}},"_links":{"self":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/pages\/6769"}],"collection":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/comments?post=6769"}],"version-history":[{"count":0,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/pages\/6769\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/media?parent=6769"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}