[et_pb_section fb_built=”1″ fullwidth=”on” _builder_version=”3.22″ background_color=”#2ea3f2″ use_background_color_gradient=”on” background_color_gradient_start=”#2ea3f2″ background_color_gradient_end=”#2e6df4″ background_color_gradient_direction=”330deg” global_colors_info=”{}”][et_pb_fullwidth_header title=”TOOLS” _builder_version=”4.12.1″ title_font=”||||||||” background_color=”rgba(255, 255, 255, 0)” global_colors_info=”{}” button_one_text_size__hover_enabled=”off” button_two_text_size__hover_enabled=”off” button_one_text_color__hover_enabled=”off” button_two_text_color__hover_enabled=”off” button_one_border_width__hover_enabled=”off” button_two_border_width__hover_enabled=”off” button_one_border_color__hover_enabled=”off” button_two_border_color__hover_enabled=”off” button_one_border_radius__hover_enabled=”off” button_two_border_radius__hover_enabled=”off” button_one_letter_spacing__hover_enabled=”off” button_two_letter_spacing__hover_enabled=”off” button_one_bg_color__hover_enabled=”off” button_two_bg_color__hover_enabled=”off”]<\/p>\n
new Data<\/strong><\/span> wizard<\/p>\n [\/et_pb_fullwidth_header][\/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”3.22″ global_colors_info=”{}”][et_pb_row _builder_version=”3.25″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” custom_padding=”|3px||||” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”4.12.1″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.12.1″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_2,1_2″ _builder_version=”3.25″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}”][et_pb_column type=”1_2″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”4.12.1″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}”]<\/p>\n The most used M Office application, which is, for data migration purposes, a very used tool, especially for data validation<\/strong>. MS Excel can, with some effort, be used to create the data file itself. But in this case, it belongs in the hands of an expert and really only in an emergency situation on a project.<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.12.1″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}”]<\/p>\n Here we come to a universal database system<\/strong> that allows advanced work with data. MS Access is included in some editions of MS Office and its use requires users with knowledge of relational databases, data table design, queries, etc. It is an excellent tool and can be used to build an entire data migration.<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.12.1″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}”]<\/p>\n Talend is a representative of the family of ETL tools (Extract, Transform, Load). This tool is technically used for field-to-field mapping and value to value mapping<\/strong>. Talend is very flexible, allowing you to load almost any data format, join multiple source tables into one target table, perform value to value mapping to values in SAP R\/3 and save data in the structure of individual infotypes for final transformation into a data format.<\/p>\n The migration data file could be generated from the Talend application directly. But my workflow is set up for a two-step processing of the source data in the Talend -> NDWS tandem for several practical reasons.<\/p>\n [\/et_pb_text][\/et_pb_column][et_pb_column type=”1_2″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”4.12.1″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}”]<\/p>\n If I want to look at the “raw” data itself<\/strong>, I use this tool. An ordinary notepad from MS Windows can also be used, but PSPad offers a number of features that a classic windows notepad does not provide when viewing the contents of a data file and other activities.<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.13.0″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” hover_enabled=”0″ global_colors_info=”{}” sticky_enabled=”0″]<\/p>\n DWS is the ultimate tool for the final transformation of the data “raw” after output from the Talend application (or other data source) into the target format<\/strong>. And not only that. It provides a number of control functions designed to validate data before importing it into SAP R\/3. DWS is built on MS Access and was developed based on my 16 years of experience with data migrations in G2 format (ADP proprietary format) to SAP R\/3.<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.12.1″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}”]<\/p>\n Nowadays an absolutely essential tool<\/strong> for universal use when working with data.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/www.newdatawizard.com\/wp-content\/uploads\/2021\/10\/startup-icon-3.png” title_text=”startup-icon-3″ align=”center” _builder_version=”4.12.1″ _module_preset=”default” custom_padding=”51px||21px|||” global_colors_info=”{}”][\/et_pb_image][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" new Data wizardFor my work I use several tools that allow me to reliably transform data into the target format.In addition, I use standard “general-purpose” tools that many users are familiar with from their daily practice.MS EXCEL The most used M Office application, which is, for data migration purposes, a very used tool, especially for […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"class_list":["post-816","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.newdatawizard.com\/index.php\/wp-json\/wp\/v2\/pages\/816","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.newdatawizard.com\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.newdatawizard.com\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.newdatawizard.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.newdatawizard.com\/index.php\/wp-json\/wp\/v2\/comments?post=816"}],"version-history":[{"count":18,"href":"https:\/\/www.newdatawizard.com\/index.php\/wp-json\/wp\/v2\/pages\/816\/revisions"}],"predecessor-version":[{"id":1115,"href":"https:\/\/www.newdatawizard.com\/index.php\/wp-json\/wp\/v2\/pages\/816\/revisions\/1115"}],"wp:attachment":[{"href":"https:\/\/www.newdatawizard.com\/index.php\/wp-json\/wp\/v2\/media?parent=816"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}For my work I use several tools that allow me to reliably transform data into the target format.<\/strong><\/h3>\n
In addition, I use standard “general-purpose” tools that many users are familiar with from their daily practice.<\/h4>\n
MS EXCEL<\/h3>\n
MS ACCESS<\/h3>\n
TALEND (TOS)<\/h3>\n
PSPAD<\/h3>\n
DW STUDIO (DWS)<\/h3>\n
PYTHON<\/h3>\n