topic Re: ETL from MSSQL to MariaDB (nvarchar datatype) in Talend Studio

ETL from MSSQL to MariaDB (nvarchar datatype)

Anonymous — Mon, 22 Aug 2016 04:34:59 GMT

Hi all.... im just getting started with Talend Open Studio and i've come across the following issue with ETL from MSSQL to MariaDB.
Columns with datatype nvarchar is been transferred as varchar.

Re: ETL from MSSQL to MariaDB (nvarchar datatype)

Anonymous — Mon, 22 Aug 2016 08:43:03 GMT

Hi,
Is there any exception in your job during the ETL processing? Can you post the error message printed on console into forum?
Best regards
Sabrina

Re: ETL from MSSQL to MariaDB (nvarchar datatype)

Anonymous — Mon, 22 Aug 2016 10:56:52 GMT

There are no errors since i have not yet populated the table with data... but the data type varchar on the target instead of nvarchar
Regards
Chris

Re: ETL from MSSQL to MariaDB (nvarchar datatype)

Anonymous — Tue, 23 Aug 2016 10:09:28 GMT

Hi,
There is no "nvarchar" data type in tmysqloutput component.
In Talend; the Mapping between DataType from the Database and TalendType can be customize to fit and match with your need.
In your Studio, you can open the Preferences (go to the Menu, choose Window and then Preferences ); dig into Talend > Specific settings > Metadata of Talend.
Best regards
Sabrina