EGL Java applications can now connect to and interact with PostgreSQL databases in IBM Business Developer (IBD) V10.

PostgreSQL is an open-source relational database management system (RDBMS) used to store and manage structured data. It supports SQL, transactions, indexing, extensibility, and is widely known for reliability, scalability, and strong data integrity.

Prerequisites

• Install PostgreSQL on your machine
• Administrator access
• System Requirements
  • Windows 10 or Windows 11 (64-bit)
  • Minimum 2 GB RAM (4 GB recommended)
  • At least 500 MB free disk space

Below are the step-by-step instructions to install PostgreSQL on Windows (64-bit) using the official installer and configure it with IBM Business Developer (IBD).

1. Download PostgreSQL installer.
2. Run the installer.
3. Choose the installation directory.
4. Ensure the following are selected.
   • PostgreSQL Server
   • pgAdmin 4
   • Command Line Tools
   • Stack Builder (optional)
5. Choose the Data directory.
6. Set Superuser Password.
7. Configure Port.
8. Choose the locale as Default.
9. Click Next and wait for the installation to complete.
10. Click Finish.
11. Verify Installation (Using pgAdmin).
    • Open pgAdmin 4 from the Start Menu.
    • Connect to PostgreSQL server
    • Enter the superuser password
      
      

Connecting PostgreSQL in IBM Business Developer (IBD)

Execute the steps below to configure the database connection.

1. Open IBD
2. Navigate to Windows -> Preferences.
3. Select SQL Database Connections under EGL.
   
   
   
4. Click New.
5. Select PostgreSQL and Click Next.
6. Click the Edit Driver Definition icon.
   
   
   
7. Go to the JAR List tab and remove the existing JARs(if any).
8. Click Add JAR/Zip and add postgresql jar, which can be downloaded from https://jdbc.postgresql.org/download/.
   
   
   
9. Click OK.
10. Enter the connection details.
    
    URL: jdbc:postgresql://localhost:5432/postgres
    (This is the same database name given during PostgreSQL installation.)
    Username: postgres
    Password: postgres
    (These credentials are user-defined during PostgreSQL installation.)
    
    
    Note: If you want to verify the connection, click Test Connection. If the connection is successful, the message Ping Succeeded! will appear.
    
    
    
11. Click Finish.
12. A new database connection will be created and highlighted in the Preferences window.
    
    
    
13. Click Apply and Close.
    
    

Creating a Table in PostgreSQL

1. Switch the perspective from EGL -> Data.
2. Go to Data Source Explorer.
3. Expand and right-click the database.
4. Select New SQL Script.
   
   
   
5. Write the SQL script to create a table.
   CREATE TABLE employee (empID INT, empname CHAR(10));
   
   
   
6. Right-click the query in the outline view and click Run SQL.
7. The table is created in the database.
8. Navigate to Data Source Explorer -> Schemas -> Schema Name -> Tables and locate your table.
9. Right-click the table and select Data -> Return All Rows.
10. The created table with empty columns will be displayed.