Skip to main content
Announcements
Join us on Sept. 17 to hear how our new GenAI Assistant empowers data professionals: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Chirag_
Partner - Contributor III
Partner - Contributor III

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

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)

Chirag__1-1725876451413.png

Model B: SQL Server:

Chirag__2-1725876515614.png

 

 

Comparing Models: 

 

Chirag__0-1725876399410.png

Output: 

Chirag__3-1725876833039.png

Choosing Highlight Differences From Row1:

Chirag__4-1725876909837.png

 

Choosing Highlight Differences From Row2:

Chirag__5-1725876931395.png

Choosing Highlight Differences From Row3:

 

Chirag__6-1725876958752.png

 

 

Labels (3)
0 Replies