One Star

ETL from MSSQL to MariaDB (nvarchar datatype)

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.
3 REPLIES
Moderator

Re: ETL from MSSQL to MariaDB (nvarchar datatype)

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: ETL from MSSQL to MariaDB (nvarchar datatype)

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
Moderator

Re: ETL from MSSQL to MariaDB (nvarchar datatype)

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.