Loading
Salesforce から送信されるメールは、承認済ドメインからのみとなります続きを読む

How to Connect to PostgreSQL Database using User Credentials

公開日: Jul 28, 2025
タスク

GOAL

How to connect to PostgreSQL Database in Mulesoft
ステップ
    MuleSoft by default supports connectors to MySQL, SQL Server and Oracle. But it offers to connect to any generic database as long as we can provide the JDBC connector to the project. Being a JAVA application, the connector needs information for the Driver class name, URL which can get very specific. So here’s how you can connect to the PostgreSQL server from Mule.

      1. Drag a database widget on to the flow
      2. Add a new Connector configuration
      3. Select Connection type as “Generic Connection”
      4. Click on Configure to add the JDBC driver and select Add Maven dependency (pre-requisite: Download the latest JDBC driver from the website:  
    https://jdbc.postgresql.org/download/
      User-added image

      5. Click on Install

      6. Click on Browse and select the JDBC driver that was downloaded. This will be imported into the project, so doesn’t matter where the downloaded file lives.
          Click Install. You’ll get a notification that the driver was successfully imported.

           User-added image
      7. Click on Finish

               User-added image

      

      8. Back on the config screen, set the following values on the screen:

           URL: The URL should be in the following format below. The sslmode field is required. 
                     jdbc:postgresql://:/?sslmode=require
           Driver class name: org.postgresql.Driver
           User: your_database_user
           Password: your_database_password
           User-added image

      9. Click on Test connection.. and if you’re successful, you should be all set.
     

    REFERENCE 

    Please refer to the Postgres SQL database Documentation for any additional properties/details of the JDBC URL for Postgres SQL. 

    ナレッジ記事番号

    001116826

     
    読み込み中
    Salesforce Help | Article