we need implement Change Data Capture (CDC) from an PostgreSql database. We need a KM Journalization (Simple) for Postgre, but ODI only have for Oracle, informix, hsql, MSSQL and others, but not postgree.
Where can i get the JKM for postgre? it's possible to download from somewhere? anyone can share it with us?
now, we are trying to adapt the HSQL simple to Postgree, but we have a lot of problems with triggers.
can anyone help us?
I believe that at Sunopsis there was a JKM SQL "Generic" but I don't have it anymore...
Any way I believe be very simple adapt the JKM Oracle to do it as the trigger syntax to PostgreSql is very similar and even compatible...
Yes, i think that there is a JKM for standard SQL... but there isn't; there is for IKM, CKM, RKM... but not JKM!
Finally, i did that you said me... i adapted Oracle SQL, it was hard, specially at triggers, but it works.
Now... i have another problem, but there is another thread.
Thanks for your help!