![\"Integrating](\"https:\/\/profelis.com.tr\/wp-content\/uploads\/2021\/10\/integrating-postgresql-2.png\" "\\"\\"")
<\/p>\nUygulama Entegrasyonu<\/b> yaz\u0131s\u0131yla ba\u015flayan PostgreSQL Entegrasyonu blog serimize devam ediyoruz. \u015eimdi ise PostgreSQL entegrasyonunu kurumlar\u0131n daha fazla ve daha h\u0131zl\u0131 \u00e7al\u0131\u015fabilmesi i\u00e7in ke\u015ffetmeye devam edece\u011fiz.<\/p>\n
Bu blog yaz\u0131s\u0131, alandaki di\u011fer bir \u00f6nemli konuya odaklanmaktad\u0131r: Veri Entegrasyonu ve G\u00f6\u00e7.<\/p>\n
<\/p>\n
Ba\u015far\u0131l\u0131 PostgreSQL\u00ae uygulamalar\u0131, kurum \u00e7evresiyle tam olarak entegre olur ve \u201cveri adalar\u0131\u201d yaratmaz.<\/span><\/p>\n PostgreSQL i\u00e7inde bulundu\u011fu ekosisteme entegre olabilmesini sa\u011flayan bir kapasitesi vard\u0131r: SQL MED standard\u0131n\u0131n bir uygulamas\u0131 olan Yabanc\u0131 Veri Paketleyiciler (Foreign Data Wrappers – FDW). FDW\u2019ler ilk olarak PostgreSQL 9.1 ile kullan\u0131lmaya ba\u015flanm\u0131\u015ft\u0131r ve bug\u00fcn \u00e7o\u011funlukla uzak PostgreSQL veritabanlar\u0131, Hadoop, MySQL, Mongo, Oracle ve benzeri entegrasyonu i\u00e7in kullan\u0131lmaktad\u0131r. ETL (Extract, Transform, Load) (Ay\u0131kla, D\u00f6n\u00fc\u015ft\u00fcr, Y\u00fckle) tipi uygulama ara\u00e7lar\u0131n\u0131n aksine, FDW\u2019ler veriyi kopyalamaz veya ta\u015f\u0131maz. Bunun yerine, veriye yerinde eri\u015fir ve uzak (yabanc\u0131) veri deposuna g\u00f6nderir.<\/span><\/p>\n \u0130yi uygulanm\u0131\u015f FDW\u2019ler, s\u00fctun se\u00e7imiyle birlikte a\u015fa\u011f\u0131 itmeleri de destekler, toplar ve birle\u015ftirir. HDFS<\/b><\/a>, <\/span>MongoDB<\/b><\/a> ve <\/span>MySQL<\/b><\/a> i\u00e7in FDW\u2019ler \u00e7ok pop\u00fclerdir ve EDB taraf\u0131ndan bak\u0131m\u0131 yap\u0131l\u0131r. Bu blogda FDW\u2019lerin nas\u0131l kullan\u0131laca\u011f\u0131na dair talimatlar yer almaktad\u0131r.<\/p>\n Giderek artan ETL sat\u0131c\u0131lar\u0131, entegrasyon ara\u00e7lar\u0131na kaynak ve hedef olarak PostgreSQL\u2019i ekliyor. 2021\u2019de EDB\u2019nin web sitesini ziyaret edenlerle yap\u0131lan bir ankete g\u00f6re, a\u015fa\u011f\u0131daki ara\u00e7lar PostgreSQL kullan\u0131c\u0131lar\u0131 aras\u0131ndan pop\u00fclerdir (alfabetik s\u0131rayla):<\/p>\n Oracle ve SQL Server gibi eski veritabanlar\u0131ndan g\u00f6\u00e7 etmek, EDB\u2019nin G\u00f6\u00e7 Ara\u00e7lar\u0131 ve EDB Replikasyon Sunucusu gibi kurumsal d\u00fczeyde \u00e7\u00f6z\u00fcmlerle ve Oracle veya OR2PG gibi a\u00e7\u0131k kaynak ara\u00e7larla desteklenmektedir. A\u00e7\u0131k kaynak kodlu ara\u00e7lar, veri tan\u0131mlar\u0131n\u0131n ve yayg\u0131n veri tiplerinin g\u00f6\u00e7\u00fcyle s\u0131n\u0131rl\u0131 olma e\u011filimindedir. EDB\u2019nin G\u00f6\u00e7 Portal\u0131\u2019\u0131 ve EDB Replikasyon Sunucusu gibi \u00f6zelle\u015fmi\u015f ara\u00e7lar, art\u0131ml\u0131 ge\u00e7i\u015fler i\u00e7in veri yakalamay\u0131 de\u011fi\u015ftirebilmek gibi daha kapsaml\u0131 \u00f6zellikler sunar.<\/p>\n Bu serinin devam\u0131nda gelecek Geli\u015ftirme Ara\u00e7lar\u0131 yaz\u0131s\u0131 i\u00e7in takipte kal\u0131n. Bu s\u0131rada, PostgreSQL entegrasyonuna dair b\u00fcy\u00fck resmi g\u00f6rmek i\u00e7in infografi\u011fimizi<\/b><\/a> inceleyin.<\/p>\n Uygulama Entegrasyonu yaz\u0131s\u0131yla ba\u015flayan PostgreSQL Entegrasyonu blog serimize devam ediyoruz. \u015eimdi ise PostgreSQL entegrasyonunu kurumlar\u0131n daha fazla ve daha h\u0131zl\u0131 \u00e7al\u0131\u015fabilmesi i\u00e7in ke\u015ffetmeye devam edece\u011fiz. Bu blog yaz\u0131s\u0131, alandaki di\u011fer bir \u00f6nemli konuya odaklanmaktad\u0131r: Veri Entegrasyonu ve G\u00f6\u00e7. Veri Entegrasyonu…<\/p>","protected":false},"author":16,"featured_media":22104,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[75,45],"tags":[58,48,50],"class_list":["post-18699","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-postgresql","category-yazi","tag-acikkaynak","tag-enterprisedb","tag-veritabani"],"_links":{"self":[{"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/posts\/18699","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/users\/16"}],"replies":[{"embeddable":true,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/comments?post=18699"}],"version-history":[{"count":0,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/posts\/18699\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/media\/22104"}],"wp:attachment":[{"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/media?parent=18699"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/categories?post=18699"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/tags?post=18699"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}\n
Kaynak: Integrating PostgreSQL Part 2: Data Integration and Migration<\/a>, EDB Ekibi May\u0131s 13, 2021\n\u00a9 Copyright EnterpriseDB Corporation 2020 EnterpriseDB Corporation\n34 Crosby Drive Suite 201 Bedford, MA 01730\nEnterpriseDB and Postgres Enterprise Manager are registered trademarks of EnterpriseDB Corporation. EDB and EDB Postgres are trademarks of EnterpriseDB Corporation. Oracle is a registered trademark of Oracle, Inc. Other trademarks may be trademarks of their respective owners.<\/pre>","protected":false},"excerpt":{"rendered":"