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 Chirag__1-1725876451413.png](https://community.qlik.com/t5/image/serverpage/image-id/171418i97D033D6A7FA255A/image-size/medium?v=v2&px=400)
Model B: SQL Server:
![Chirag__2-1725876515614.png Chirag__2-1725876515614.png](https://community.qlik.com/t5/image/serverpage/image-id/171419iB522748FD08D46B0/image-size/medium?v=v2&px=400)
Comparing Models:
![Chirag__0-1725876399410.png Chirag__0-1725876399410.png](https://community.qlik.com/t5/image/serverpage/image-id/171417i0B82EFE5CA07D854/image-size/medium?v=v2&px=400)
Output:
![Chirag__3-1725876833039.png Chirag__3-1725876833039.png](https://community.qlik.com/t5/image/serverpage/image-id/171420i1589E55B3E788F37/image-size/medium?v=v2&px=400)
Choosing Highlight Differences From Row1:
![Chirag__4-1725876909837.png Chirag__4-1725876909837.png](https://community.qlik.com/t5/image/serverpage/image-id/171421i28DDA063D40A5CC0/image-size/medium?v=v2&px=400)
Choosing Highlight Differences From Row2:
![Chirag__5-1725876931395.png Chirag__5-1725876931395.png](https://community.qlik.com/t5/image/serverpage/image-id/171422iDD2D96AEB6E282F1/image-size/medium?v=v2&px=400)
Choosing Highlight Differences From Row3:
![Chirag__6-1725876958752.png Chirag__6-1725876958752.png](https://community.qlik.com/t5/image/serverpage/image-id/171423i970255910A5B9A51/image-size/medium?v=v2&px=400)