I am using a tCreateTable to create a table in oracle with an SDO_GEOMETRY column.
The resulting java creates SQL that looks like:
create table XYZ (GEOM SDO_GEOMETRY(0,0))
The (0,0) are invalid, the column should just have a type, nothing more.
In the component there is an error: 'the schema's dbType not correct for this component'
This screenshot shows a way to possibly alter the Oracle schema of Talend to fix the issue, but I do not have the 'Metadata of Talend Type' option in my Studio.
Would it be possible to teach Talend how to add a GEOM column?
(I do not have access to JIRA, so I can not file this as a bug myself. Still evaluating on the Community Version, 7.01
About the data type mapping between Talend type and db type, you can go to
project settings-->General-->Metadata of Talend Type.
Please have a look at my screenshot.
Wonderful. I was looking in the preferences window.
Is there an easy way to provide a patch for this, so my edit could be shared with other users?
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.