How to replicate DATE and TIMESTAMP from HANA to Oracle?

[former_member720290]

Hi everyone

Hana (source) to Oracle (target) replication, this replication will return updated data in Hana to the same Oracle source tables.
With this replication we are having problems, due to errors that SLT returns to us by data types. We have read some SAP notes
that it is necessary to perform "data type mapping", and we have tried with LTRS, but these only work when SLT does "DROP" on the tables in the "TARGET" and rebuilds them. But this would not work for us because we cannot let SLT drop on the tables (oracle), since these are the source (business) tables of the one first flow.
According to SAP notes and documentation, we also did data mapping, this mapping is being done in IUUC_DB_COL_FLDS table, but replication still doesn't work.

Also try putting a TO_DATE inside the rules (Rule Assignment), but it doesn't work either

The data types with which we find problems are DATE and TIMESTAMP (6), these are the ones found in our Oracle source tables.
We do not have the option of an abap program, since the requirements do not contemplate data transformations.We seek to solve without the need for an additional abap program.

Can you suggest something to me? how to handle DATE data types traveling from Hana to Oracle?

Thanks

Isaias

[former_member720290]

I'm using DMIS 2018_1_752

[jeffrey1 · Accepted solution]

Please check notes

2490743-Smart Data Access - Data Type Mappings when using an Oracle Remote Source

2018485 - After Oracle "DATE" replicates to HANA "TIMESTAMP" the time is incorrect in HANA.