Unit of Work - KCOP Commit operations

Source is --> ZOS

Target is --> Linux Kafka using Confluent

Bank of America is the client and they want our kafka message to be like their sample message below that client mocked up for the transactional commit :

{

'Key {"CONT_ID": " 0739126875871236399."}

Value {"TBSCHEMA": "WCC02","TBNAME": "XSEARCH_NAME","CONT_ID": " 0739126875871236399.", "PARTY_ID": "20008047886", "PERSON_ORG_TP": "P", "LAST_ORG_NAME": "ALBUJEMI ", "GIVEN_NAME_ONE": "JANPEN ", "GIVEN_NAME_TWO": "K ", "PREFIX_DESC": "", "SUFFIX_DESC": "", "LOB_REL_TP": "001 ", "ADDRESS_ID": " 0209130747340541199.", "STATE_ABBR": "SC ", "POSTAL_CODE5": "29464", "LAST_UPDATE_DT": "2019-01-26 07:43:59.088420", "SSN_TIN": "255578088", "LAST4_SSN_TIN": "8088", "ID_TP_CD": " 0000000000001000001.", "BIRTH_DT": "1953-01-01", "VISIBILITY_FLAG": "", "END_DT": "", "PROF_SUFFIX": "", "DIVESTITURE_REGION_TP_CD": "", "DATASOURCE_REGION": "EC", "A_ENTTYP": "UP", "A_TIMSTAMP": "2020-02-17 15:16:34.000000000493"}’

'Key {"CONT_ID": " 0739126875871236399}

Value {"TBSCHEMA": "WCC02","TBNAME": "CONTACT", "CONT_ID": " 0739126875871236399.", "ACCE_COMP_TP_CD": "", "PREF_LANG_TP_CD": "", "CREATED_DT": "2020-02-17 15:16:34.000000000493", "INACTIVATED_DT": "", "CONTACT_NAME": "", "PERSON_ORG_CODE": "P", "SOLICIT_IND": "", "CONFIDENTIAL_IND": "", "CLIENT_IMP_TP_CD": "", "CLIENT_ST_TP_CD": "1000001", "CLIENT_POTEN_TP_CD":"", "RPTING_FREQ_TP_CD":"", "LAST_STATEMENT_DT":"", "PROVIDED_BY_CONT":"", "ALERT_IND":"", "LAST_UPDATE_DT":"2020-02-17 15:16:34.000000000493","LAST_UPDATE_USER": "NBID|NBKM1QC", "LAST_UPDATE_TX_ID": "47347337584375484":"", "DO_NOT_DELETE_IND":"", "LAST_USED_DT":"", "LAST_VERIFIED_DT":"2020-02-17 15:16:34.000000000493", "SOURCE_IDENT_TP_CD":"", "SINCE_DT":"", "LEFT_DT":"", "ACCESS_TOKEN_VALUE":"", "PENDING_CDC_IND":"", "PRVD_PARTY_ID":"""A_ENTTYP": "UP", "A_TIMSTAMP": "2020-02-17 15:16:34.000000000493"}'

}

Currently they have QREP running and it is giving out the similar message like above.

Currently CDC Kafka can not provide the below format.
So we need an enhancement request for a UOW KCOP to do this type

Risk : If we do not do this enhancement we may loose a deal worth of a Kafka licence and many service hours.

We have given 4 options to the client as a workaround :

• 1. UOW Kafka KCOP enhancement request• 2. KAFKA TCC• 3. Kafka poor man TCC (almost work like TCC)• 4. QREP to Kafka Topic

Client is looking forward for the option 1 which is an enhancement request. TCC may be complex and not out of the box. They are looking something out of the box where IBM stamps it works.