{"id":5911,"date":"2022-04-06T01:06:03","date_gmt":"2022-04-05T22:06:03","guid":{"rendered":"https:\/\/kutaybilen.com.tr\/?p=5911"},"modified":"2022-04-06T01:06:03","modified_gmt":"2022-04-05T22:06:03","slug":"ziyanli-yazilimlarin-yeni-yayilma-yolu-excel","status":"publish","type":"post","link":"https:\/\/kutaybilen.com.tr\/?p=5911","title":{"rendered":"Ziyanl\u0131 Yaz\u0131l\u0131mlar\u0131n Yeni Yay\u0131lma Yolu: Excel"},"content":{"rendered":"<p>G\u00fcvenlik ara\u015ft\u0131rmac\u0131lar\u0131, Microsoft Excel i\u00e7indeki Powe Query \u00f6zelli\u011fini kullanarak ziyanl\u0131 kodlar\u0131 en az etkile\u015fimle \u00e7al\u0131\u015ft\u0131rman\u0131n yolunu buldu. Power Query, en temelinde farkl\u0131 kaynaklarda bilgi bulmay\u0131, bilgileri ba\u011flamay\u0131, birle\u015ftirmeyi ve d\u00f6n\u00fc\u015ft\u00fcrmeyi sa\u011flayan bir \u00f6zelliktir. Siz bu datay\u0131 di\u011fer bir evraktan, \u00f6rne\u011fin uzak bir sunucudaki Access bilgi taban\u0131ndan \u00e7ekebilirsiniz.<\/p>\n<p>Asl\u0131nda \u00e7ok fonksiyonlu bir \u00f6zellik olan Power Query, g\u00fcn\u00fcm\u00fczdeki Excel versiyonlar\u0131nda b\u00fct\u00fcnle\u015fik olarak vard\u0131r. Eski versiyonlara da eklenti olarak indirilebiliyor.\u00a0<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.webtekno.com\/images\/editor\/default\/0002\/08\/7aee80a1341289f7df55e679c728ef93a9c15c02.jpeg\"\/><\/p>\n<p>Yol, \u00f6z\u00fcnde hasarl\u0131 bir Excel belgesi olu\u015fturmaya dayan\u0131yor. Ziyanl\u0131 yaz\u0131l\u0131m di\u011fer uzak bir noktaya y\u00fckleniyor, Excel belgesi a\u00e7\u0131ld\u0131\u011f\u0131nda Power Query sayesinde o ziyanl\u0131 yaz\u0131l\u0131m ba\u011flanan makineye \u00e7ekiliyor Sistem, g\u00fcvenlik ihtarlar\u0131n\u0131 da rahat\u00e7a a\u015f\u0131yor, sistemler ziyanl\u0131 olabilir uyar\u0131s\u0131 vermiyor.\u00a0<\/p>\n<p>Microsoft, 2017 y\u0131l\u0131nda da DDE konusunda k\u00fclfet ya\u015fam\u0131\u015ft\u0131. O devirde yama \u00e7\u0131karmay\u0131 reddeden Microsoft, bu kere da birebir davran\u0131\u015f\u0131 s\u00fcrd\u00fcrd\u00fc. Microsoft, bireylerin DDE (Dynamic Veri Exchange) \u00f6zelli\u011fini devre d\u0131\u015f\u0131 b\u0131rakmalar\u0131n\u0131 istedi. Teknik olarak Power Query de DDE \u00fczerine in\u015fa edildi.\u00a0<\/p>\n<div> <\/div>\n<div>\n<div> <\/div>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"<p>G\u00fcvenlik ara\u015ft\u0131rmac\u0131lar\u0131, Microsoft Excel i\u00e7indeki Powe Query \u00f6zelli\u011fini kullanarak ziyanl\u0131 kodlar\u0131 en az etkile\u015fimle \u00e7al\u0131\u015ft\u0131rman\u0131n yolunu buldu &#8230;<\/p>\n","protected":false},"author":1,"featured_media":5912,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[854],"tags":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/kutaybilen.com.tr\/index.php?rest_route=\/wp\/v2\/posts\/5911"}],"collection":[{"href":"https:\/\/kutaybilen.com.tr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kutaybilen.com.tr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kutaybilen.com.tr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kutaybilen.com.tr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5911"}],"version-history":[{"count":1,"href":"https:\/\/kutaybilen.com.tr\/index.php?rest_route=\/wp\/v2\/posts\/5911\/revisions"}],"predecessor-version":[{"id":5913,"href":"https:\/\/kutaybilen.com.tr\/index.php?rest_route=\/wp\/v2\/posts\/5911\/revisions\/5913"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kutaybilen.com.tr\/index.php?rest_route=\/wp\/v2\/media\/5912"}],"wp:attachment":[{"href":"https:\/\/kutaybilen.com.tr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5911"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kutaybilen.com.tr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5911"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kutaybilen.com.tr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5911"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}