{"id":272,"date":"2009-02-12T23:51:20","date_gmt":"2009-02-12T22:51:20","guid":{"rendered":"http:\/\/www.auditsi.eu\/?p=272"},"modified":"2011-09-21T01:07:46","modified_gmt":"2011-09-20T23:07:46","slug":"utilisation-des-bases-de-donnees-par-l%e2%80%99utilisateur-extraction-de-donnees-d%e2%80%99un-erp-a-partir-d%e2%80%99un-module-de-requete","status":"publish","type":"post","link":"https:\/\/www.auditsi.eu\/?p=272","title":{"rendered":"Utilisation des bases de donn\u00e9es par l\u2019utilisateur : extraction de donn\u00e9es d\u2019un ERP \u00e0 partir d\u2019un module de requ\u00eate"},"content":{"rendered":"<p style=\"text-align: justify;\">Un ERP (Entreprise Resource Planning ou en Fran\u00e7ais : Progiciel de Gestion Int\u00e9gr\u00e9) est un logiciel qui assure la gestion commerciale (GRC), la gestion des stocks, la gestion de la production, la tenue de la comptabilit\u00e9&#8230; Un ERP centralise donc l&#8217;enregistrement de l&#8217;ensemble des flux financiers et physiques de l&#8217;entreprise. Les ERP modernes stockent leurs donn\u00e9es dans des bases de donn\u00e9es. L&#8217;extraction de donn\u00e9es \u00e0 l&#8217;aide d&#8217;un module de requ\u00eates aidera la direction financi\u00e8re \u00e0 \u00e9tablir les situations comptables et l&#8217;auditeur \u00e0 r\u00e9pondre \u00e0 ses objectifs d&#8217;audit.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-274\" title=\"hyperion\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2009\/02\/hyperion.jpg\" alt=\"hyperion\" width=\"561\" height=\"417\" \/><\/p>\n<p style=\"text-align: justify;\">HYPERION, module de requ\u00eate, coupl\u00e9 \u00e0 DIVALTO, un ERP install\u00e9 dans de nombreuses PME, assurent pr\u00e9cis\u00e9ment l&#8217;ex\u00e9cution de ces t\u00e2ches. Apr\u00e8s authentification de l&#8217;utilisateur, le module acc\u00e8de au catalogue de tables de la base de donn\u00e9es de l&#8217;ERP. L&#8217;interrogation et l&#8217;extraction de donn\u00e9es sont maintenant accessibles ais\u00e9ment \u00e0 l&#8217;utilisateur. Le r\u00e9sultat est exportable dans EXCEL ou ACCESS pour d&#8217;autres traitements (analyse, mise en forme&#8230;).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-273\" title=\"hyperion-2\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2009\/02\/hyperion-2-1024x652.jpg\" alt=\"hyperion-2\" width=\"561\" height=\"422\" \/><\/p>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img decoding=\"async\" src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"Utilisation%20des%20bases%20de%20donn%C3%A9es%20par%20l%E2%80%99utilisateur%20%3A%20extraction%20de%20donn%C3%A9es%20d%E2%80%99un%20ERP%20%C3%A0%20partir%20d%E2%80%99un%20module%20de%20requ%C3%AAte\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"excerpt":{"rendered":"<p>Un ERP (Entreprise Resource Planning ou en Fran\u00e7ais : Progiciel de Gestion Int\u00e9gr\u00e9) est un logiciel qui assure la gestion commerciale (GRC), la gestion des stocks, la gestion de la production, la tenue de la comptabilit\u00e9&#8230; Un ERP centralise donc l&#8217;enregistrement de l&#8217;ensemble des flux financiers et physiques de l&#8217;entreprise. Les ERP modernes stockent leurs &#8230;<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?p=272\" class=\"more-link\">Continue reading &lsquo;Utilisation des bases de donn\u00e9es par l\u2019utilisateur : extraction de donn\u00e9es d\u2019un ERP \u00e0 partir d\u2019un module de requ\u00eate&rsquo; &raquo;<\/a><\/p>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"Utilisation%20des%20bases%20de%20donn%C3%A9es%20par%20l%E2%80%99utilisateur%20%3A%20extraction%20de%20donn%C3%A9es%20d%E2%80%99un%20ERP%20%C3%A0%20partir%20d%E2%80%99un%20module%20de%20requ%C3%AAte\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"ngg_post_thumbnail":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","_links_to":"","_links_to_target":""},"categories":[7,8,24,33],"tags":[73,70,1633,22,72,74,71,57,1624,1627],"class_list":["post-272","post","type-post","status-publish","format-standard","hentry","category-breves","category-extractions-de-donnees","category-systeme-dinformation","category-systeme-informatique","tag-divalto","tag-erp","tag-excel","tag-extraction-de-donnees","tag-grc","tag-hyperion","tag-pgi","tag-requete-sql","tag-systeme-dinformation","tag-systeme-informatique"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_likes_enabled":false,"_links":{"self":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/272","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=272"}],"version-history":[{"count":0,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/272\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=272"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=272"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=272"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}