{"id":242,"date":"2026-10-05T20:49:01","date_gmt":"2026-10-05T18:49:01","guid":{"rendered":"https:\/\/datenquelle.at\/?page_id=242"},"modified":"2026-10-08T04:43:05","modified_gmt":"2026-10-08T02:43:05","slug":"automate-data-workflows","status":"publish","type":"page","link":"https:\/\/en.datenquelle.at\/index.php\/automate-data-workflows\/","title":{"rendered":"Automate data workflows"},"content":{"rendered":"<div class=\"et_pb_section_0 et_pb_section et_section_regular et_flex_section\">\n<div class=\"et_pb_row_0 et_pb_row et_flex_row\">\n<div class=\"et_pb_column_0 et_pb_column et-last-child et_flex_column et_pb_css_mix_blend_mode_passthrough et_flex_column_24_24 et_flex_column_24_24_tablet et_flex_column_24_24_phone\">\n<div class=\"et_pb_code_0 et_pb_code et_pb_module\"><div class=\"et_pb_code_inner\"><section class=\"dq-section dq-subhero\" id=\"dq-main\"><div class=\"dq-wrap\"><nav class=\"dq-breadcrumbs\" aria-label=\"Breadcrumb navigation\"><a href=\"https:\/\/en.datenquelle.at\/\">Home<\/a><span>\/<\/span><a href=\"https:\/\/en.datenquelle.at\/#loesungen\">Solutions<\/a><span>\/<\/span><span>Automate data workflows<\/span><\/nav><div class=\"dq-subhero-grid\"><div><p class=\"dq-eyebrow\"><span class=\"dq-dot\" aria-hidden=\"true\"><\/span>Automate data workflows<\/p><h1>Data arrives.<br><span class=\"dq-accent\">The process keeps running.<\/span><\/h1><p class=\"dq-lead\">We automate imports, exports and processing between applications, databases and file sources, with clear rules for validation, transformation and handover.<\/p><a class=\"dq-button\" href=\"https:\/\/en.datenquelle.at\/index.php\/discuss-your-data-challenge\/\">Discuss your project<\/a><\/div><aside class=\"dq-subhero-side\"><span>THE STARTING POINT<\/span><strong>Application \/ export<br>connects to<br>Destination system.<\/strong><p>Source \u2192 processing \u2192 destination. With clear rules for your data.<\/p><\/aside><\/div><\/div><\/section><\/div><\/div>\n<\/div>\n<\/div>\n<\/div><div class=\"et_pb_section_1 et_pb_section et_section_regular et_flex_section\">\n<div class=\"et_pb_row_1 et_pb_row et_flex_row\">\n<div class=\"et_pb_column_1 et_pb_column et-last-child et_flex_column et_pb_css_mix_blend_mode_passthrough et_flex_column_24_24 et_flex_column_24_24_tablet et_flex_column_24_24_phone\">\n<div class=\"et_pb_code_1 et_pb_code et_pb_module\"><div class=\"et_pb_code_inner\"><section class=\"dq-section dq-jumpnav\"><div class=\"dq-wrap\"><a href=\"#ausgangslage\">Starting point<\/a><a href=\"#loesung\">Solution path<\/a><a href=\"#technik\">Technology<\/a><a href=\"#fragen\">Questions<\/a><\/div><\/section><\/div><\/div>\n<\/div>\n<\/div>\n<\/div><div class=\"et_pb_section_2 et_pb_section et_section_regular et_flex_section\">\n<div class=\"et_pb_row_2 et_pb_row et_flex_row\">\n<div class=\"et_pb_column_2 et_pb_column et-last-child et_flex_column et_pb_css_mix_blend_mode_passthrough et_flex_column_24_24 et_flex_column_24_24_tablet et_flex_column_24_24_phone\">\n<div class=\"et_pb_text_0 et_pb_text et_pb_bg_layout_light et_pb_module et_flex_module\"><div class=\"et_pb_text_inner\"><section class=\"dq-section \" id=\"ausgangslage\">\n<div class=\"dq-wrap\">\n<div class=\"dq-columns\">\n<div>\n<p class=\"dq-eyebrow\"><span class=\"dq-dot\" aria-hidden=\"true\"><\/span>The starting point<\/p>\n<h2>The data exists.<br \/>So does the workaround.<\/h2>\n<p class=\"dq-lead\">Data comes from an application, a supplier source or a regular export. Before the next system can use it, values must be checked, fields mapped and formats adjusted. Doing this manually every time takes time, and small discrepancies can easily go unnoticed. We turn these steps into a repeatable process.<\/p>\n<\/div>\n<div>\n<h3>What we clarify together<\/h3>\n<ul class=\"dq-checklist\">\n<li>Determine sources, destination systems and processing triggers<\/li>\n<li>Map fields, character sets, numbers and dates appropriately<\/li>\n<li>Check required fields, duplicates and implausible values<\/li>\n<li>Deliver approved records using the appropriate method<\/li>\n<li>Present errors and processing results clearly<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/section>\n<\/div><\/div>\n<\/div>\n<\/div>\n<\/div><div class=\"et_pb_section_3 et_pb_section et_section_regular et_flex_section\">\n<div class=\"et_pb_row_3 et_pb_row et_flex_row\">\n<div class=\"et_pb_column_3 et_pb_column et-last-child et_flex_column et_pb_css_mix_blend_mode_passthrough et_flex_column_24_24 et_flex_column_24_24_tablet et_flex_column_24_24_phone\">\n<div class=\"et_pb_text_1 et_pb_text et_pb_bg_layout_light et_pb_module et_flex_module\"><div class=\"et_pb_text_inner\"><section class=\"dq-section \" id=\"loesung\">\n<div class=\"dq-wrap\">\n<p class=\"dq-eyebrow\"><span class=\"dq-dot\" aria-hidden=\"true\"><\/span>One possible scenario<\/p>\n<div class=\"dq-case-grid\">\n<div>\n<h3>One data delivery. One controlled import.<\/h3>\n<p>A supplier source delivers product data daily through SFTP. Datenquelle checks product numbers, standardizes values and passes approved records to the ERP. Unclear entries are held for clarification. The process is independent of whether the agreed source delivers XML, text, CSV or Excel.<\/p>\n<p class=\"dq-example-note\">Illustrative example; no claim of an already delivered customer project.<\/p>\n<\/div>\n<div class=\"dq-case-route\" aria-label=\"Data flow from source to destination\">\n<div class=\"dq-case-node\"><span class=\"dq-node-index\" aria-hidden=\"true\">01<\/span><\/p>\n<div><strong>Application \/ export<\/strong><span>New data delivery<\/span><\/div>\n<\/div>\n<div class=\"dq-case-node\"><span class=\"dq-node-index\" aria-hidden=\"true\">02<\/span><\/p>\n<div><strong>Datenquelle<\/strong><span>Check & transform<\/span><\/div>\n<p><svg class=\"dq-mark\" viewBox=\"0 0 64 64\" aria-hidden=\"true\" focusable=\"false\"><path d=\"M8 8h22c16 0 26 9 26 24S46 56 30 56H8V38h12v7h10c9 0 14-4 14-13s-5-13-14-13H20v7H8Z\" fill=\"currentColor\"\/><path d=\"M2 29h27l6 3-6 3H2Z\" fill=\"currentColor\"\/><\/svg><\/div>\n<div class=\"dq-case-node\"><span class=\"dq-node-index\" aria-hidden=\"true\">03<\/span><\/p>\n<div><strong>Destination system<\/strong><span>Approved data<\/span><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/section>\n<\/div><\/div>\n<\/div>\n<\/div>\n<\/div><div class=\"et_pb_section_4 et_pb_section et_section_regular et_flex_section\">\n<div class=\"et_pb_row_4 et_pb_row et_flex_row\">\n<div class=\"et_pb_column_4 et_pb_column et-last-child et_flex_column et_pb_css_mix_blend_mode_passthrough et_flex_column_24_24 et_flex_column_24_24_tablet et_flex_column_24_24_phone\">\n<div class=\"et_pb_text_2 et_pb_text et_pb_bg_layout_light et_pb_module et_flex_module\"><div class=\"et_pb_text_inner\"><section class=\"dq-section dq-dark\" id=\"technik\">\n<div class=\"dq-wrap\">\n<p class=\"dq-eyebrow\"><span class=\"dq-dot\" aria-hidden=\"true\"><\/span>For technical assessment<\/p>\n<div class=\"dq-section-head\">\n<h2>The technology follows<br \/>the task.<\/h2>\n<p>We evaluate these approaches according to your data and your systems' capabilities.<\/p>\n<\/div>\n<div class=\"dq-tech-grid\">\n<div class=\"dq-tech\">\n<h3>Applications and databases<\/h3>\n<p>Retrieve data through existing APIs or approved SQL\/ODBC access. Keys, data structures and system boundaries determine the process.<\/p>\n<\/div>\n<div class=\"dq-tech\">\n<h3>Files and SFTP<\/h3>\n<p>Process JSON, XML, text and log files, CSV and Excel from an agreed export or transfer method. Format, origin and previously processed deliveries remain unambiguous.<\/p>\n<\/div>\n<div class=\"dq-tech\">\n<h3>Validation and retries<\/h3>\n<p>Apply business rules before handover. Logs make errors visible; agreed retries prevent an interrupted connection from causing uncontrolled duplicate entries.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/section>\n<\/div><\/div>\n<\/div>\n<\/div>\n<\/div><div class=\"et_pb_section_5 et_pb_section et_section_regular et_flex_section\">\n<div class=\"et_pb_row_5 et_pb_row et_flex_row\">\n<div class=\"et_pb_column_5 et_pb_column et-last-child et_flex_column et_pb_css_mix_blend_mode_passthrough et_flex_column_24_24 et_flex_column_24_24_tablet et_flex_column_24_24_phone\">\n<div class=\"et_pb_text_3 et_pb_text et_pb_bg_layout_light et_pb_module et_flex_module\"><div class=\"et_pb_text_inner\"><section class=\"dq-section \" id=\"fragen\">\n<div class=\"dq-wrap\">\n<div class=\"dq-faq-layout\">\n<div class=\"dq-faq-intro\">\n<p class=\"dq-eyebrow\"><span class=\"dq-dot\" aria-hidden=\"true\"><\/span>Before we start<\/p>\n<h2>Good to know.<\/h2>\n<p>Your specific starting point determines the right solution path.<\/p>\n<\/div>\n<div class=\"dq-faq\">\n<details>\n<summary>How can data be imported automatically?<\/summary>\n<p>First, the source, destination and trigger are defined. We then specify mappings, checks and the supported delivery method. An API request, database access or a new file can trigger the process.<\/p>\n<\/details>\n<details>\n<summary>Can Excel and CSV also be processed automatically?<\/summary>\n<p>Yes, if the file structure and destination are agreed. We explicitly address worksheets, delimiters, number formats and keys. CSV and Excel are two possible sources alongside other files, APIs and databases.<\/p>\n<\/details>\n<details>\n<summary>What happens if a data delivery does not match the expected structure?<\/summary>\n<p>Required fields and agreed formats are checked. For relevant discrepancies, the process stops or holds affected records. The correct business behavior is defined before implementation.<\/p>\n<\/details>\n<details>\n<summary>Can machine or process data be included?<\/summary>\n<p>If an approved interface, database or suitable export exists, this data can be included in the process. The vendor, permissions, data rate and operational requirements determine the possibilities.<\/p>\n<\/details>\n<details>\n<summary>How can we tell whether processing succeeded?<\/summary>\n<p>Results and errors are logged transparently. Depending on the project, a status, summary or feedback to the responsible team can be provided. The specific format is agreed.<\/p>\n<\/details>\n<\/div>\n<\/div>\n<\/div>\n<\/section>\n<\/div><\/div>\n<\/div>\n<\/div>\n<\/div><div class=\"et_pb_section_6 et_pb_section et_section_regular et_flex_section\">\n<div class=\"et_pb_row_6 et_pb_row et_flex_row\">\n<div class=\"et_pb_column_6 et_pb_column et-last-child et_flex_column et_pb_css_mix_blend_mode_passthrough et_flex_column_24_24 et_flex_column_24_24_tablet et_flex_column_24_24_phone\">\n<div class=\"et_pb_code_2 et_pb_code et_pb_module\"><div class=\"et_pb_code_inner\"><section class=\"dq-section \"><div class=\"dq-wrap\"><aside class=\"dq-help-teaser\"><div><span class=\"dq-kicker\">Errors & solutions<\/span><h3>A specific problem?<\/h3><p>Useful context before changing the connection.<\/p><\/div><div><a href=\"https:\/\/en.datenquelle.at\/index.php\/csv-import-errors-check-formats-and-values\/\">CSV import errors: check formats and values<\/a><a href=\"https:\/\/en.datenquelle.at\/index.php\/errors-solutions-for-your-data\/\">All data problems at a glance<\/a><\/div><\/aside><p class=\"dq-eyebrow\"><span class=\"dq-dot\" aria-hidden=\"true\"><\/span>The next consideration<\/p><div class=\"dq-section-head\"><h2>Perhaps there's<br>more to connect.<\/h2><\/div><div class=\"dq-relevant\"><a href=\"https:\/\/en.datenquelle.at\/index.php\/connect-systems\/\"><strong>Connect systems<\/strong><span>Connect ERP, CRM, online stores and applications. Enter data once and reuse it where needed.<\/span><\/a><a href=\"https:\/\/en.datenquelle.at\/index.php\/synchronise-data\/\"><strong>Synchronise data<\/strong><span>Keep customers, stock and master data consistent across applications.<\/span><\/a><\/div><\/div><\/section><\/div><\/div>\n<\/div>\n<\/div>\n<\/div><div class=\"et_pb_section_7 et_pb_section et_section_regular et_flex_section\">\n<div class=\"et_pb_row_7 et_pb_row et_flex_row\">\n<div class=\"et_pb_column_7 et_pb_column et-last-child et_flex_column et_pb_css_mix_blend_mode_passthrough et_flex_column_24_24 et_flex_column_24_24_tablet et_flex_column_24_24_phone\">\n<div class=\"et_pb_text_4 et_pb_text et_pb_bg_layout_light et_pb_module et_flex_module\"><div class=\"et_pb_text_inner\"><section class=\"dq-section dq-inquiry-section dq-inquiry-compact\" id=\"anfrage\"><div class=\"dq-wrap\"><div class=\"dq-inquiry-layout\"><div class=\"dq-inquiry-intro\"><p class=\"dq-eyebrow\"><span class=\"dq-dot\" aria-hidden=\"true\"><\/span>A few brief details are enough<\/p><h2>Which manual step keeps repeating?<\/h2><p>A brief look at your workflow is enough to get started. Together, we identify what can be automated.<\/p><div class=\"dq-inquiry-alternative\"><p>Prefer to speak to us directly?<\/p><a class=\"dq-link\" href=\"https:\/\/en.datenquelle.at\/index.php\/discuss-your-data-challenge\/\" data-dq-booking aria-haspopup=\"dialog\" aria-controls=\"dq-booking-modal\">Book an initial consultation<\/a><a href=\"tel:+437229227220\">+43 7229 22722 0<\/a><\/div><\/div><div class=\"dq-inquiry-card\"><p class=\"dq-inquiry-card-title\">Your enquiry to Datenquelle<\/p><p class=\"dq-inquiry-required\">All five fields are required.<\/p>\n<div class=\"wpcf7 no-js\" id=\"wpcf7-f208-o1\" lang=\"en-US\" dir=\"ltr\" data-wpcf7-id=\"208\">\n<div class=\"screen-reader-response\"><p role=\"status\" aria-live=\"polite\" aria-atomic=\"true\"><\/p> <ul><\/ul><\/div>\n<form action=\"\/index.php\/wp-json\/wp\/v2\/pages\/242#wpcf7-f208-o1\" method=\"post\" class=\"wpcf7-form init dq-inquiry-form\" aria-label=\"Project enquiry to Datenquelle\" novalidate=\"novalidate\" data-status=\"init\">\n<fieldset class=\"hidden-fields-container\"><input type=\"hidden\" name=\"_wpcf7\" value=\"208\" \/><input type=\"hidden\" name=\"_wpcf7_version\" value=\"6.2\" \/><input type=\"hidden\" name=\"_wpcf7_locale\" value=\"en_US\" \/><input type=\"hidden\" name=\"_wpcf7_unit_tag\" value=\"wpcf7-f208-o1\" \/><input type=\"hidden\" name=\"_wpcf7_container_post\" value=\"0\" \/><input type=\"hidden\" name=\"_wpcf7_posted_data_hash\" value=\"\" \/>\n<\/fieldset>\n<div class=\"dq-inquiry-fields\">\n\t<div class=\"dq-inquiry-field\">\n\t\t<p><label for=\"dq-inquiry-name\">Your name<\/label><span class=\"wpcf7-form-control-wrap\" data-name=\"your-name\"><input size=\"40\" maxlength=\"120\" class=\"wpcf7-form-control wpcf7-text wpcf7-validates-as-required\" id=\"dq-inquiry-name\" autocomplete=\"name\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"First and last name\" value=\"\" type=\"text\" name=\"your-name\" \/><\/span>\n\t\t<\/p>\n\t<\/div>\n\t<div class=\"dq-inquiry-field\">\n\t\t<p><label for=\"dq-inquiry-company\">Company<\/label><span class=\"wpcf7-form-control-wrap\" data-name=\"your-company\"><input size=\"40\" maxlength=\"160\" class=\"wpcf7-form-control wpcf7-text wpcf7-validates-as-required\" id=\"dq-inquiry-company\" autocomplete=\"organization\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"Your company\" value=\"\" type=\"text\" name=\"your-company\" \/><\/span>\n\t\t<\/p>\n\t<\/div>\n\t<div class=\"dq-inquiry-field\">\n\t\t<p><label for=\"dq-inquiry-email\">Email<\/label><span class=\"wpcf7-form-control-wrap\" data-name=\"your-email\"><input size=\"40\" maxlength=\"254\" class=\"wpcf7-form-control wpcf7-email wpcf7-validates-as-required wpcf7-text wpcf7-validates-as-email\" id=\"dq-inquiry-email\" autocomplete=\"email\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"name@company.com\" value=\"\" type=\"email\" name=\"your-email\" \/><\/span>\n\t\t<\/p>\n\t<\/div>\n\t<div class=\"dq-inquiry-field\">\n\t\t<p><label for=\"dq-inquiry-phone\">Phone<\/label><span class=\"wpcf7-form-control-wrap\" data-name=\"your-phone\"><input size=\"40\" maxlength=\"50\" class=\"wpcf7-form-control wpcf7-tel wpcf7-validates-as-required wpcf7-text wpcf7-validates-as-tel\" id=\"dq-inquiry-phone\" autocomplete=\"tel\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"+43 \u2026\" value=\"\" type=\"tel\" name=\"your-phone\" \/><\/span>\n\t\t<\/p>\n\t<\/div>\n\t<div class=\"dq-inquiry-field dq-inquiry-field-wide\">\n\t\t<p><label for=\"dq-inquiry-message\">What do you currently do manually?<\/label><span class=\"wpcf7-form-control-wrap\" data-name=\"your-message\"><textarea cols=\"40\" rows=\"3\" maxlength=\"4000\" class=\"wpcf7-form-control wpcf7-textarea wpcf7-validates-as-required\" id=\"dq-inquiry-message\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"For example: rearranging and importing a file every morning \u2026\" name=\"your-message\"><\/textarea><\/span>\n\t\t<\/p>\n\t<\/div>\n<\/div>\n<input class=\"wpcf7-form-control wpcf7-hidden\" value=\"daten-automatisieren\" type=\"hidden\" name=\"dq-topic\" \/>\n<div class=\"dq-inquiry-trap\" aria-hidden=\"true\">\n\t<p><label>Please leave this field empty.<span class=\"wpcf7-form-control-wrap\" data-name=\"dq-website\"><input size=\"40\" maxlength=\"400\" class=\"wpcf7-form-control wpcf7-text\" tabindex=\"-1\" autocomplete=\"off\" aria-invalid=\"false\" value=\"\" type=\"text\" name=\"dq-website\" \/><\/span><\/label>\n\t<\/p>\n<\/div>\n<p class=\"dq-inquiry-privacy\">We use your details to handle your enquiry. <a href=\"https:\/\/en.datenquelle.at\/index.php\/privacy-policy\/#kontaktaufnahme\">Privacy information<\/a>. Please do not send passwords or login details.\n<\/p>\n<div class=\"dq-inquiry-submit\">\n\t<p><input class=\"wpcf7-form-control wpcf7-submit has-spinner\" type=\"submit\" value=\"Send enquiry\" \/><span>We will get back to you personally.<\/span>\n\t<\/p>\n<\/div>\n<div class=\"wpcf7-response-output\" aria-hidden=\"true\"><\/div>\n<\/form>\n<\/div>\n<\/div><\/div><\/div><\/section>\n<\/div><\/div>\n<\/div>\n<\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>We automate imports, exports and processing between applications, databases and file sources, with clear rules for validation, transformation and handover.<\/p>\n","protected":false},"author":2,"featured_media":204,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-242","page","type-page","status-publish","has-post-thumbnail","hentry"],"_links":{"self":[{"href":"https:\/\/en.datenquelle.at\/index.php\/wp-json\/wp\/v2\/pages\/242","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/en.datenquelle.at\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/en.datenquelle.at\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/en.datenquelle.at\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/en.datenquelle.at\/index.php\/wp-json\/wp\/v2\/comments?post=242"}],"version-history":[{"count":4,"href":"https:\/\/en.datenquelle.at\/index.php\/wp-json\/wp\/v2\/pages\/242\/revisions"}],"predecessor-version":[{"id":320,"href":"https:\/\/en.datenquelle.at\/index.php\/wp-json\/wp\/v2\/pages\/242\/revisions\/320"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/en.datenquelle.at\/index.php\/wp-json\/wp\/v2\/media\/204"}],"wp:attachment":[{"href":"https:\/\/en.datenquelle.at\/index.php\/wp-json\/wp\/v2\/media?parent=242"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}