HELP: What is the Correct Method to Compare Heterogeneous Databases in Talend Data Catalog?

Chirag_ — Mon, 09 Sep 2024 10:18:09 GMT

Hi Team,

I want to Compare Two Tables from Two different Databases.

What i did:

I created two model ( Model A: MYSQL ) , (Model B: SQL Server)

I have Created same table ( Department) in both the Databases respectively but i have Add Column 'SAL' extra in Model A.
Now i have followed the Steps to compare Model A to Model B as provided in the CATALOG Documentation:Comparing two different objects

But here i get not useful information

Can you provide a correct way to compare two hetrogenous Databases in Talend Data Catalog.
PFA Snips for better understanding.

Model A:(MYSQL)

Model B: SQL Server:

Comparing Models:

Output:

Choosing Highlight Differences From Row1:

Choosing Highlight Differences From Row2:

Choosing Highlight Differences From Row3:

topic HELP: What is the Correct Method to Compare Heterogeneous Databases in Talend Data Catalog? in Talend Data Catalog

HELP: What is the Correct Method to Compare Heterogeneous Databases in Talend Data Catalog?