topic Re: oracle 12c retrieve schema does not work in Talend Studio

oracle 12c retrieve schema does not work

Anonymous — Thu, 31 Jan 2019 06:39:18 GMT

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

Re: oracle 12c retrieve schema does not work

ankit7359 — Thu, 31 Jan 2019 08:08:17 GMT

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

Re: oracle 12c retrieve schema does not work

Anonymous — Thu, 31 Jan 2019 10:11:14 GMT

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