topic Re: MySql To MS SQL - Cannot insert null values into column in Talend Studio

MySql To MS SQL - Cannot insert null values into column

Anonymous — Sat, 16 Nov 2024 06:00:27 GMT

Hello All,

I am newbie to talend and trying to explore talend in different ways.

First thing that i have tried is transforming data from MySql to MS SQL server.

I was able to create connection and the connection was successful for both MySql and MS Sql Servers.

The flow is looks like as below image.

MySql Connection:-

MS SQL server Connection:-

Both Connections are successful .

i did used tMap to map columns between these to.

MySql connection DB Input configurations:

And the schema of table looks like this.

tMap Configuration and mapping:-

MS Sql Server Output Configuration:-

Schema of MS SQL Server Table:-

But when i try to run this job,

it giving me error as null values cant be inserted into the table as below image.

Can anyone please guide me where i am going wrong.

Thanks in advance.

Mohan V.

Re: MySql To MS SQL - Cannot insert null values into column

manodwhb — Thu, 25 Apr 2019 08:09:20 GMT

@Moe ,can you check that in mysql side is that empid having null values? if yes you need to restrict in tmap ,by activating filter like row1.empid != null .

you can verify that empid is coming as null from my sql to write to file or tlogrow.

Re: MySql To MS SQL - Cannot insert null values into column

Anonymous — Thu, 25 Apr 2019 08:28:58 GMT

@manodwhb thanks for the quick reply.

I am not sure where i have to write this filter expression in tmap.

so i jus tried this as above image.

but it giving the error as "Exception in thread "main" java.lang.Error: Unresolved compilation problem: "

Can you please guide me where exactly i have to write this expression and how

Re: MySql To MS SQL - Cannot insert null values into column

manodwhb — Thu, 25 Apr 2019 10:13:02 GMT

@Moe ,what is the data type of empid?

Re: MySql To MS SQL - Cannot insert null values into column

Anonymous — Thu, 25 Apr 2019 10:13:53 GMT

its varchar(8)

Re: MySql To MS SQL - Cannot insert null values into column

manodwhb — Thu, 25 Apr 2019 10:33:14 GMT

@Moe , I am attaching the sample code,pleas find.

Tests.zip