Connect IFS Report Builder to Oracle Database

Hi ​@PlaChintW 

to Configure Database Connection in IFS Report Builder and this may also depend on your environment

• IFS Report Builder uses JDBC to connect to Oracle databases. Follow these steps:

Option 1: Configure via IFS Report Builder UI

1. Open IFS Report Builder and navigate to Data Source Configuration.
2. Select Oracle Database as the data source type.
3. Enter Connection Details:
   • JDBC URL:

     jdbc:oracle:thin:@//<hostname>:<port>/<service_name>

   • Username: Provide the Oracle DB user for IFS.
   • Password: Enter the user’s password.
   • Driver Class:
     oracle.jdbc.OracleDriver
4. Test the Connection to ensure proper configuration.
5. Save Settings and apply changes.

Option 2: Manually Configure the Configuration File

If configuring via the UI is not possible, you can manually edit the Report Builder Configuration File.

1. Locate the configuration file, usually found in:
   <IFS_Report_Builder_Installation_Path>/config/reportbuilder.properties
2. Open the file in a text editor and modify the following parameters:
   db.url=jdbc:oracle:thin:@//dbserver.company.com:1521/IFSDB db.username=IFS_REPORT_USER db.password=your_secure_password db.driver=oracle.jdbc.OracleDriver
3. Save and restart IFS Report Builder.