How to store data into MySQL server from TOS

[Udhay_BM]

Hello Everyone,

I am a BI Intern & new to real time projects, will try my best in explaining the need below

Extract data from Azure through Microsoft SSMS- into Talend for data transformations- store this data into MySQl Server (normal ETL process)

I was sucessfull in first two phases till transformations, but got stuck, by not knowing how to store this data into MySQL Server,

Any help would be really appreciated, thanks in advance

[manodwhb]

@Not defined Not defined​ , you need to take two components tDBInput and tDBOutput and connect them using Main from tDBInput . if it just extract and load.

tDBinput should point Azure Microsoft SSMS and tDBOutput should point to MySQL Server.

Thanks,

Manohar

[Udhay_BM]

Hello Manohar,

Firstly thanks for your response,

Yes I could figure it out by myself & I did the same as mentioned by you

I will be pleased, if you can help me with the following error

"Exception in component tDBinput_1"

For reference, here Iam attaching you the errored screenshot,

Thanks in advance

Udhay