{"id":3146,"date":"2019-12-23T16:45:58","date_gmt":"2019-12-23T16:45:58","guid":{"rendered":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/?post_type=chapter&#038;p=3146"},"modified":"2025-10-30T15:43:27","modified_gmt":"2025-10-30T15:43:27","slug":"external-data","status":"publish","type":"chapter","link":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/chapter\/external-data\/","title":{"raw":"External Data","rendered":"External Data"},"content":{"raw":"<div class=\"textbox learning-objectives\">\r\n<h3>Learning Outcomes<\/h3>\r\n<ul>\r\n \t<li>Discuss the value of external data<\/li>\r\n<\/ul>\r\n<\/div>\r\nNot all information necessary for business purposes may be stored in the same place. Even if the data resides in locations within the firewalls of the business, it may be in different applications or formats. In the example below from an Oracle administrator\u2019s manual, data stored in different, distributed repositories can be a good thing, but there are many variables to consider.\r\n\r\n<img class=\"aligncenter wp-image-3609 size-medium\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/15210802\/Distributed-and-Remote-Data-300x276.png\" alt=\"Image from Oracle administrator\u2019s manual showing the flow of information between three separate systems and system users.\" width=\"300\" height=\"276\" \/>\r\n\r\nThis is an ideal example of a well-architected database system where users are getting maximum value from three separate systems that seamlessly working together as one. In most cases, external data\u2014or data not residing in the current database\u2014is much trickier to utilize. External data is usually stored in differing applications in differing formats. Access can use data in the following formats: Oracle, SQL Server and other ODBC compliant databases, Excel, XML, HTML, Word documents and text files.\r\n<div class=\"textbox tryit\">\r\n<h3>Practice Question<\/h3>\r\nhttps:\/\/assess.lumenlearning.com\/practice\/f4854fed-9260-483b-ab3f-e3263e652f02\r\n\r\n<\/div>","rendered":"<div class=\"textbox learning-objectives\">\n<h3>Learning Outcomes<\/h3>\n<ul>\n<li>Discuss the value of external data<\/li>\n<\/ul>\n<\/div>\n<p>Not all information necessary for business purposes may be stored in the same place. Even if the data resides in locations within the firewalls of the business, it may be in different applications or formats. In the example below from an Oracle administrator\u2019s manual, data stored in different, distributed repositories can be a good thing, but there are many variables to consider.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3609 size-medium\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/15210802\/Distributed-and-Remote-Data-300x276.png\" alt=\"Image from Oracle administrator\u2019s manual showing the flow of information between three separate systems and system users.\" width=\"300\" height=\"276\" \/><\/p>\n<p>This is an ideal example of a well-architected database system where users are getting maximum value from three separate systems that seamlessly working together as one. In most cases, external data\u2014or data not residing in the current database\u2014is much trickier to utilize. External data is usually stored in differing applications in differing formats. Access can use data in the following formats: Oracle, SQL Server and other ODBC compliant databases, Excel, XML, HTML, Word documents and text files.<\/p>\n<div class=\"textbox tryit\">\n<h3>Practice Question<\/h3>\n<p>\t<iframe id=\"assessment_practice_f4854fed-9260-483b-ab3f-e3263e652f02\" class=\"resizable\" src=\"https:\/\/assess.lumenlearning.com\/practice\/f4854fed-9260-483b-ab3f-e3263e652f02?iframe_resize_id=assessment_practice_id_f4854fed-9260-483b-ab3f-e3263e652f02\" frameborder=\"0\" style=\"border:none;width:100%;height:100%;min-height:300px;\"><br \/>\n\t<\/iframe><\/p>\n<\/div>\n\n\t\t\t <section class=\"citations-section\" role=\"contentinfo\">\n\t\t\t <h3>Candela Citations<\/h3>\n\t\t\t\t\t <div>\n\t\t\t\t\t\t <div id=\"citation-list-3146\">\n\t\t\t\t\t\t\t <div class=\"licensing\"><div class=\"license-attribution-dropdown-subheading\">CC licensed content, Original<\/div><ul class=\"citation-list\"><li>External Data. <strong>Authored by<\/strong>: Robert Danielson. <strong>Provided by<\/strong>: Lumen Learning. <strong>License<\/strong>: <em><a target=\"_blank\" rel=\"license\" href=\"https:\/\/creativecommons.org\/licenses\/by\/4.0\/\">CC BY: Attribution<\/a><\/em><\/li><\/ul><\/div>\n\t\t\t\t\t\t <\/div>\n\t\t\t\t\t <\/div>\n\t\t\t <\/section>","protected":false},"author":17,"menu_order":3,"template":"","meta":{"_candela_citation":"[{\"type\":\"original\",\"description\":\"External Data\",\"author\":\"Robert Danielson\",\"organization\":\"Lumen Learning\",\"url\":\"\",\"project\":\"\",\"license\":\"cc-by\",\"license_terms\":\"\"}]","CANDELA_OUTCOMES_GUID":"560a22ab-5ffc-4080-97ed-2eff76298ad0, 43bf19f4-5c2e-43df-b989-4f2b73b217c4","pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"class_list":["post-3146","chapter","type-chapter","status-publish","hentry"],"part":2775,"_links":{"self":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/pressbooks\/v2\/chapters\/3146","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/pressbooks\/v2\/chapters"}],"about":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/wp\/v2\/types\/chapter"}],"author":[{"embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/wp\/v2\/users\/17"}],"version-history":[{"count":14,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/pressbooks\/v2\/chapters\/3146\/revisions"}],"predecessor-version":[{"id":5586,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/pressbooks\/v2\/chapters\/3146\/revisions\/5586"}],"part":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/pressbooks\/v2\/parts\/2775"}],"metadata":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/pressbooks\/v2\/chapters\/3146\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/wp\/v2\/media?parent=3146"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/pressbooks\/v2\/chapter-type?post=3146"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/wp\/v2\/contributor?post=3146"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/wp\/v2\/license?post=3146"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}