Database DataWarehousing (MOSC)

MOSC Banner

Which Journalizing knowledge module can i use for PostgreSQL to Oracle in Oracle Data Intergrator

Hi,

I am using Data Integrator Version 12.2.1 to do my mappings. My source tables are from postgreSQL database and my target tables are in Oracle(Toad for Oracle). I want to implement CDC on my mapping. Initially i had imported and used JKM Oracle simple on my PostgreSQL source model. I added one datastore to CDC and when i started the journal it throws an error at the last step of Register subscribers;

ODI-1590: The execution of the script failed. 

Caused By: org.apache.bsf.BSFException: exception from Jython:

Traceback (most recent call last):

 File "<string>", line 37, in <module>

 Position: 27

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center