IMPORTANT!
Integration via direct SQL Database access is not recommended. The database structure changes as the software develops and Kinetic makes no guarantees these changes will not break existing integration implementations, and takes no responsibility for them. The database structure is proprietary to Kinetic, and Kinetic offers limited support for SQL access.
The recommended and safe approach is to communicate with Primecut via the REST API, which is supported and will be non-breaking across version updates, as well as secure write access.
This information is provided for support of existing customers reliant on SQL access only, new customers should NOT use this.
SQL readonly access to the Firebird database via SELECT statements may be performed with a 3rd party SQL tool such as Flamerobin- but is not recommended.
Setup ExternalReporting User
In order to do this you must setup a database user. When logged into the Primecut client as an administrator, click Setup ExternalReporting User under the Tools menu:
Set your password and remember it!
When you connect with your SQL tool, you may need to set the Database Role to EXTERNAL_READ as well as username and password. eg in Flamerobin Database Registration:
Example ADO or ODBC Connection String:
User ID=externalReporting;Password=******;Database=<SERVER NAME>:<SERVER PATH TO Primecut4.fdb>;ROLE=EXTERNAL_READ;Charset=NONE;port=3050;ServerType=0;Dialect=3;