ETL from MSSQL to MariaDB (nvarchar datatype)

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.
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
Highlighted
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.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download