FAQ
Questions, answered plainly.
What a Labs 53 engagement involves, what our tooling does and does not do, how your data is handled, and how a migration is proven. If something you need is missing, ask us directly.
Labs 53 and how we work
What does Labs 53 do?
Labs 53 moves legacy data estates onto modern platforms — assessment, conversion, orchestration redesign and reconciliation — with the deepest specialism in Oracle and Oracle Data Integrator.
The work runs on Nexus53, our own migration framework: Trace53 for estate intelligence, Shift53 for conversion, Proof53 for validation and Operate53 for transition. It is an engineering practice rather than an advisory one: the deliverable is running code on your target platform, plus the evidence that it produces the same results as the estate it replaced.
Is Labs 53 only for Oracle Data Integrator?
No. ODI is where our tooling goes deepest, but the approach applies to legacy ETL, warehouse and BI estates generally — Oracle Warehouse Builder, Informatica PowerCenter, Oracle databases, OBIEE and their surrounding ecosystem.
The method does not change: recover the real pipelines, dependencies, transformation logic and operational behaviour from the source estate, then rebuild them for the target architecture. The objective is never to translate one tool into another.
Which target platforms do you work with?
Databricks, Snowflake and Google BigQuery are where we work most often. The implementation inside them varies by client — dbt, Databricks Lakeflow, Snowflake-native services, Airflow or another platform-native orchestrator.
That choice is an output of the assessment rather than an assumption made at the start, because the shape of the source estate has a great deal to say about which target patterns will be cheap and which will be expensive.
Are you tied to a particular cloud or data-platform vendor?
No, and deliberately so. The source estate is analysed into a common migration model before any target-specific pattern is applied, so the same assessment can support more than one target.
That independence is commercial as well as technical. We are not a reseller, we take no vendor margin, and you can compare target architectures on evidence from your own estate before committing the programme to one of them.
How do you work with platform-native migration tooling?
We use it wherever it is the right tool. Databricks, Snowflake and Google all ship increasingly capable technology for translating SQL and moving data, and there is no reason to rebuild any of it.
Labs 53 works at the layer above individual statements: what a transformation belongs to, how it is orchestrated, what depends on it, and how its behaviour is proven after the move. The platform vendors provide the destination — we specialise in understanding, converting and proving the legacy estate that has to get there.
How big is Labs 53, and who does the work?
Labs 53 is a specialist practice, not a body shop. Assessment and the tooling itself are led by the founder; delivery is staffed either from a small, long-standing network of associate specialists or through our commercial delivery partner, IDS Consulting, depending on the engagement.
Every engineer who touches an estate is a senior practitioner, most with fifteen or more years in data delivery behind them. What makes it a lab rather than a consultancy is that the method exists as working, tested tooling built in house — not as a slide deck. More about how the work is staffed, and our relationship with IDS Consulting below.
What is Labs 53's relationship with IDS Consulting?
IDS Consulting (ids-consulting.ro) is Labs 53's commercial delivery partner. Founded in 2012 and based in Bucharest, IDS operates a network of 150+ specialists across data governance, platform engineering, BI, cloud and AI, and holds ISO 9001, ISO 27001 and ISO 20000-1 certification alongside partner status with Databricks, Snowflake, AWS, Google Cloud and Microsoft.
Labs 53 remains the author of Nexus53 and the tooling behind it; IDS brings delivery scale and existing client relationships across banking, telecom, IT and retail. An engagement may be staffed and contracted through either party depending on the client relationship.
Can Labs 53 work alongside our systems integrator or internal data team?
Yes, and that is the common shape. You or your integrator own the target architecture and the wider programme; Labs 53 supplies the specialist layer — repository assessment, conversion patterns, migration automation and reconciliation evidence.
We do not compete with an existing delivery partner for the programme they already own — whether that partner is yours, or ours, IDS Consulting, brought in when an engagement needs delivery scale. What we hand back either way is working patterns in your own repository, not a dependency on us.
Starting an engagement
What do you need from us to start?
An export of the ODI repository. Trace53 reads repository exports — it does not need a connection to your work repository, database credentials, or any access to the data itself.
For most clients that turns the first step into an internal file transfer rather than a security review, which is frequently the difference between starting this month and starting next quarter.
Can we start with an assessment before committing to a full migration?
Yes, and most clients should. Trace53 is designed as a bounded, standalone engagement with a deliverable of its own: what actually exists, what is still used, dependencies and lineage, complexity tiers, the migration pattern proposed for each group of objects, the major risks, and a modelled effort and schedule picture.
It stands on its own as input to a go/no-go decision, a business case or a procurement exercise — whether or not the migration that follows is ours.
How do you estimate the effort required for a migration?
From the repository, not from object counts. Two ODI mappings of identical size can differ by an order of magnitude in migration effort, so counting objects measures the wrong thing.
The assessment weighs transformation complexity, Oracle-specific SQL, custom procedures, knowledge-module usage, source and target technologies, dependencies, orchestration and parameterisation, then groups the estate into pattern families. The result is a migration inventory with complexity tiers and an effort range.
We label that range the way the report itself does: modelled from estate structure, to be confirmed on a pilot. Before a pilot runs, any effort figure is a model rather than a measurement, and a supplier presenting one as a measurement is guessing with more confidence than the evidence supports.
How much of the migration can actually be automated?
Migration effort is not evenly distributed, which makes any single automation percentage close to meaningless without its denominator.
Effort concentrates in the first instance of a pattern. Once a pattern family is designed and proven, every later member of that family is comparatively cheap. Where an estate has a genuinely repetitive majority, converting that majority is where automation earns its keep — in modelling we work to around 80% of the conversion effort for the repeating portion, not 80% of a migration programme.
Whole-programme figures are materially lower, because assessment, bespoke residue, target design, testing and cutover do not automate. Finding out how repetitive your estate actually is, is one of the main questions the assessment answers.
Can Labs 53 handle very large estates?
Yes, and large estates are where the approach pays off most. Because the analysis runs on repository metadata rather than manual inspection, cost scales with the number of distinct patterns far more than with the number of objects.
A three-thousand-object estate built from forty patterns is a smaller problem than a five-hundred-object estate built from three hundred. Which of those you have is not obvious from the outside, and it is precisely what the assessment establishes.
Data, security and AI
Does our data leave our environment?
No, for two independent reasons.
First, the analysis runs on metadata, not business data — repository exports that describe pipelines, rather than the rows those pipelines move.
Second, it runs inside your own tenancy, under your own security model. The analysis tooling is written against the Python standard library alone, with no third-party dependencies, because nothing gets installed from a public package index inside a regulated enterprise without a review that nobody wants to run.
Proof53 goes further still: it never connects to a database at all. It writes reconciliation SQL that your DBAs can read in full, your team runs it on your own platform with your own credentials, and the tool compares the results you hand back.
Do you use AI, and where exactly?
Yes — narrowly, and disclosed. We do not describe what we do as AI-powered migration, because the parts you would want to be deterministic are deterministic.
The repeating majority of an estate is converted by deterministic generation from repository metadata: the same input produces the same output every time, which is what makes it reviewable, diffable and testable. AI assistance is applied only to the bespoke residue that fits no pattern.
Where it is used, it runs inside your own tenancy and operates on metadata rather than business data. The residue is named in a review file for an engineer to deal with, rather than quietly generated and hoped over.
What do we own at the end?
Ordinary code in your own repository. Shift53 emits a pattern per family, a configuration per object, and a REVIEW.md naming the bespoke residue and the bindings your team needs to supply.
There is no Labs 53 runtime in your production path and no agent to install. If the relationship ended the day after cutover, your platform would keep running and your engineers could keep changing it — which is the only definition of no lock-in that means anything.
Migrating an ODI estate
Do you automatically convert ODI mappings?
Partly, and deliberately not entirely. A repository contains mappings that translate cleanly, Oracle-specific SQL that needs conversion, procedures carrying real business logic, packages and load plans expressing orchestration, knowledge modules implementing reusable technical patterns, and pipelines that should not be migrated at all.
Those require different treatment, so the estate is classified by construct before anything is converted. Where a pattern is understood and repeats, generation is deterministic. Where it does not repeat, it is named as residue for an engineer rather than guessed at. The objective is a maintainable target platform, not a cloud-hosted copy of the legacy architecture.
What will Shift53 refuse to generate?
Four things, on purpose. It will not generate against a fingerprint it has not seen designed. It will not generate a family member that is wired differently from its siblings. It will not invent a connection detail. And it will not rewrite your business SELECT.
Each refusal produces a named item for review instead of plausible-looking output. In a migration, code that looks correct and is subtly wrong costs far more than code that was never generated — so what the tool declines to produce matters at least as much as what it emits.
Can you migrate custom Knowledge Modules?
Yes, but they need analysis rather than object-for-object conversion. A custom KM usually encodes technical standards and operational behaviour that are invisible from the mappings which use it.
We establish what behaviour it implements and where it is used, then decide whether that behaviour should become a reusable target-platform pattern, a framework component, or part of the generated transformation logic. This is one of the places where a SQL-only converter has nothing at all to say — the ODI migration page sets out how each non-SQL construct is handled.
What happens to ODI packages and load plans?
They are treated as orchestration semantics, not as objects to be translated. Dependencies, sequencing, conditional execution, variables, restart behaviour and scheduling requirements are recovered first, then expressed in the target platform’s own orchestration — Databricks Workflows, Snowflake Tasks, Airflow or another native service.
Restart behaviour is the detail most often lost in a migration, and the one your operations team notices first.
Do you migrate everything in the repository?
No, and identifying what should not survive is one of the more valuable outputs of an assessment. Mature estates accumulate orphaned objects, unused scenarios, duplicated transformations, abandoned interfaces, dead procedures and superseded packages.
Retiring them reduces migration effort and leaves a simpler estate behind. Nothing is dropped on the tool’s say-so: candidates are evidenced, and the decision is always yours.
Will the new platform look exactly like ODI?
Usually not, and that is intentional. A great deal of what an ODI estate does is shaped by the constraints and conventions of the tool rather than by the business it serves.
We hold to functional equivalence — the same business results and the same operational guarantees — rather than implementation equivalence, and redesign the implementation around what the target platform genuinely does well. A faithful replica of the legacy architecture inherits all of its costs without keeping any of its familiarity.
Proving the migration worked
How do you prove the migrated pipelines produce the same results?
By treating validation as an engineering discipline with a deliverable of its own, rather than as testing bolted onto the end.
Legacy and migrated implementations are run in parallel and compared through declared checks — row counts and aggregates, schema, key uniqueness, reject-flow behaviour, and idempotency under re-run — producing repeatable sign-off evidence instead of an opinion.
Two rules matter more than the list of checks. The tool never invents a tolerance: every accepted difference carries a named owner, a reason and an expiry date. And a comparison in which both sides are empty is recorded as invalid, never as a pass — an all-empty run proves nothing, and reconciliation tooling that reports it as green is worse than no tooling at all.
Does validation require running both platforms indefinitely?
No. Baseline outputs from the legacy implementation are captured and retained while it is still running, and the migrated implementation is compared against those baselines afterwards.
That keeps reconciliation practical when infrastructure cost, licensing or capacity makes a long-lived duplicate production environment impossible — which, in our experience, is most of the time.
Ready to start the conversation?
Send us your repository stats or describe the estate you need to move.