oracle 12c retrieve schema does not work

[Anonymous]

Hello - I have the Oracle 12.1x sid database connector working and a simple "select * from scott.dept" query working.

The "retrieve schema" however does not work. Our goal is to automatically read the DDL for our oracle scott.output table so Talend data integration job can pipe into oracle. (Working on a tight deadline before I fly X country).

Sorry for missing the obvious

Thanks AR

[ankit7359]

Hi @ar ,

Can you post Job screenshots and settings of the DB connector.

Have you checked the connection string and whether it is registering successful test pings.

Thanks,

Ankit

[Anonymous · Accepted solution]

Test connection and sample query "select * from scott.dept" attached. DB Connect string okay. Just fails at the schema DDL gen.

Time is tight on this. Taking a different path with Oracle.

Cheers! AR

Screen Shot 2019-01-31 at 2.08.04 AM.png
Screen Shot 2019-01-31 at 2.06.44 AM.png