Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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