Hi Appian Team, I have newly been asked to look after Appian and imm

What application server are you using?

It is a unix suse OS, does that help? Is there a specific config file in a location which will state where the DB would be?

Yes, and it depends on what application server software you are using. Is it JBoss, WebSphere or WebLogic? Do you know which versions of these software components are used?

Also, what do you mean by the "Appian DB"? Do you mean the relational database being used by Appian? Or do you mean the in-memory engines used by Appian?

I recommend taking a look at the Server Admin Guide on the Product Docs: forum.appian.com/.../Server_Administrator_Guide. Specifically, see forum.appian.com/.../Configuring_Relational_Databases

These are useful pages for learning more about the components in Appian: forum.appian.com/.../Architecture and forum.appian.com/.../Gateway_Architecture

It is JBoss.

@ Jed I am completely not sure. All i know is that a business user would like to be able to run specific queries only as read only mode however no-one seems to have any knowledge on where any database for Appian sits or how to actually check where possible databases are for Appian from any configuration files.

I am presuming there is no real answer to locate the DB?

I will take a look at the page references you have mentioned.

Sorry those links seem to keep redirecting back to this same forum page which is strange ..

Go to forum.appian.com/.../ and then search for the pages listed (without underscores).

If a business user wants to run queries, that implies they want to write SQL against a database. Inside Jboss you'll find an appian-ds.xml file that indicates where the relational database is located. However, that file also includes the username and password of the *system* account used by Appian to connect to the database. The business user will need a separate username and password which only has read-only permission. Do not give them the username and password used by Appian. You may need to talk with your IT department about this.

Instead of writing one-off queries, I would recommend instead that the business owner define Appian reports and/or Appian records and paging grids in order to expose the data he/she is looking for. Or he/she can use Query Rules in process to query the database. The benefit, besides not needing to connect directly to the database, is that they'll be able to save the reports and processes to use later or share with others.

FYI - you can't write queries against the Appian Engines - you define reports within Appian to expose that data.

@Arvinder - Please try the links again that Jed mentioned.