topic Re: Data integration in Talend Studio

Data integration

Anonymous — Sat, 27 Jan 2018 06:44:52 GMT

Dear folks
Am using ms SQL server database for input and my output is MySQL database.
My input table has a column named is testdate with DATETIME datatype. My output data will be sorted according to date. While am doing this an error occur with incompatible operand types date and string. How can I resolve this ?

Re: Data integration

TRF — Sat, 27 Jan 2018 13:14:01 GMT

Hi,
"...an error..." but which one?
How can we help you if we don't know that?
My instinct says probably a problem due to date format. To be confirmed.

Re: Data integration

Anonymous — Sun, 28 Jan 2018 10:51:41 GMT

In tmap Expression Builder ..Select TalendDate from Categories after that select function parseDate("yyyy-MM-dd HH:mm:ss","")
And type current date or which date data u want to move in your output in parseDate("yyyy-MM-dd HH:mm:ss","2018-01-27 00:00:00")

Re: Data integration

Anonymous — Sun, 28 Jan 2018 10:59:37 GMT

TalendDate.parseDate("yyyy-MM-dd HH :mm:ss ","2018-01-27 00:00:00")

It will written in Expression Builder and if u want to move only male category data than click on activate/unactivate expression filter and type your condition like row1.gender==male

Re: Data integration

Anonymous — Tue, 30 Jan 2018 03:30:04 GMT

Hello,

Could you please post your job setting screenshots on forum which will be helpful for us to address your issue?

Best regards

Sabrina

Re: Data integration

Anonymous — Thu, 01 Feb 2018 06:56:35 GMT

My job is running successfully But my MS SQL Server particular date data is not correctly show in my output database MYSQL. i mean my database is related to medical. everyday people tests record save in my database ReadMail. suppose 31 january 100 people done their test when am move ReadEmail to output database newread than their will be more than 100 tests.

Re: Data integration

manodwhb — Fri, 02 Feb 2018 10:56:22 GMT

You need to change the data format of tmap out put schema to required. like (yyyy-MM-dd HH :mm:ss)

Re: Data integration

TRF — Fri, 02 Feb 2018 19:40:09 GMT

Hi,
When you run your from the Studio, the number of rows coming from each component is displayed on top of the line which represents the flow.
If you have just 100 rows but more than 100 on target database (this is your problem, isn't it?) you probably have remaining rows in target database when the job starts. If you are sure there is no rows in the database and just 100 or less arriving to the tMySQLOutput component, you have to verify you have not a database trigger which generates new rows automagically.
Let us know.

Re: Data integration

Anonymous — Sat, 03 Feb 2018 03:59:56 GMT

Hello sir

if you know whats my issue than provide me solution. what i will do ?