Java Database Connectivity is an API for the programming language Java, which defines how a client may access a database. JDBC APIs can be used to connect to most of the Relational Database (RDB). Some of the supported RDBs include MS SQL Server, AWS Aurora, My SQL, Snowflake etc.
2. Why JDBC?
JDBC Connector in Logic App allows you to connect to a RDB for multiple use cases:
Like replicating data from your source of truth database to any warehouse database for analytical purposes.
IoT use cases to dump event data to your database.
Since JDBC works on plug and play model you can bring in JDBC drivers of any JDBC supported RDB and start using it, without the need of native DB support in Logic Apps.
JDBC is a built-in connector that allows you to connect to your databases without any Data Gateways.