Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, i have some questions for talend before I decide to use.
1. Does talend support postgreSQL, MariaDB, MSSQL?
2.If yes, are they compatible for one another? or is there any problem if I use them together?
3.How can I use character set?
4.And character type: mariaDB and mssql supports different variable type, so, what any issue for this?
thanks
Hello @duddls
Thanks for posting your issue here.
At a first step, please have a look at this online installation guide about:TalendHelpCenter: Supported systems, databases and business applications by Talend components
About the data type mapping between Talend type and db type, you can go to Project Setting->General-->Metadata of TalendType and check talend type mapping files.
Best regards
Sabrina
Is talend open studio for data integration compatible among postgreSQL, MariaDB, Mssql?
I know they support three of them but about compatibility.
and about the character set, if I use postgre, mariadb and mssql,
-Is it okay with using same character set (=utf-8)?
@duddls ,yes TOS will support with postgreSQL, MariaDB and Mssql.
what you find in below link all the DBs will be compatability with Talend Open Studio 7.1.1
https://help.talend.com/reader/L54YpEipK3Qq6c5ZFyJWfg/SXSYi9EtlhhLe6XG9qGdGQ
@duddls ,yes you can use UTF8 as character set.you need to add in the additional parameters while creating corresponding connection in Talend.
"useUnicode=true&characterEncoding=UTF-8"
mssql has language set for character set like korea wscl.
and mariadb character set is utf-8.
So if i use mariadb and mssql both to move data, is it possible?
any issues?
@duddls ,you can move but because of different sets you may see data discrepancy.
what kind of discrepancy will occur?
@duddls ,when you have special characters as part of data with two different character sets will read differently and will populate differently.
