What are the advantages/disadvantages to JDBC vs. ODBC?

  • JDBC offers a live connection to the database, and is the preferred method.
  • ODBC connections don’t use the full power of the database.

Panoply actually runs best using an AWS Redshift connection. However, it does also support Postgres, JDBC, and ODBC connections.