Data360 Analyze

We need to capture the postal code of the states of Brazil and compare it with the database address to update this address.

Do you have any recommendations?

The Transform node is the most common node used for dynamic or complex comparisons. You could also use the Merge node to compare two sets of input's, which will output matches and also each side's unique values. 

For the update, I'd recommend the JDBC Execute node. The JDBC Execute leverages SQL to make specific inserts or updates. This node is related to the JDBC Query and JDBC Store nodes, which may also be used depending on the specific requirements.