topic Re: removing double quotes from columns while integrating oracle source object into postgresql using tOracleOutput in Talend Studio

removing double quotes from columns while integrating oracle source object into postgresql using tOracleOutput

Anonymous — Sat, 16 Nov 2024 06:25:03 GMT

am currently using talend studio community version(7.1) to create replica objects on a postgresql database from an oracle source database using tOracleOutput,the objects that are created on the postgresql database are having columns with double quotes.

How do i remove this double quotes before the objects are created on the postgresql.Please am new to talend and I have tried several stuffs i have found on the internet and none seems to be working or probably i dont know how to use them correctly.

Re: removing double quotes from columns while integrating oracle source object into postgresql using tOracleOutput

Anonymous — Wed, 06 Mar 2019 09:18:18 GMT

Hi,

Could you please share the overall job flow and problematic component's basic, advanced and schema screenshots for reference?

Could you please advise how you are trying to create the table in PostgreSQL?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: removing double quotes from columns while integrating oracle source object into postgresql using tOracleOutput

Anonymous — Wed, 06 Mar 2019 09:49:59 GMT

firstly,it is tPostgresqlOutput that am using and not tOracleOutput.

The tables are created on the postgresql db but the columns are having double quotes and case sensitive which is not what i want,if i create a table on the postgresql db without using talend,the double quotes are not there.

i have attached the work flow here,both the input as well as the tPostgresqlOutput.

please any advice will be really appreciated.

Talend issues.docx

Re: removing double quotes from columns while integrating oracle source object into postgresql using tOracleOutput

Anonymous — Wed, 06 Mar 2019 10:01:44 GMT

Hi,

There is a similar issue in Talend community and its in resolved status.

Could you please verify whether it helped you and update back?

https://community.talend.com/t5/Design-and-Development/resolved-Remove-double-quotes-while-creating-table-in-PostgreSQL/td-p/103130

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: removing double quotes from columns while integrating oracle source object into postgresql using tOracleOutput

Anonymous — Wed, 06 Mar 2019 10:16:08 GMT

thanks for your prompt response,I do not have control over the source data,so this will not work for me

Re: removing double quotes from columns while integrating oracle source object into postgresql using tOracleOutput

Anonymous — Wed, 06 Mar 2019 10:17:36 GMT

is there any component within the tPostgressql components that i can twik so as to remove the double quotes while creating the tables?

Re: removing double quotes from columns while integrating oracle source object into postgresql using tOracleOutput

Anonymous — Wed, 06 Mar 2019 10:18:49 GMT

is there any component within the tPostgressqlOutput components that i can twik so as to remove the double quotes while creating the tables?

Re: removing double quotes from columns while integrating oracle source object into postgresql using tOracleOutput

Anonymous — Wed, 06 Mar 2019 10:19:13 GMT

Hi,

It is telling to change the column names to lower case and not source data.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: removing double quotes from columns while integrating oracle source object into postgresql using tOracleOutput

Anonymous — Wed, 06 Mar 2019 10:31:30 GMT

You mean changing the column names on the source DB to lower case?

i do not have the access to do that.

I have tried creating the table on the postgressql db with lower case and used the talend studio to insert into it instead of creating the table using talend but it gave me the error below while inserting into it

ERROR: column "BRA_CODE" of relation "tmp_account_test" does not exist
Position: 39 Call getNextException to see other errors in the batch.
caused by: ERROR: column "BRA_CODE" of relation "tmp_account_test" does not exist
Position: 39

Re: removing double quotes from columns while integrating oracle source object into postgresql using tOracleOutput

Anonymous — Wed, 06 Mar 2019 10:34:44 GMT

Hi,

Since you are using Create table option in tDBOutput, you should be having access to change the column names to lower case. The only change you need to do is to make sure that all the columns in your schema of tDBOutput are in lower case.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: removing double quotes from columns while integrating oracle source object into postgresql using tOracleOutput

Anonymous — Wed, 06 Mar 2019 11:30:03 GMT

Thanks alot.

it worked and everything is fine now.