04-13-2018 07:50 AM
Is there anywhere I can get basic information about running an SQL query against the OnBase DB? Assume I know absolutely nothing about the DB backend of OnBase.
I have the password for the hsi user and I am trying to use PL/SQL developer to do the query, connecting with the same tnsnames file that allows me to successfully run the thick client and config utility. I keep getting the message that the username/password is invalid. Am I going about this entirely wrong? I have been reading the "OnBase Database Reference Guide" and the "Database Reporting Guide" but they both assume I am familiar with terms and concepts that I am not, so I am not finding them to be any help.
04-13-2018 08:05 AM
Hi William.
First, I would ask what you are looking to accomplish by querying the database which you can't do within the Client? There are is lot of functionality within the clients to get at the data, but obviously there are limits.
Second, the database back end correlates to the client front end. You might want to start by learning the OnBase Client and the terminology associated with the software which will likely help you as you start to investigate the database. Once you understand that, the Database Reporting Guide will help you to understand the layout of the schema used by the software
For basic information, you have review the available courses on Training.OnBase.com. There are a number of End User Essential eLearning courses which discuss the basics (I haven't watched them so I don't know the content) and even a Database Reporting eLearning class. If you have Premium you can take a deeper dive, as there are a number of Database courses available.
Best wishes!
04-13-2018 02:38 PM
04-16-2018 06:47 AM
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.