<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:dc="http://purl.org/dc/elements/1.1/">
  <channel>
    <title>DEV Community: Cedric Signori</title>
    <description>The latest articles on DEV Community by Cedric Signori (@rationalxplorer).</description>
    <link>https://dev.to/rationalxplorer</link>
    <image>
      <url>https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F3827979%2F3efc22d8-6b73-406d-905c-68153be20762.png</url>
      <title>DEV Community: Cedric Signori</title>
      <link>https://dev.to/rationalxplorer</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/rationalxplorer"/>
    <language>en</language>
    <item>
      <title>Why Your SAP Migration Mapping Layer Shouldn't Live in Spreadsheets</title>
      <dc:creator>Cedric Signori</dc:creator>
      <pubDate>Tue, 17 Mar 2026 15:07:23 +0000</pubDate>
      <link>https://dev.to/rationalxplorer/why-your-sap-migration-mapping-layer-shouldnt-live-in-spreadsheets-3g7</link>
      <guid>https://dev.to/rationalxplorer/why-your-sap-migration-mapping-layer-shouldnt-live-in-spreadsheets-3g7</guid>
      <description>&lt;p&gt;If you've ever worked on a SAP migration, you already know the feeling.&lt;/p&gt;

&lt;p&gt;Week one, someone opens a fresh Excel file. Columns: source table, target table, transformation logic, owner, status. Clean. Organized. Promising.&lt;/p&gt;

&lt;p&gt;Fast forward three months: that file has 47 tabs, six versions with names like &lt;strong&gt;final_v3_REAL_USE_THIS.xlsx&lt;/strong&gt;, three people who "own" different parts of it, and at least one tab that nobody touches because the person who built it left the project.&lt;/p&gt;

&lt;p&gt;This is how mapping logic dies — not in a dramatic failure, but in slow fragmentation.&lt;/p&gt;




&lt;h2&gt;
  
  
  The SAP ECC 2027 problem
&lt;/h2&gt;

&lt;p&gt;A lot of teams are about to feel this pain very acutely.&lt;/p&gt;

&lt;p&gt;SAP is decommissioning ECC in 2027. That means a massive wave of migrations is either already underway or being planned right now — to S/4HANA, Snowflake, Databricks, or a mix of all three. These are not small lifts. SAP schemas are complex, deeply customized, and full of implicit business logic that's never been written down anywhere.&lt;/p&gt;

&lt;p&gt;The mapping work alone — figuring out what maps to what, how it transforms, and why — can take months. And the dirty secret is that most of that work still happens in spreadsheets and Confluence pages, or lives inside the heads of a few senior consultants.&lt;/p&gt;

&lt;p&gt;When the project ends (or the consultant rolls off), that knowledge is just... gone.&lt;/p&gt;




&lt;h2&gt;
  
  
  The tool gap nobody talks about
&lt;/h2&gt;

&lt;p&gt;There's no shortage of ETL tools. Databricks, Informatica, Talend, SSIS — take your pick. These tools are excellent at moving data. That's exactly what they're built for.&lt;/p&gt;

&lt;p&gt;But they don't really answer the question: &lt;em&gt;why did this field end up here, and what happened to it along the way?&lt;/em&gt;&lt;/p&gt;

&lt;p&gt;That's a different problem. It's a documentation problem, a governance problem, a traceability problem. And it's one that most teams are solving with the least appropriate tool possible: a spreadsheet.&lt;/p&gt;




&lt;h2&gt;
  
  
  What we built, and why
&lt;/h2&gt;

&lt;p&gt;We were running into this repeatedly on migration projects, so we built a tool called &lt;strong&gt;ARCXA&lt;/strong&gt; to deal with it.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;ARCXA doesn't move data. It explains data movement.&lt;/strong&gt;&lt;/p&gt;

&lt;p&gt;It sits on top of your existing ETL stack and gives you:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Schema mapping&lt;/strong&gt; — source-to-target field mappings, stored in a queryable knowledge graph&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Data lineage&lt;/strong&gt; — field-level tracking of where data came from and how it was transformed&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Transformation traceability&lt;/strong&gt; — a record of what happened to each field and why, that compounds across every project you run&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;The knowledge graph is built on SPARQL/RDF via Oxigraph. The backend is Rust, the frontend is React. Connectors for SAP HANA, Oracle, DB2, PostgreSQL, Snowflake, Databricks, S3 Parquet, and MySQL out of the box.&lt;/p&gt;

&lt;p&gt;Deploy via Docker Compose or Helm. No SaaS, no cloud dependency, works air-gapped.&lt;/p&gt;




&lt;h2&gt;
  
  
  What this actually changes
&lt;/h2&gt;

&lt;p&gt;The biggest shift is organizational memory.&lt;/p&gt;

&lt;p&gt;When your mapping logic lives in ARCXA instead of a spreadsheet, it doesn't disappear when the project ends. New team members can query it. Auditors can trace it. You can reuse it on the next migration instead of starting from scratch.&lt;/p&gt;

&lt;p&gt;Instead of hunting through tabs to understand why a transformation was written a certain way, you have a graph you can query. "Show me everything that feeds into this target field" becomes a real question with a real answer.&lt;/p&gt;

&lt;p&gt;And because it's open-source (BSL 1.1), you can run it in dev and test for free, inspect the code, and adapt it to your stack.&lt;/p&gt;




&lt;h2&gt;
  
  
  Is this for you?
&lt;/h2&gt;

&lt;p&gt;If you're working on a SAP ECC migration — or any large-scale legacy migration involving Oracle, DB2, or similar — and you're currently managing mapping logic in spreadsheets or docs, this is probably worth looking at.&lt;/p&gt;

&lt;p&gt;It's not a replacement for your ETL tooling. It's the layer that explains what your ETL is doing.&lt;/p&gt;




&lt;h2&gt;
  
  
  Try it
&lt;/h2&gt;

&lt;p&gt;GitHub repo: &lt;strong&gt;&lt;a href="https://github.com/equitusai/arcxa" rel="noopener noreferrer"&gt;https://github.com/equitusai/arcxa&lt;/a&gt;&lt;/strong&gt;&lt;/p&gt;

&lt;p&gt;More details on the project and use cases on the &lt;a href="https://www.equitus.ai/data-migration" rel="noopener noreferrer"&gt;ARCXA landing page&lt;/a&gt;.&lt;/p&gt;

&lt;p&gt;Would love to hear how others are handling this — especially if you're deep in a SAP migration right now. Are you using any tooling for lineage and traceability, or is it still spreadsheets all the way down?&lt;/p&gt;

</description>
      <category>datamigration</category>
      <category>sap</category>
      <category>dataengineering</category>
      <category>opensource</category>
    </item>
  </channel>
</rss>
