Novuz

Migration

Informatica migration: IDMC and IICS, Data Quality and Data Engineering Integration

Novuz converts Informatica Intelligent Data Management Cloud (IDMC, formerly IICS) mappings, mapplets, taskflows and parameters, Informatica Data Quality rules, and Data Engineering Integration mappings (formerly Big Data Management) into native pipelines on Databricks (on AWS, Azure or Google Cloud), Microsoft Fabric, Snowflake, Google BigQuery, Apache Iceberg or Delta Lake. The converted pipelines need no Informatica or Novuz runtime, and every object ships with a reconciliation report against the original on the same inputs.

Why now

Why are teams moving logic out of Informatica now?

Three reasons come up most. The target platform can now run the transformations itself, so a separate integration layer is a second bill and a second place for business rules to hide.

Informatica is now part of Salesforce, which completed its acquisition of Informatica on 18 November 2025, and teams are reviewing what that means for their own roadmap.

And logic held in mappings and expressions is the hardest part of an estate to read, test and hand to an AI agent. Converted to native code, it can be versioned, reviewed and reconciled like the rest of the warehouse.

Coverage

What does Novuz convert in an Informatica estate?

Every asset type below is converted by rule and reconciled. Final coverage for your estate, including any custom or Java transformations, is confirmed object by object in the assessment.

Informatica assetWhat it becomes
IDMC / IICS Cloud Data Integration mappingsSQL or PySpark pipelines on the target, one per mapping, with the transformation order preserved
Mapplets and reusable transformationsShared functions or modules, called from every pipeline that used them
Source, target, filter, router, joiner, aggregator, expression, sorter, union, normalizer and sequence transformationsSet-based SQL or DataFrame operations
Connected and unconnected lookupsJoins or cached lookups that return the same rows, including first-match and last-match behavior
Update Strategy and slowly changing dimension patternsMERGE statements with the same insert, update and delete rules
Mapping tasks, taskflows and schedulesWorkflows on the target with the same steps, branches and dependencies
Parameter files, in-out parameters and $$ variablesJob parameters and secrets on the target, with the same defaults
Informatica Data Quality rules, rule specifications and mappletsSQL or PySpark data quality checks, with results written to tables you can report on
Data Engineering Integration (Big Data Management) mappings that run on Spark or HivePySpark or Spark SQL on the target
ConnectionsTarget connections and secrets, set up in your environment

Risks

What breaks in an Informatica migration?

These are the places where a converted pipeline gives different rows if nobody plans for them.

  • The expression language. IIF, DECODE, date format strings, implicit type conversion and NULL handling all behave slightly differently from target SQL. Each function is mapped by rule, and reconciliation catches the edge cases.
  • Lookups. Unconnected lookups, lookup caches and lookups that return the first or last match carry logic that a plain join changes.
  • Update strategies and slowly changing dimensions spread across several transformations, so the rule for an update is easy to miss.
  • Parameters and variables. Values set in parameter files, taskflow steps or persisted mapping variables decide what a run does; they are inventoried in the assessment.
  • Pushdown optimization. A mapping that ran as SQL pushed down to the database may already depend on that database’s behavior.
  • Data Quality reference content, such as address validation data, is licensed content rather than logic. It is flagged in the assessment so you can source it on the target.

By target

How does Informatica map to each target?

The patterns are agreed in the assessment before anything is converted.

InformaticaDatabricks (AWS, Azure or Google Cloud)Microsoft FabricSnowflakeGoogle BigQueryApache Iceberg or Delta Lake
Mappings and mappletsPySpark notebooks or Databricks SQLFabric notebooks or Warehouse SQLSnowflake SQL or SnowparkGoogleSQL queries and stored proceduresSpark SQL or PySpark jobs
Taskflows and schedulesDatabricks WorkflowsFabric Data Factory pipelinesSnowflake tasksThe orchestrator agreed in the assessmentThe orchestrator agreed in the assessment
Data Quality rulesSQL checks or pipeline expectationsSQL checks in notebooks or the WarehouseSQL checks or data metric functionsSQL checks with results tablesSQL checks in the pipeline
Data Engineering Integration mappingsPySpark or Spark SQLFabric Spark notebooksSnowparkGoogleSQL, or Spark on Databricks on Google CloudPySpark or Spark SQL

Other tools

What do other tools do with Informatica, and what do they leave?

  • Databricks Genie Migrate converts Informatica PowerCenter exports, in Beta. Its documentation states that IDMC and IICS are not supported.
  • Databricks Lakebridge lists Informatica among the ETL sources of its BladeBridge converter, without saying which Informatica products.
  • Snowflake AIM translates legacy ETL workflows into dbt.
  • Partner platforms such as LeapLogic and Next Pathway list Informatica among their sources and sell their own validation products.
  • What is usually left: taskflows and schedules, parameter handling, Data Quality rules, and proof on your own inputs that each pipeline gives the same rows.

How it runs

How does an Informatica migration with Novuz run?

  1. Export the assets. IDMC exports assets as a ZIP file through asset export or its REST API; Data Quality and Data Engineering Integration objects export from the Developer tool as XML. Novuz reads the exports inside your environment.
  2. The $3,000 assessment counts every object in three business days, bands each one by complexity, lists dead code with the evidence, confirms coverage object by object and fixes the price.
  3. The First Domain takes one domain of up to 1,500 components and 25 TB to reconciled, cutover-ready output in your environment in 5 to 6 weeks, for $25,000 to $40,000, credited against the full estate.
  4. Every converted object runs against the original on the same inputs and gets a result: pass, fail or review, with each miss listed by line.
  5. Each domain’s Informatica jobs are switched off once its pipelines are cut over and reconciled, so the license can shrink domain by domain.

Next question

Where to read next

Moving Informatica pipelines to BigQuery or Databricks on Google Cloud? The Google Cloud page covers both.

FAQ

Frequently asked questions

Can Novuz migrate Informatica IICS or IDMC to Databricks, Snowflake, Fabric or BigQuery?

Yes. Novuz converts IDMC (IICS) Cloud Data Integration mappings, mapplets, taskflows and parameters to native pipelines on Databricks on AWS, Azure or Google Cloud, Microsoft Fabric, Snowflake, Google BigQuery, Apache Iceberg or Delta Lake, with a reconciliation report for every object. Coverage for your estate is confirmed in the assessment.

Does Novuz convert Informatica Data Quality rules?

Yes. Rules, rule specifications and Data Quality mapplets become SQL or PySpark checks on the target, with the results written to tables you can report on. Licensed reference content, such as address validation data, is flagged in the assessment because it is content, not logic.

What happened to Informatica Big Data Management?

Informatica renamed Big Data Management to Data Engineering Integration in version 10.4.0. Novuz converts its mappings, which usually run on Spark or Hive, to PySpark or Spark SQL on the target.

Does Genie Migrate convert IICS or IDMC?

No. Databricks’ documentation for Genie Migrate states that IDMC and IICS are not supported; its Informatica support is for PowerCenter exports, in Beta. Novuz converts IDMC and IICS assets.

Is Informatica PowerCenter covered?

This page covers IDMC (IICS), Informatica Data Quality and Data Engineering Integration. For PowerCenter, coverage is confirmed per estate in the assessment.

Will we still need Informatica after the migration?

Not for the converted pipelines. They run natively on the target with no Informatica or Novuz runtime. Keep Informatica running for each domain until its pipelines are cut over and reconciled.

Does our Informatica metadata leave our network?

No. Novuz runs as a Docker container or VM inside your own environment, next to the target. The code and the data stay where they are, and no outbound connection is required.

  1. 1 Vendor facts on this page come from each vendor’s own documentation, checked 14 November 2026.

How we measure: Methodology

Written by Ted Ghose, Co-founder and CTO, Novuz

Last reviewed:

Find out what your logic debt is costing you.

Every object counted, lineage, dead code and a fixed price in three business days. $3,000, credited.

Take the logic debt scorecard

Not sure which door? The scorecard takes ten minutes and tells you.

Scorecard