[et_pb_section fb_built=”1″ _builder_version=”4.16″ custom_padding=”0px|0px|0px|0px” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_row _builder_version=”4.16″ custom_padding=”0px|||||” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.27.4″ custom_padding=”||5%||false|false” hover_enabled=”0″ inline_fonts=”Roboto” global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\n
Workday Studio<\/strong> is an Eclipse-based integrated development environment (IDE) specially designed to create and manage complex integrations within the Workday ecosystem. Workday<\/strong><\/a>.<\/p>\n As with any integration, you can launch, schedule and audit integrations created with Studio. You can also run these integrations from within Studio itself, or directly from the Workday application. In this way, Workday Studio<\/strong> enables you to design integration workflows that access information from Workday<\/strong>, manipulate it and, if necessary, pass it on elsewhere.<\/p>\n We’ll take a closer look at the commonly used methods of accessing data in a Workday Studio<\/strong> integration: transferring data by file attachment, via the secure SFTP protocol, and using Custom Reports with REST APIs.<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.27.4″ custom_padding=”||||false|false” inline_fonts=”Roboto” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.27.4″ inline_fonts=”Roboto” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Attachment files are mainly data mapping files hosted in Workday. This means you can update these files directly in Workday, without having to redeploy Studio integrations every time you need to make a change. <\/p>\n Implementation process<\/strong><\/p>\n 1. Deployment<\/strong>: Deploy your Studio integration on your Workday<\/strong> environment.<\/p>\n 2. Configuration<\/strong>: From the menu of associated actions for your Workday integration, choose “Integration System > Configure Integration Services”. Add an attachment service and select the desired attachment. <\/p>\n 3. Data access<\/strong>: To access the attached file from within Workday Studio<\/strong>, use an XSLT+ element.<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.27.4″ background_color=”#f7fbff” custom_margin=”||8%||false|false” custom_padding=”5%|5%|5%|5%|true|true” border_radii=”on|23px|23px|23px|23px” inline_fonts=”Roboto” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Please<\/strong> note: Each attachment service can only handle a single attachment. So if you need to add several attachments to your integration, you’ll need to create several attachment services. <\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.27.0″ inline_fonts=”Roboto” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Secure File Transfer Protocol (SFTP) is a secure way of transferring data files between Workday and other systems. It combines the functionality of FTP with a security layer added via SSH (Secure Shell). Data is encrypted during transfer. <\/p>\n By default, Workday<\/strong> offers a secure SFTP server for file transfers, which can be accessed from Workday Studio<\/strong>.<\/p>\n Implementation process<\/strong><\/p>\n 1. Deployment<\/strong>: Deploy your Studio integration on your Workday environment.<\/p>\n 2. Configuration<\/strong>: From the menu of associated actions for your Workday integration, choose “Integration System > Configure Integration Attributes for Integration System”. Add and configure SFTP Endpoint, SFTP Username and SFTP Password. <\/p>\n 3. Data access<\/strong>: To access the file on the SFTP from Workday Studio, use a sftp-out element.<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.27.4″ background_color=”#f7fbff” custom_margin=”||8%||false|false” custom_padding=”5%|5%|5%|5%|true|true” border_radii=”on|23px|23px|23px|23px” inline_fonts=”Roboto” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Please<\/strong> note: There are 4 ways to transfer data via SFTP on Studio.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/www.sqorus.com\/wp-content\/uploads\/2025\/02\/Anglais-4-methodes-de-transfert.png” title_text=”(Anglais) 4 m\u00e9thodes de transfert” _builder_version=”4.27.4″ _module_preset=”default” custom_padding=”||5%||false|false” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″][\/et_pb_image][et_pb_text _builder_version=”4.27.0″ custom_padding=”||5%||false|false” inline_fonts=”Roboto” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Custom Reports allow you to create tailor-made reports that extract specific data in real time.<\/p>\n Implementation process<\/strong><\/p>\n 1. Report creation<\/strong>: Create a Custom Report on Workday. You can be as specific as you like, using filters, sub-filters or Calculated Fields … <\/p>\n 2. Activation<\/strong>: From the Advanced section of your Custom Report creation, click on Enabled as a Web Service to turn your Custom Report into a Web Service.<\/p>\n 3. Integration<\/strong>: To access the Custom Report from within Workday Studio, use a Workday-out-Rest element.<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.27.4″ background_color=”#f7fbff” custom_margin=”||8%||false|false” custom_padding=”5%|5%|5%|5%|true|true” border_radii=”on|23px|23px|23px|23px” inline_fonts=”Roboto” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Please<\/strong> note: To retrieve a specific object from Custom Report data, you need to specify the path in the Web Service configuration, which you can find in the associated actions menu of your Report in Web Service > View URLs .<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.27.4″ background_color=”#f7fbff” custom_margin=”0px||8%||false|false” custom_padding=”5%|5%|5%|5%|true|true” border_radii=”on|23px|23px|23px|23px” inline_fonts=”Roboto” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n To deepen your knowledge of our Workday expertise<\/strong>, discover our complete support on Workday Financial Management<\/a> and Workday HCM<\/a>, two innovative cloud solutions that our consultants have mastered to guarantee you a successful digital transformation.<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.27.0″ custom_padding=”||||false|false” inline_fonts=”Roboto” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/www.sqorus.com\/wp-content\/uploads\/2025\/02\/Anglais-Comparaison-des-methodes.png” title_text=”(Anglais) Comparaison des m\u00e9thodes” _builder_version=”4.27.4″ _module_preset=”default” custom_padding=”||5%||false|false” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″][\/et_pb_image][et_pb_text _builder_version=”4.27.0″ custom_padding=”||||false|false” inline_fonts=”Roboto” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.27.4″ custom_padding=”||5%||false|false” inline_fonts=”Roboto” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n A developer at Company X is tasked with creating an integration that transfers employee expense reports from an accounting application to Workday. This project requires managing monetary data in multiple currencies, as employees are spread across different countries and pay their expenses in various currencies. It has 3 sources of data to retrieve for its development: <\/p>\n The developer chooses to retrieve incoming data from a file transfer via SFTP<\/strong>. This method is chosen to transfer large CSV files securely. <\/p>\n To keep up to date with exchange rate conversions, he chooses to attach the currency conversion file, as rates are occasionally updated directly by the finance department.<\/p>\n Finally, to obtain real-time data on internal and external employees, the developer creates a Custom Report activated as a REST<\/strong> service.<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.27.0″ custom_padding=”||||false|false” inline_fonts=”Roboto” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.27.4″ custom_padding=”||5%||false|false” inline_fonts=”Roboto” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n The choice of data access method in Workday Studio<\/strong> depends on several factors: data volume, update frequency, real-time requirements and security constraints. A successful integration strategy often combines several methods to optimize every aspect of the data flow. <\/p>\n With over 30 years’ experience<\/strong> in digital transformation and recognized expertise in Workday<\/strong>, SQORUS can help you. Whether you’re thinking about, implementing or optimizing Workday<\/strong>, we’re with you every step of the way. For personalized feedback, contact us directly. <\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row custom_padding_last_edited=”on|desktop” _builder_version=”4.27.0″ background_color=”#2029a0″ background_image=”https:\/\/www.sqorus.com\/wp-content\/uploads\/2023\/12\/Bandeau-LB-Gouvernance-IT.png” background_size=”contain” background_position=”center_right” width=”100%” width_tablet=”90%” width_phone=”90%” width_last_edited=”on|phone” custom_margin=”||10%||false|true” custom_padding=”50px|400px|50px|55px|true|false” custom_padding_tablet=”50px|55px|50px|55px|true|true” custom_padding_phone=”40px|55px|40px|55px|true|true” background_last_edited=”on|phone” background_enable_image_tablet=”off” border_radii=”on|23px|23px|23px|23px” global_module=”25053″ global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text module_class=”Titre_40 Titre_blanc” _builder_version=”4.25.1″ _module_preset=”default” header_2_font_size=”30px” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n [\/et_pb_text][et_pb_text module_class=”FondBleu” _builder_version=”4.24.3″ _module_preset=”default” text_font=”||||||||” text_text_color=”#d6d8f4″ text_line_height=”30px” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Discover the roles and responsibilities of key profiles, as well as best practices in governance and technological development, to ensure the success of your digital transformation projects.<\/p>\n [\/et_pb_text][et_pb_button button_url=”https:\/\/www.sqorus.com\/en\/ebook-all-about-it-project-governance\/” button_text=”Download” button_alignment=”left” button_alignment_tablet=”center” button_alignment_phone=”center” button_alignment_last_edited=”on|tablet” admin_label=”Bouton de t\u00e9l\u00e9chargement” module_class=”Bouton Fond_blanc” _builder_version=”4.27.0″ _module_preset=”default” custom_button=”on” button_text_size=”15px” button_text_color=”#f36145″ button_bg_color=”#FFFFFF” button_border_width=”1px” button_border_color=”#f36145″ button_border_radius=”50px” button_font=”||||||||” button_use_icon=”off” custom_margin=”20px||||false|false” custom_padding=”13px|25px|13px|25px|false|false” custom_css_free_form=”selector:hover{|| background-color: #FFF6F5 !important;||}” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_button][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=”1″ admin_label=”Section – Blog – Cta Actu” module_class=”Fond_bleu Fond_icone” _builder_version=”4.27.0″ custom_margin=”5rem||5rem||true|true” custom_margin_tablet=”4rem|40px|4rem|40px|true|true” custom_margin_phone=”|20px||20px|false|true” custom_margin_last_edited=”on|phone” custom_padding=”3rem||3rem||true|false” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_row make_equal=”on” admin_label=”Text block” module_class=”LargeurBox” _builder_version=”4.27.0″ _module_preset=”default” animation_style=”fade” locked=”off” collapsed=”off” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.25.0″ _module_preset=”default” custom_padding=”|9rem||9rem|false|true” custom_padding_tablet=”|0rem||0rem|false|true” custom_padding_phone=”|0rem||0rem|false|true” custom_padding_last_edited=”on|desktop” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text admin_label=”Sous-titre” module_class=”SousTitre” _builder_version=”4.25.0″ _module_preset=”default” text_font=”||||||||” text_orientation=”center” custom_margin=”||10px||false|false” text_orientation_tablet=”” text_orientation_phone=”center” text_orientation_last_edited=”on|tablet” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Contact<\/p>\n [\/et_pb_text][et_pb_text admin_label=”Titre – H2″ module_class=”Titre_40″ _builder_version=”4.26.1″ _module_preset=”default” text_orientation=”center” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n [\/et_pb_text][et_pb_text admin_label=”Texte” _builder_version=”4.27.0″ _module_preset=”default” text_text_color=”#d2d4ec” text_orientation=”center” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Contact us today and find out how we can work together to make your company’s digital future a reality.<\/p>\n [\/et_pb_text][et_pb_button button_url=”https:\/\/www.sqorus.com\/en\/contact\/” button_text=”Contact SQORUS” button_alignment=”center” module_class=”Bouton fond_orange” _builder_version=”4.27.0″ _module_preset=”default” custom_margin=”30px||||false|false” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_button][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" Discover the 3 key ways to access data in Workday Studio: file attachments, secure SFTP and Custom Reports via REST API.<\/p>\n","protected":false},"author":93,"featured_media":45487,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","content-type":"","_ayudawp_aiss_exclude":false,"footnotes":""},"categories":[403],"tags":[],"metiers":[225],"sujet":[220],"class_list":["post-45480","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-workday-en","metiers-it-en","sujet-solution-en"],"acf":[],"yoast_head":"\nThe 3 main ways to access data with Workday Studio<\/b><\/h2>\n
1. Workday Studio integration method: file attachments<\/h3>\n
2. Workday Studio integration method :<\/b> data transfer via SFTP <\/b> <\/h3>\n
3. Workday Studio integration method: <\/b>custom report and REST API<\/b>.<\/h3>\n
Comparison of methods <\/b><\/h2>\n
Case study <\/b>data access with Workday Studio integration<\/b><\/h2>\n
Background and problems encountered <\/strong><\/h3>\n
\n
Proposed solution<\/strong><\/h3>\n
<\/ul>\n
Conclusion on Workday Studio integration<\/b><\/h2>\n
All about IT project governance<\/h2>\n
A project? A request?A question?<\/h2>\n