Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

How to convert Oracle.sql.TimestampTZ to a TimeStamp in Nifi 1.11.3

How to convert Oracle.sql.TimestampTZ to a TimeStamp in Nifi 1.11.3

Explorer

Hi,

 

I'm trying to insert into Oracle Database with the Timestamp DD-MON-RR HH.MI.SSXFF AM TZR in this format. The Target is also the same Oracle DB with the same Timestamp format. I'm using QueryDatabaseTableRecord --> ConvertAvroJSON-->ConvertJSOnSql->PutSql. The Attribute value from QueryDatabaseTableRecord is as shown below. Question is how do i Insert the original format into the target database?  Appreciate any inputs/help. 

 

{
"NSP_INQ_ID" : "P2640a7abf",
"ESTBLSHD_DT" : "oracle.sql.TIMESTAMPTZ@6f931c95",
"FEI_ACTUAL_DOWN_BW" : "40.001",
"FEI_ACTUAL_BW_TYPE" : "A",
"FEI_BW_RECVD_DT" : "oracle.sql.TIMESTAMPTZ@6c55abb2",
"FEI_17MHZ_IND" : "N",
"FEI_VCTRG_IND" : "N",
"LAST_UPDTD_DT" : "oracle.sql.TIMESTAMPTZ@c0deb4d",
"OMS_17MHZ_IND" : "N",
"OMS_VCTRG_IND" : "N",
"XDSL_SUBSCRB_TYPE_CD" : "V",
"SVC_PRFLE_NM" : "7330_32M_5M",
"MABR" : null,

Don't have an account?
Coming from Hortonworks? Activate your account here