{"id":359,"date":"2022-12-01T20:32:45","date_gmt":"2022-12-01T20:32:45","guid":{"rendered":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/chapter\/external-data\/"},"modified":"2022-12-01T20:32:45","modified_gmt":"2022-12-01T20:32:45","slug":"external-data","status":"publish","type":"chapter","link":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/chapter\/external-data\/","title":{"raw":"External Data","rendered":"External Data"},"content":{"raw":"\n<div class=\"textbox learning-objectives\">\n<h3>Learning Outcomes<\/h3>\n<ul>\n \t<li>Discuss the value of external data<\/li>\n<\/ul>\n<\/div>\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.\n\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\">\n\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.\n<div class=\"textbox tryit\">\n<h3>Practice Question<\/h3>\nhttps:\/\/assess.lumenlearning.com\/practice\/f4854fed-9260-483b-ab3f-e3263e652f02\n\n<\/div>\n<h2>Contribute!<\/h2><div style=\"margin-bottom: 8px;\">Did you have an idea for improving this content? We\u2019d love your input.<\/div><a href=\"https:\/\/docs.google.com\/document\/d\/1n6pK3UBfPIEPJthOt1jannIJQGLv-v8k4GYwTohIUW4\" target=\"_blank\" style=\"font-size: 10pt; font-weight: 600; color: #077fab; text-decoration: none; border: 2px solid #077fab; border-radius: 7px; padding: 5px 25px; text-align: center; cursor: pointer; line-height: 1.5em;\">Improve this page<\/a><a style=\"margin-left: 16px;\" target=\"_blank\" href=\"https:\/\/docs.google.com\/document\/d\/1vy-T6DtTF-BbMfpVEI7VP_R7w2A4anzYZLXR8Pk4Fu4\">Learn More<\/a>\n","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<h2>Contribute!<\/h2>\n<div style=\"margin-bottom: 8px;\">Did you have an idea for improving this content? We\u2019d love your input.<\/div>\n<p><a href=\"https:\/\/docs.google.com\/document\/d\/1n6pK3UBfPIEPJthOt1jannIJQGLv-v8k4GYwTohIUW4\" target=\"_blank\" style=\"font-size: 10pt; font-weight: 600; color: #077fab; text-decoration: none; border: 2px solid #077fab; border-radius: 7px; padding: 5px 25px; text-align: center; cursor: pointer; line-height: 1.5em;\">Improve this page<\/a><a style=\"margin-left: 16px;\" target=\"_blank\" href=\"https:\/\/docs.google.com\/document\/d\/1vy-T6DtTF-BbMfpVEI7VP_R7w2A4anzYZLXR8Pk4Fu4\">Learn More<\/a><\/p>\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-359\">\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":503070,"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-359","chapter","type-chapter","status-publish","hentry"],"part":356,"_links":{"self":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapters\/359","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapters"}],"about":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/types\/chapter"}],"author":[{"embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/users\/503070"}],"version-history":[{"count":0,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapters\/359\/revisions"}],"part":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/parts\/356"}],"metadata":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapters\/359\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/media?parent=359"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapter-type?post=359"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/contributor?post=359"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/license?post=359"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}