Skip to content

JDBC - DATA SINK

Description

The JDBC data sink is designed to distribute data by writing it to a relational database using JDBC (Java Database Connectivity). This method is particularly useful for integrating with various relational databases, allowing for efficient data storage and retrieval. The JDBC data sink supports various configuration options to customize the data distribution process, including specifying the JDBC driver class, database URL, username, and password.

Config

REQUIRED

Config Parameters

Name Description
dbDriverClass The fully qualified class name of the JDBC driver. This is a required parameter.
dbUrl The JDBC URL for connecting to the database. This is a required parameter.
dbUsername The username for authentication with the database. This is a required parameter.
dbPassword The password for authentication with the database. This is a required parameter.

Config Example

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<apiroConf version="1" xmlns="http://apiro.com/apiro/v1/root">
    <loadOrder>25</loadOrder>
    <dataSinks>
        <dataSink name="JDBC_SINK" definition="JDBC">
            <config>
                <![CDATA[
                    {
                        <![CDATA[
                            {
                                "dbDriverClass": "org.postgresql.Driver",
                                "dbUrl": "jdbc:postgresql://nexus.auspacific.net:1111/M1",
                                "dbUsername": "postgres",
                                "dbPassword": "p@$$w0rd",
                            }
                        ]]>
                    }
                ]]>
            </config>
        </dataSink>
    </dataSinks>
</apiroConf>

Common Mistakes

  • Incorrect JDBC Driver Class: Ensure that the dbDriverClass parameter matches the JDBC driver class for your database.
  • Invalid Database URL: Verify that the dbUrl parameter is a valid JDBC URL and points to an existing database.
  • Authentication Issues: Confirm that the dbUsername and dbPassword parameters are correct and have the necessary permissions to write data to the specified database.
  • Database Connection: If you encounter connection issues, check the network configuration and ensure that the database server is accessible from the machine running the data sink.