JDBC cc select into structure with different fields

[Former Member]

Hello experts,

I have some interfaces that already work with jdbc sender communication channel. My problem is that database is gonna change structure cause of an update in the third party system . I'd like to know if there is a way to select fields in jdbc cc and insert them into existing message types.

For example lets say existing database field and message type field is ID and the new will be identifier  . Is there a way to select identifier into ID of existing message type so i don't have to change all processes ?

Thank you in advance

[bhavesh_kantilal · Accepted solution]

You can change the select query to use the as clause.Eg:  Select identifier as id and so on.

This will make sure your PI ESR Content will continue to remain the same.

Regards

Bhavesh