CODEWITHSUNDEEP
mysql-connectorinformaticainformatica-powercenterconnector
BioLogic
BioLogic

Reputation: 165

Difference between jdbc driver and connectors

From what I understand, jdbc drivers provide interface to connect to database,read data,write data. But isn't informatica connectors also about the same thing i.e. connect to database,read data,write data. then what is the difference between the two?

Upvotes: 2

Views: 2009

Answers (2)

joaoferr
joaoferr

Reputation: 31

The most obvious difference really is the language that the drivers were written, Java and C, C++ and many other differences like those described in the link below:

https://www.geeksforgeeks.org/difference-odbc-jdbc/

Upvotes: 1

Maciejg
Maciejg

Reputation: 3353

The ODBC/JDBC drivers provide basic connectivity and features. Informatica dedicated connectors can take advantege of advanced features, e.g. bulk mode, truncates instead of deletetes, etc.

Upvotes: 1

Related Questions