Skip to main content
Feedback

Creating a custom Database connection

By creating a custom database connection, you can connect to any database that has a JDBC driver.

About this task

You can create a custom database connection by obtaining a JDBC driver for the database and configuring it for use with your basic runtime. This procedure describes the steps to create a custom database connection with the Amazon Redshift data warehouse as an example with a local basic runtime. Amazon Redshift uses the PostgreSQL JDBC driver, which you do not need to install if you are using a Boomi runtime cloud because the driver is already installed.

Procedure

  1. Download the PostgreSQL JDBC driver.

  2. Place the PostgreSQL driver file in the /<installation_directory\>/userlib/database directory by uploading the JAR file into your Integration account library (Settings > Development Resources > Account Libraries), adding that file to a Custom Library component, and deploying the component to the appropriate basic runtime, runtime cluster, runtime cloud, or environment.

note

Uploaded or imported files pass through a virus scanner first. If the scan detects a virus, you receive an error message, and the scan rejects the file. If an error persists, contact Boomi Support.

  1. In Integration, create a Database connection.

  2. On the Connection tab, enter the following information:

    a. Database Type - Custom

    b. User - your_user_name

    c. Password - your_password

    d. Class Name - org.postgresql.Driver

    e. Connection URL - jdbc:postgresql://<endpoint>:<database_port>/<database_name>?tcpKeepAlive=true

  3. Click Save and Close.

On this Page