Start a new topic
Answered

Find SQL Statements Generated for Match Rules

How can I find the SQL statements generated for each of my match rules? 


Best Answer

The SQL statements are captured in the application log, by default, and are also viewable through the UI of the Semarchy application.  

Through the UI, locate by using this navigation sequence:  

 Management -> Latest Integration Batches -> (Select the appropriate batch) -> Match and Find Duplicates -> (select appropriate matcher) -> Compute System Matches -> (select appropriate match rule) -> Click on Task Definition -> SQL Statement

Image 1. Navigation path for Matching-related SQL statements.


1 Comment

Answer

The SQL statements are captured in the application log, by default, and are also viewable through the UI of the Semarchy application.  

Through the UI, locate by using this navigation sequence:  

 Management -> Latest Integration Batches -> (Select the appropriate batch) -> Match and Find Duplicates -> (select appropriate matcher) -> Compute System Matches -> (select appropriate match rule) -> Click on Task Definition -> SQL Statement

Image 1. Navigation path for Matching-related SQL statements.


Login to post a comment