Search code examples
mysql-connectorinformaticainformatica-powercenterconnector

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?


Solution

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