

{"id":11066,"date":"2025-09-05T15:56:37","date_gmt":"2025-09-05T07:56:37","guid":{"rendered":"https:\/\/www.dkmeco.com\/en\/?p=11066"},"modified":"2025-09-10T14:55:29","modified_gmt":"2025-09-10T06:55:29","slug":"theobald-xtract-universal-application-example-extracting-bw-cube-from-sap-s4-hana-to-amazon-s3","status":"publish","type":"post","link":"https:\/\/www.dkmeco.com\/en\/theobald-xtract-universal-application-example-extracting-bw-cube-from-sap-s4-hana-to-amazon-s3\/","title":{"rendered":"Theobald Xtract Universal Case Series #02: Extracting BW Cube from SAP S\/4HANA to Amazon S3"},"content":{"rendered":"<p>For SAP users, <a href=\"https:\/\/www.dkmeco.com\/en\/theobaldsoftware\/\">Theobald Xtract Universal<\/a> is a very handy data integration tool. If you are trying it out, we can provide you with some simple guidance. At the same time, Amazon S3 is a public storage service that can handle all complex service requests, store and retrieve data, and is very cost-effective!<\/p>\n<p>We tried extracting SAP data into Amazon S3, and the whole process was very convenient. Here, we will share the specific steps to help users quickly access SAP data!<\/p>\n<h3>Step 1. Create Data Source<\/h3>\n<p>First, click Server &#8211; Manage Sources \u2013 Add to create a data source.<\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/dkm-website.oss-cn-shenzhen.aliyuncs.com\/upload\/0\/watermarkImage\/dkm_watermark_1692328887828.png\" width=\"754\" height=\"410\" \/><\/p>\n<p>Enter the SAP S4\/HANA access information.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/dkm-website.oss-cn-shenzhen.aliyuncs.com\/upload\/0\/watermarkImage\/dkm_watermark_1692328888817.png\" width=\"712\" height=\"384\" \/><\/p>\n<p>Finally, once the connection test succeeds, just save it.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/dkm-website.oss-cn-shenzhen.aliyuncs.com\/upload\/0\/watermarkImage\/dkm_watermark_1692328888200.png\" width=\"742\" height=\"400\" \/><\/p>\n<h3>Step 2. Create Destination<\/h3>\n<p>At this step, you need to have the Amazon S3 access account Access Key ID and Secret Key prepared in advance.<\/p>\n<p>First, click Server \u2013 Manage Destinations \u2013 Add to create a destination.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/dkm-website.oss-cn-shenzhen.aliyuncs.com\/upload\/0\/watermarkImage\/dkm_watermark_1692328889435.png\" width=\"746\" height=\"402\" \/><\/p>\n<p>Fill in the Name, select S3 AWS from the Type dropdown menu, and enter the access information. For Connection, choose Use user credentials.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/dkm-website.oss-cn-shenzhen.aliyuncs.com\/upload\/0\/watermarkImage\/dkm_watermark_1692328890733.png\" width=\"712\" height=\"387\" \/><\/p>\n<p>Once the test connection succeeds, save it.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/dkm-website.oss-cn-shenzhen.aliyuncs.com\/upload\/0\/watermarkImage\/dkm_watermark_1692328891189.png\" width=\"706\" height=\"382\" \/><\/p>\n<h3>Step 3. Data Extraction<\/h3>\n<p>After completing the first two steps, you can create a data extraction.<\/p>\n<p>First, click New, select the created data source in Source, enter an extraction Name, and choose Table.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/dkm-website.oss-cn-shenzhen.aliyuncs.com\/upload\/0\/watermarkImage\/dkm_watermark_1692328888037.png\" width=\"700\" height=\"378\" \/><\/p>\n<p>Select the data you need to extract, use the Load live preview function to preview the data, and once confirmed, click OK to save.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/dkm-website.oss-cn-shenzhen.aliyuncs.com\/upload\/0\/watermarkImage\/dkm_watermark_1692328889860.png\" width=\"703\" height=\"378\" \/><\/p>\n<p>Right-click the newly created extraction in the list, choose Destination Settings, and change it to Amazon S3.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/dkm-website.oss-cn-shenzhen.aliyuncs.com\/upload\/0\/watermarkImage\/dkm_watermark_1692328888414.png\" width=\"738\" height=\"401\" \/><\/p>\n<p>Run the data extraction and check the results.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/dkm-website.oss-cn-shenzhen.aliyuncs.com\/upload\/0\/watermarkImage\/dkm_watermark_1692328891823.png\" width=\"722\" height=\"393\" \/><\/p>\n<p>In this way, Theobald Xtract Universal extracts SAP data into Amazon S3. We hope these steps help you easily access SAP system data!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>For SAP users, Theobald Xtract Universal is a very handy data integration tool. If you are trying it out, we<\/p>\n","protected":false},"author":92,"featured_media":11073,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":"","_wp_rev_ctl_limit":""},"categories":[28],"tags":[252],"class_list":["post-11066","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-theoblad","tag-theobald-xtract-universal"],"acf":[],"aioseo_notices":[],"rttpg_featured_image_url":{"full":["https:\/\/www.dkmeco.com\/en\/wp-content\/uploads\/2025\/09\/Case2.png",1814,1217,false],"landscape":["https:\/\/www.dkmeco.com\/en\/wp-content\/uploads\/2025\/09\/Case2.png",1814,1217,false],"portraits":["https:\/\/www.dkmeco.com\/en\/wp-content\/uploads\/2025\/09\/Case2.png",1814,1217,false],"thumbnail":["https:\/\/www.dkmeco.com\/en\/wp-content\/uploads\/2025\/09\/Case2-150x150.png",150,150,true],"medium":["https:\/\/www.dkmeco.com\/en\/wp-content\/uploads\/2025\/09\/Case2-300x201.png",300,201,true],"large":["https:\/\/www.dkmeco.com\/en\/wp-content\/uploads\/2025\/09\/Case2-1024x687.png",1024,687,true],"1536x1536":["https:\/\/www.dkmeco.com\/en\/wp-content\/uploads\/2025\/09\/Case2-1536x1030.png",1536,1030,true],"2048x2048":["https:\/\/www.dkmeco.com\/en\/wp-content\/uploads\/2025\/09\/Case2.png",1814,1217,false],"woodmart_shop_catalog_x2":["https:\/\/www.dkmeco.com\/en\/wp-content\/uploads\/2025\/09\/Case2-600x600.png",600,600,true],"woocommerce_thumbnail":["https:\/\/www.dkmeco.com\/en\/wp-content\/uploads\/2025\/09\/Case2-300x300.png",300,300,true],"woocommerce_single":["https:\/\/www.dkmeco.com\/en\/wp-content\/uploads\/2025\/09\/Case2-600x403.png",600,403,true],"woocommerce_gallery_thumbnail":["https:\/\/www.dkmeco.com\/en\/wp-content\/uploads\/2025\/09\/Case2-150x101.png",150,101,true],"rt_custom":["https:\/\/www.dkmeco.com\/en\/wp-content\/uploads\/2025\/09\/Case2.png",1814,1217,false]},"rttpg_author":{"display_name":"dkm-admin","author_link":"https:\/\/www.dkmeco.com\/en\/author\/dkm-admin\/"},"rttpg_comment":0,"rttpg_category":"<a href=\"https:\/\/www.dkmeco.com\/en\/category\/theoblad\/\" rel=\"category tag\">Theoblad<\/a>","rttpg_excerpt":"For SAP users, Theobald Xtract Universal is a very handy data integration tool. If you are trying it out, we","_links":{"self":[{"href":"https:\/\/www.dkmeco.com\/en\/wp-json\/wp\/v2\/posts\/11066","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dkmeco.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dkmeco.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dkmeco.com\/en\/wp-json\/wp\/v2\/users\/92"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dkmeco.com\/en\/wp-json\/wp\/v2\/comments?post=11066"}],"version-history":[{"count":3,"href":"https:\/\/www.dkmeco.com\/en\/wp-json\/wp\/v2\/posts\/11066\/revisions"}],"predecessor-version":[{"id":11077,"href":"https:\/\/www.dkmeco.com\/en\/wp-json\/wp\/v2\/posts\/11066\/revisions\/11077"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dkmeco.com\/en\/wp-json\/wp\/v2\/media\/11073"}],"wp:attachment":[{"href":"https:\/\/www.dkmeco.com\/en\/wp-json\/wp\/v2\/media?parent=11066"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dkmeco.com\/en\/wp-json\/wp\/v2\/categories?post=11066"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dkmeco.com\/en\/wp-json\/wp\/v2\/tags?post=11066"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}