Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

DBMS COMPATIBILITY

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

Labels (2)
10 Replies
Anonymous
Not applicable
Author

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

Anonymous
Not applicable
Author

Is talend open studio for data integration compatible among postgreSQL, MariaDB, Mssql?

I know they support three of them but about compatibility.

 

Anonymous
Not applicable
Author

and about the character set, if I use postgre, mariadb and mssql,

-Is it okay with using same character set (=utf-8)?

 

manodwhb
Champion II
Champion II

@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

manodwhb
Champion II
Champion II

@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"

Anonymous
Not applicable
Author

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?

 

manodwhb
Champion II
Champion II

@duddls ,you can move but because of different sets you may see data discrepancy.

Anonymous
Not applicable
Author

what kind of discrepancy will occur?

manodwhb
Champion II
Champion II

@duddls ,when you have special characters as part of data with two different character sets will read differently and will populate differently.