Guess Schema not working in tOracleInput Component

Highlighted
Four Stars

Guess Schema not working in tOracleInput Component

Hi, 

I am getting error while clicking Guess Schema option in tOracleInput often.

After I write my query inside the Query box of the tOracleInput component, I clicked Guess Schema.

A pop up was displayed saying Connect to DB error, or some errors in SQL query string, or 'Guess Schema' not compatible with current SQL query string.

 

Then I have checked my DB connection (pointed inside the component), it was successful,

and I tried executing my SQL query string in Oracle developer, it was perfectly executed.

Is there any compatibility for Guess Schema option with respect to SQL query string?

 

Thanks in advance.

 

Thanks & Regards,
Sekar
Highlighted
Employee

Re: Guess Schema not working in tOracleInput Component

Hi,

 

    Could you please share your query and component detail screen shot for a quick look? If you are having any functions or column combinations without alias, it might create issue.

 

Warm Regards,

 

Nikhil Thampi

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog