topic Re: DBMS COMPATIBILITY in Talend Studio

DBMS COMPATIBILITY

Anonymous — Thu, 14 Mar 2019 00:47:58 GMT

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

Re: DBMS COMPATIBILITY

Anonymous — Thu, 14 Mar 2019 01:33:24 GMT

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

Re: DBMS COMPATIBILITY

Anonymous — Thu, 14 Mar 2019 23:51:41 GMT

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

I know they support three of them but about compatibility.

Re: DBMS COMPATIBILITY

Anonymous — Fri, 15 Mar 2019 01:06:39 GMT

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

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

Re: DBMS COMPATIBILITY

manodwhb — Fri, 15 Mar 2019 06:05:53 GMT

@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

Re: DBMS COMPATIBILITY

manodwhb — Fri, 15 Mar 2019 06:08:19 GMT

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

Re: DBMS COMPATIBILITY

Anonymous — Fri, 15 Mar 2019 07:41:56 GMT

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?

Re: DBMS COMPATIBILITY

manodwhb — Fri, 15 Mar 2019 07:43:53 GMT

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

Re: DBMS COMPATIBILITY

Anonymous — Fri, 15 Mar 2019 07:45:05 GMT

what kind of discrepancy will occur?

Re: DBMS COMPATIBILITY

manodwhb — Fri, 15 Mar 2019 09:28:35 GMT

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

Re: DBMS COMPATIBILITY

Anonymous — Fri, 15 Mar 2019 10:45:44 GMT

Hi,

In your case, UTF-8 character set should help you to manage the data in right format.

Are you facing any issues while creating the jobs? If yes, could you please post the screen shots with errors and sample data so that Community members can check it.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂