LLM Automation Bots for Data Transformation Map Migration

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Current data transformation tools face challenges in automating the migration, modification, and creation of data transformation maps across different software applications due to the use of proprietary formats and the lack of an efficient automated method, leading to inefficiencies, increased costs, and potential human errors.

Innovation Solution

A computer-implemented method using a processor set to generate a large language model from user manuals and scripts for data transformation tools, creating automation bots to automate operations, including migration, modification, and creation of data transformation maps, and integrating these bots into an orchestration tool for workflow automation.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Reliability

If data transformation maps are migrated manually between different data transformation tools, then compatibility and functionality can be maintained, but the process is time-consuming, error-prone, and costly

Engineering Contradiction:

Improveaccuracy of data transformation map migrationVSAvoidtime required for manual migration

Core Design Contradiction:

ReliabilityVSLoss of time

Solution Approach 1:

The patent replaces manual mechanical processes with an automated bot system. The bot reads documentation, understands data transformation maps, and performs migration automatically between different data transformation tools (e.g., Informatica to Talend), eliminating manual intervention and reducing both time and errors.

Inventive Principle:

Principle #28Mechanics substitution (Replace mechanical system)

Solution Approach 2:

The system enables self-service automation where the bot independently performs the entire migration workflow without human assistance. The bot can autonomously navigate documentation, extract transformation logic, and apply it to new tools, making the process self-sufficient and eliminating dependency on manual labor.

Inventive Principle:

Principle #25Self-service

2Adaptability or versatility

If specialized knowledge is required for each data transformation tool, then tool-specific functionality is maintained, but the learning curve increases and operational complexity rises

Engineering Contradiction:

Improveability to work with multiple data transformation toolsVSAvoidcomplexity of managing multiple tool-specific skills

Core Design Contradiction:

Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The bot is designed with universal capabilities to work across multiple data transformation tools (Informatica, Talend, SSIS, etc.). By reading and understanding documentation from different tools, the bot can perform migrations between any supported tools without requiring specialized human expertise for each tool, consolidating multiple skills into a single automated system.

Inventive Principle:

Principle #6Universality (Multi-functionality)

Solution Approach 2:

The bot acts as an intermediary between different data transformation tools and their documentation. It reads and interprets tool-specific documentation, transforms the knowledge into actionable migration steps, and executes the migration, serving as a universal mediator that eliminates the need for tool-specific expert knowledge.

Inventive Principle:

Principle #24Intermediary (Mediator)

3Productivity

If manual processes are used for creating and modifying data transformation maps, then flexibility and control are maintained, but productivity decreases and human errors increase

Engineering Contradiction:

Improvespeed of data transformation map creation and modificationVSAvoidlevel of automated workflow execution

Core Design Contradiction:

ProductivityVSExtent of automation

Solution Approach 1:

The bot performs preliminary actions by reading and analyzing documentation before actual migration or creation tasks. It pre-processes the information, understands the transformation logic, and prepares the necessary steps in advance, enabling faster and more accurate execution of the actual migration or creation processes.

Inventive Principle:

Principle #10Preliminary action

Solution Approach 2:

The system replaces manual mechanical processes of creating and modifying data transformation maps with automated bot execution. The bot can rapidly create, modify, and migrate maps by following documented procedures, significantly increasing productivity while maintaining consistency and reducing human errors through automated workflow execution.

Inventive Principle:

Principle #28Mechanics substitution (Replace mechanical system)

Data Source

PatentUS12608534B2Managing data transformation tools using generative artificial intelligence

Publication Date: 2026.04.21 INTERNATIONAL BUSINESS MACHINE CORPORATION

AI summary

A computer implemented method manages data transformation tools. A processor set selects a foundation model to retrieve content of respective user manuals for a number of data transformation tools. The processor set generates a large language model from the foundation model based on the content of user manuals for the number of data transformation tools and a number of scripts for automation bots for the number of data transformation tools. The processor set generates a number of new automation bots for each data transformation tool in the number of data transformation tools using the large language model. The processor set performs a number of operations associated with data transformation maps in the number of data transformation tools using the number of new automaton bots.