I am using Dell Boomi software to retrieve data from our customers Sage Pervasive DB.

In order to do that, Boomi needs class name and connection url. It uses java and jdbc to connect to db.

Class name is: com.pervasive.jdbc.v2.Driver.

URL is in format jdbc:pervasive://SERVER_NAME/DSN.

Our customer has set Table and Field name mode in ODBC DSN (Timberline Data Driver) to Custom/Standard which has more readable

table/column names than Dictionary ones (MASTER_JCM_R1 for example).

However, Boomi only sees Dictionary table names, it cannot retrieve data from table MASTER_JCM_JOB which is equivalent of MASTER_JCM_R1 table.

Do you have any idea where the problem lies, in URL, driver, ODBC DSN setting or something else?

Thanks!