Migrate PowerCenter

PowerCenter left standard support in March 2026. Here is the way out, mapping by mapping.

Informatica PowerCenter 10.5 left standard support on March 31, 2026 [1]; Informatica itself became part of Salesforce on November 18, 2025 [2]. Estates that run hundreds of PowerCenter mappings have to decide where they go. Lima converts them in batches of ten to twenty: each mapping becomes a pipeline with the same sources and targets, each workflow a schedule, each reject file an exception record with an owner, and every cut-over is proved by a reconciliation of the old and new results.

Jul 2025Dec 2027Nov 18, 2025Informatica becomes part of SalesforceMar 31, 2026PowerCenter 10.5 standard support endedDec 31, 2027SAP ECC maintenance ends (SAP estates)TODAY · SEP 2026
The dates that matter for a PowerCenter estate. Extended and sustaining support dates are quoted by third parties and are confirmed with Informatica's lifecycle guide before they appear here.
Mar 31, 2026
PowerCenter 10.5 standard support ended
dated source [1]
Nov 18, 2025
Informatica became part of Salesforce
dated source [2]
10–20
mappings converted in the first fixed-price batch
offer
1 report
reconciliation per cut-over: rows, totals, samples
product
0
meters on the Lima subscription
product
What changes, and when

Support ended; the software still runs.

PowerCenter keeps working after a support date. What changes is that patches, security fixes and help stop unless you pay for extended support, and the people who know the mappings move on. The risk grows one quarter at a time, which is why the conversion runs in batches you can schedule.

2025
Ownership changesSalesforce completes the Informatica acquisition on November 18, 2025 [2].
Mar 2026
Standard support endsPowerCenter 10.5.x leaves standard support on March 31, 2026 [1]. Informatica's own path forward is its cloud platform, metered in IPUs.
Now
InventoryA one-week inventory counts your mappings by pattern and tells you the effort band per batch.
Then
BatchesTen to twenty mappings per batch, each cut-over reconciled, the PowerCenter server retired when the last batch moves.
What moves where

Each thing you have today, and what it becomes.

The conversion is a mapping, and the mapping is short. What has no equivalent is listed too.

TodayIn LimaWhat to know
MappingPipeline on the canvasSources, transformations and targets carry over one for one; the canvas shows the same flow.
Workflow and sessionSchedule and runA workflow becomes a scheduled pipeline (or a DAG of several); a session becomes a run with its own report.
Source and target definitionsConnections in the registryCredentials go into the vault once and are referenced, never copied.
Expression, Filter, Router, Aggregator, Joiner, LookupOperators of the same nameLookups become cached lookup queries; routers become conditional branches.
Update StrategyUpsert loadInsert, update, delete or reject per row become the upsert load mode plus exception records.
Sequence Generator, Normalizer, RankOperatorsSurrogate keys, unpivoting and ranking have direct operators.
Mapplet and reusable transformationShared pipeline fragmentReused once, changed once.
Parameter filePipeline parameters and connection registryEnvironment-specific values live with the connection or the schedule.
PowerExchange change captureLima change captureDatabase log capture for PostgreSQL, MySQL, SQL Server and Oracle; application-layer capture for SAP.
SAP PowerConnect / ABAP-generated extractionReleased-interface extractionLima reads SAP through table reads via a released function module, BAPIs, CDS views and delta queues, with nothing installed in SAP; ABAP programs generated by PowerCenter are retired.
Reject file (bad rows)Exception records with ownersBad rows are kept, routed to the person who owns them with a deadline, and replayed once fixed.
RepositoryVersioned pipeline definitionsPipelines are versioned with a person and a date per change.
How the conversion runs

Five steps, each with an acceptance record.

Inventory (week 1, free)We read your PowerCenter repository export and count the mappings by pattern: simple copies, lookups and joins, incremental logic, scripts, change capture, write-back. Each gets an effort band and a flag for anything Lima does differently.
Convert the first ten to twenty (weeks 2–4, fixed price)Each mapping becomes a Lima pipeline with the same sources and targets. Scripts become Python operators. Reject handling becomes exception records with owners.
Run both, compare the resultsThe old and the new run side by side for an agreed number of cycles. Rows, control totals and sample values are compared per table, and the differences are explained or fixed.
Cut over, one mapping at a timeWhen a mapping reconciles for the agreed cycles, its schedule moves to Lima and the old one is disabled. The reconciliation report is the acceptance record.
RetireWhen the last mapping has moved, the old server or subscription is switched off. The inventory shows what is left at every step.
The assessment

One week to know what you have.

The assessment reads your repository export (the XML you can produce from the Repository Manager) and needs no access to production data.

What it readsWhat it reports
Mappings, mapplets, workflows, sessionsCounts by pattern: copies, lookups and joins, aggregations, update strategies, scripts and stored-procedure calls, change capture.
Sources and targetsSystems involved, with the connector Lima uses for each and any prerequisite your administrators need to grant.
SAP-specific componentsABAP-generated programs and PowerConnect usage, and the released-interface method that replaces each.
Effort bandsPer batch of ten to twenty mappings: simple, standard or complex, with the reason.
What has no equivalentAnything Lima does differently, named, with the recommended handling.
The offer

Free to look, fixed price to move.

What stays

What you keep.

Your databases, warehouse and files stay where they are; the pipelines change, the data does not move for the sake of the migration.

Your scheduler stays if you want it to: Control-M or another enterprise scheduler triggers Lima jobs and receives their status.

PowerCenter keeps running the mappings that have not yet moved. The inventory shows what is left after every batch, and the two run side by side until the last cut-over.

Terms on this page

Plain meanings.

Mapping (PowerCenter)A definition of how data moves from sources through transformations to targets; Lima's equivalent is a pipeline.
Session and workflowA run of a mapping, and the schedule and sequence of runs; Lima's equivalents are a run and a schedule or DAG.
Reject filePowerCenter's file of rows that failed; in Lima, exception records with owners.
ReconciliationComparing rows, control totals and sample values between the old and new results before a cut-over.
IPUInformatica Processing Unit, the metering unit of Informatica's cloud platform.
Questions

Asked before a migration.

Do we have to move everything at once?

No. Batches of ten to twenty mappings, each cut over when it reconciles. PowerCenter runs the rest until then.

What about the ABAP programs PowerCenter generated for SAP?

They are retired. Lima reads SAP through released interfaces with nothing installed in SAP; the inventory lists each program and the method that replaces it.

Can our systems integrator do the conversion?

Yes. The offer is software with a fixed scope; the delivery can be Lima's team or yours.

Start with the inventory.

One week, no charge. You get the count by pattern, the exposure flags and the effort bands, whatever you decide next.