How to enable Progress OpenEdge DB connection

How to enable Progress OpenEdge DB connection

Steps to include Progress OpenEdge DB in our local DB import list:


1. Download and install OpenEdge JDBC driver from https://www.progress.com/jdbc/openedge in Analytics installed server. (It is a paid driver. No free drivers are available)

2. From the JDBC installed location copy openedgewp.jar and paste it in <AnalyticsHome>/lib.

3. Download the dbtypes.json file from the below link and replace it under <Analytics Home>/conf/ZohoDB directory.


4. Add the below property in messages_en.properties present under <Analytics Home>\conf\localized

zrpt.databasedata.dbtype.openedge=OpenEdge

5. Restart the service

    • Related Articles

    • Local or cloud db sync gets stuck in in-progress state

      Note:      This KB is specific for the sync issue with the below log traces. Log traces: [13:58:01:141]|[12-03-2019]|[SYSERR]|[INFO]|[118]:  ...
    • Sync getting stuck in In-progress state

      Issue:  Sync getting stuck in In-progress state. Usually, when the data type mismatch is present, this issue occurs. Logs required: <Zoho/Analytics>/pgsql/data/pg_log/ Check for the error trace by searching "ERROR:  invalid input syntax for" Sample ...
    • Epic progress

      Do you want to track the progress of your epics? Epic progress report helps you track the progress of an epic based on its associated sprints. Using this report you can choose a particular epic and track the number of open and closed work items in ...
    • How do I show the page progress bar in my survey?

      The Customize section enables you to show page progress bar, question numbers and previous button, enable CAPTCHA, personalize the navigation buttons' labels, and change the language of your survey's messages. To show the page progress bar in your ...
    • Enable GDPR

      Navigate to Settings > Portal Settings > Data privacy configurations, and enable General Data Protection Regulation.  You can choose to keep the data privacy configurations as per your wish, and we have some opt-in/opt-out options for you. The ...