HCL SW Blogs
Select Page

Data transformation is a process of converting data from one format to another. Depending on the infrastructure, and data volume the process of transforming your data may require a team of experts and substantial infrastructure costs. Data transformation is not a single process, it includes numerous stages of activities such as convert data types, and data normalization. This cleanses data by removing nulls or duplicate data, performs aggregations, and set transformation rules.

The organization transforms their data for numerous reasons. For example, to make it compatible with other data, to upgrade the system, to move to other systems, or to combine two databases.

While performing the data transformation an organization can face many challenges. However, only Link can address these challenges effectively.

A modernized HCL tool, the HCL Link helps organizations to solve multifaceted data integration problems. Link provides a unified solution for data transformation and integration.

Overcoming challenges with Link:

Simplified Complexity

  • Modelling, development, and testing of transformations and integration solutions via a code-free approach.
  • Any-to-any transformation, Link can truly transform data from any format to any format.
  • Save time on the maintenance of implementations by taking advantage of accessing meta-data or using pre-built standards.
  • Many-to-many integration, Link reads data from multiple sources and writes to many destinations in one pass.
  • Performs data validation and data formatting which improves the data quality and protects applications from potential landmines such as null values, unexpected duplicates, incorrect indexing, and incompatible formats.
  • Link supports EDI, XML, SWIFT, HIPAA, and other standard-based B2B integration, as well as the real-time integration of data from multiple applications, databases, messaging middleware, and communications technologies across the organization.


  • Link provides the ability to Connects applications, databases, processes within the organization
  • Link support different classes of adapters.
  • Eliminates the need for multiple data transformation and integration tools – run on multiple platforms using the same maps
  • Cloud adapters enable easier access to expanding cloud infrastructures
  • It enables complex data transformation and validation across a range of messaging standards and data formats


  • Link uses Advanced Encryption Standard (AES) algorithm to encrypt and decrypt data sources by using a secure encryption key.
  • Link used various algorithms to secure the large set of adapters connections.


  • Link is highly scalable, handle hundreds of transactions per second with sustaining the performance in terms of efficiency.
  • Link is scalable across the range of platforms; the same map can be run on various supported platforms.


  • Link is essential for companies where business requirements are always changing.
  • Link supports existing IT investment such as database and messaging middleware.
  • Link can use the existing IT infrastructure.
  • Link provides data transformation and processing for hierarchical, semi-structured, and mixed data including out of the box support for various well-known industry standards.
  • Pre-built application and industry packs, Link has well known INDUSTRY packs

o   Healthcare (HIPAA, PACDR, HL7, NCPDP)

o   Supply Chain EDI (X12, EDIFACT, Tradacoms)

o   Financial Payments (SWIFT, SEPA, ISO20022, NACHA)

Speed, Flexibility, and Performance

  • Handles hundreds of transactions per second to keep up with the speed of business.
  • Prepare for changing business, compliance, and application environments with the most adaptable data transformation and integration platform.
  • Event-driven, transactional environments to ensure completion and validation of transactions in real-time or batch.

Product Support

  • HCL’s experts will help you in planning your data mapping to executing your transformations, and in verifying the result on Link.
  • HCL has classified trainer to guide you on the Link tool usage and expedite the entire process of data transformation.


Find out more by visiting our website or schedule a demo here.

Comment wrap
Further Reading
web based ETL & Integration tool
Data Management | March 4, 2022
Overview of HCL Link_a web based ETL & Integration tool
HCL Link – A is robust platform that accelerates integration of the many applications and diverse data across organizations on-prem, cloud or hybrid environments.
Experience a Cloud Native integration with HCL Link
Cloud Native | July 20, 2021
Experience a Cloud Native integration with HCL Link
Use cloud data integration, data quality, and data governance. HCL Link helps connect apps to the data needed to run and transform your business.
Integrate with HCL Link in April
Data Management | April 20, 2021
Integrate with HCL Link in April
HCL Link and HCL Domino Volt have a low-code capability, making it easy to develop robust, secure, and enterprise-grade workflow-based applications.
Filters result by