{"id":257,"date":"2014-10-24T16:35:26","date_gmt":"2014-10-24T13:35:26","guid":{"rendered":"http:\/\/phpax.wordpress.com\/?p=257"},"modified":"2020-05-12T23:21:16","modified_gmt":"2020-05-12T20:21:16","slug":"dynamics-ax-2012-ile-odata-kullanimi","status":"publish","type":"post","link":"https:\/\/guvensahin.com\/tr\/dynamics-ax-2012-ile-odata-kullanimi\/","title":{"rendered":"Dynamics AX 2012 ile OData kullan\u0131m\u0131"},"content":{"rendered":"

Merhabalar,<\/p>\n

Bu yaz\u0131mda sizlere Dynamics AX 2012 de OData kullan\u0131m\u0131n\u0131 anlataca\u011f\u0131m. \u00d6ncelikle “OData nedir ?” sorusuna cevap vermekle ba\u015flayal\u0131m. A\u00e7\u0131l\u0131m\u0131 Open Data Protocol<\/a>‘d\u00fcr. K\u0131saca veritaban\u0131na web(http) \u00fczerinden sorguda bulunman\u0131za yarar.<\/p>\n

Normalde uzaktaki bir veritaban\u0131ndan web, mobil veya bir desktop uygulamadan sorgu yapabilmek i\u00e7in bir web servisiniz olmas\u0131 gerekir, bu sayede verinin b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc ve g\u00fcvenli\u011fini sa\u011flayabilirsiniz. OData ise web servis yaz\u0131lmas\u0131na gerek kalmadan direkt olarak veritaban\u0131na http \u00fczerinden sorgu \u00e7ekebilmenize yarar.<\/p>\n

Daha iyi anlaman\u0131z i\u00e7in \u00f6rnek bir OData sorgu linki “http:\/\/crmServer\/AdventureWorksCycle\/XRMServices\/2011\/OrganizationData.svc\/ContactSet?$select=FirstName,LastName”<\/em>.<\/p>\n

Bu sorgu sonucunda bir xml \u00e7\u0131kt\u0131s\u0131nda isim ve soyisim de\u011feri d\u00f6ner. Dynamics AX 2012 de OData y\u0131 kullanabilmek i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 izlemelisiniz.<\/p>\n

“Organizasyon y\u00f6netimi > Kurulum > Belge y\u00f6netimi > Belgenin veri kaynaklar\u0131” formunu i\u00e7in.
\n(Organization Administration > Setup > Document management > Document data sources.)<\/em><\/p>\n

\"1\"<\/a><\/p>\n

A\u00e7\u0131lan formda “New” butonuna bas\u0131p yeni bir kay\u0131t yaratal\u0131m. Doldurmam\u0131z gereken kolonlar\u0131 s\u0131ras\u0131yla inceleyelim.<\/p>\n

    \n
  1. Mod\u00fcl:<\/strong> Burada kullanmak istedi\u011fimiz AOT Query’sinin hangi mod\u00fclde oldu\u011funu belirtiyoruz. \u00d6rne\u011fin “ProjTable” query’si i\u00e7in “Projeler” mod\u00fcl\u00fcn\u00fc se\u00e7memiz gerek.<\/li>\n
  2. Veri kayna\u011f\u0131 t\u00fcr\u00fc:<\/strong> Burada sorgu t\u00fcr\u00fc olarak ne kullan\u0131laca\u011f\u0131 belirleniyor. Se\u00e7ilebilecek 3 se\u00e7enek mevcut.\n
      \n
    1. Servis:<\/strong> Halihaz\u0131rda Ax da bulunan bir servisi se\u00e7ebilirsiniz.<\/li>\n
    2. Query reference:<\/strong> Ax i\u00e7inde bir AOT query’si se\u00e7ebilirsiniz.<\/li>\n
    3. Custom query:<\/strong> Yine ax i\u00e7inde bir AOT query’si se\u00e7iyorsunuz. Fakat bu sefer query’e yukar\u0131daki “Sorguyu d\u00fczenle” butonu ile herhangi bir kriter verebiliyorsunuz.<\/li>\n<\/ol>\n<\/li>\n
    4. Veri kayna\u011f\u0131 ad\u0131:<\/strong> Bu k\u0131s\u0131mda sorgunuza bir isim vermeniz gerek. Buradaki isim \u00f6nemli. \u00c7\u00fcnk\u00fc daha sonra web \u00fczerinden sorguyu \u00e7a\u011f\u0131r\u0131rken buradaki ismi kullanaca\u011f\u0131z.<\/li>\n
    5. Son olarak “Aktif” se\u00e7ene\u011fini i\u015faretleyerek i\u015flemi tamaml\u0131yoruz.<\/li>\n<\/ol>\n

      Art\u0131k AOS’un y\u00fckl\u00fc oldu\u011fu server’a eri\u015febilece\u011finiz bir bilgisayarda taray\u0131c\u0131n\u0131z\u0131 a\u00e7\u0131p a\u015fa\u011f\u0131daki linki girin:<\/p>\n

      http:\/\/192.168.0.191:8101\/DynamicsAx\/Services\/ODataQueryService<\/a><\/p>\n

        \n
      1. Buradaki 191 ile biten IP, AOS’un y\u00fckl\u00fc oldu\u011fu makine.<\/li>\n
      2. 8101<\/strong> standart port de\u011feri. Herhangi bir de\u011fi\u015fiklik yap\u0131lmam\u0131\u015f ise standartta bu kullan\u0131l\u0131r<\/a>.<\/li>\n<\/ol>\n

        Linki girdikten sonra taray\u0131c\u0131n\u0131z kullan\u0131c\u0131 ad\u0131 ve \u015fifre isteyebilir. Bu bilgileri giriniz. Ard\u0131ndan ekran\u0131n\u0131za \u015f\u00f6yle bir xml \u00e7\u0131kt\u0131s\u0131 gelmesi gerekli.<\/p>\n

        \"2\"<\/a><\/p>\n

        Burada kullan\u0131ma haz\u0131r olan(Aktif i\u015faretlenmi\u015f) sorgular\u0131 g\u00f6r\u00fcyoruz. Biz yeni ekledi\u011fimiz ProjTable sorgusu i\u00e7in linkin sonuna sorgunun ismini yaz\u0131yoruz.<\/p>\n

        http:\/\/192.168.0.191:8101\/DynamicsAx\/Services\/ODataQueryService\/ProjTable_Copy_1<\/a><\/p>\n

        Ax’\u0131n standart “ProjTable” AOT query’sinin sonucunu xml olarak g\u00f6rebilirsiniz.<\/p>\n

        \"3\"<\/a><\/p>\n

        Son olarak a\u015fa\u011f\u0131daki adreslerde Ax OData sorgusunun excelden eri\u015filmesi anlat\u0131lm\u0131\u015f.<\/p>\n

          \n
        1. http:\/\/technet.microsoft.com\/en-us\/library\/dn198214.aspx<\/a><\/li>\n
        2. http:\/\/dynamicsaxtipoftheday.com\/2014\/02\/10\/publish-queries-as-odata-document-sources-for-users-to-query-in-excel\/<\/a><\/li>\n<\/ol>\n

          Son olarak bu adresten<\/a> OData’n\u0131n AX da kullan\u0131m\u0131 ile ilgili detayl\u0131 bilgi ve Ax i\u00e7in mevcut k\u0131s\u0131tlamalar hakk\u0131nda detayl\u0131 bilgi edinebilirsiniz.<\/p>\n

          \u015eimdilik Ho\u015f\u00e7akal\u0131n,
          \nG\u00fcven \u015eahin.<\/p>\n","protected":false},"excerpt":{"rendered":"

          Merhabalar, Bu yaz\u0131mda sizlere Dynamics AX 2012 de OData kullan\u0131m\u0131n\u0131 anlataca\u011f\u0131m. \u00d6ncelikle “OData nedir ?” sorusuna cevap vermekle ba\u015flayal\u0131m. A\u00e7\u0131l\u0131m\u0131 Open Data Protocol‘d\u00fcr. K\u0131saca veritaban\u0131na web(http) \u00fczerinden sorguda bulunman\u0131za yarar. Normalde uzaktaki bir veritaban\u0131ndan web, mobil veya bir desktop uygulamadan sorgu yapabilmek i\u00e7in bir web servisiniz olmas\u0131 gerekir, bu sayede verinin b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc ve g\u00fcvenli\u011fini sa\u011flayabilirsiniz.… Daha fazlas\u0131n\u0131 oku »Dynamics AX 2012 ile OData kullan\u0131m\u0131<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","footnotes":""},"categories":[234],"tags":[193,198,213,285],"class_list":["post-257","post","type-post","status-publish","format-standard","hentry","category-dynamics-ax","tag-axapta","tag-dynamics-ax-2","tag-odata","tag-x"],"_links":{"self":[{"href":"https:\/\/guvensahin.com\/tr\/wp-json\/wp\/v2\/posts\/257","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/guvensahin.com\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/guvensahin.com\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/guvensahin.com\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/guvensahin.com\/tr\/wp-json\/wp\/v2\/comments?post=257"}],"version-history":[{"count":1,"href":"https:\/\/guvensahin.com\/tr\/wp-json\/wp\/v2\/posts\/257\/revisions"}],"predecessor-version":[{"id":367,"href":"https:\/\/guvensahin.com\/tr\/wp-json\/wp\/v2\/posts\/257\/revisions\/367"}],"wp:attachment":[{"href":"https:\/\/guvensahin.com\/tr\/wp-json\/wp\/v2\/media?parent=257"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/guvensahin.com\/tr\/wp-json\/wp\/v2\/categories?post=257"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/guvensahin.com\/tr\/wp-json\/wp\/v2\/tags?post=257"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}