I am trying to connect to Sage 300 CRE via JDBC.
I understand that Sage is built on pervasive and I am able to connect to the default pervasive database called demodata and read tables.
i am looking for guide to read Sage specific tables using this pervasive connection.
in pervasive configuration manager I don’t see any sage database or related tables. I tried to create a new database by selecting the data folder but i get an error called “No db file found”.
is it even possible to read actual sage data via jdbc pervasive?
what configuration is required?
is there any other programmatic way to read sage 300 cre data remotely without running an app on the sage server?
i am interested in jcm job and cost code and transaction tables.