By Using Chat Bot Can we Access Application Data in the Database ?

Can you be more specific what data you want to access?

For Example I am having an Application for Employee Management which Includes the Data model like below in database.

Employee(employee id, name, email, phone, department, project)

Employee Education Details (id, employee id, degree, university, cgpa)

Employee Skill Set (id, employee id, certification type, certification name)

Requirement : if i search like below it has to give me the results accordingly.

1. i want employees who are having B Tech Qualification and Mysql skill

2. i need count employees by project wise

3. I want employees who are part of Appian Department ..etc

Thanks,

Praneeth.

For Example I am having an Application for Employee Management which Includes the Data model like below in database.

Employee(employee id, name, email, phone, department, project)

Employee Education Details (id, employee id, degree, university, cgpa)

Employee Skill Set (id, employee id, certification type, certification name)

Requirement : if i search like below it has to give me the results accordingly.

1. i want employees who are having B Tech Qualification and Mysql skill

2. i need count employees by project wise

3. I want employees who are part of Appian Department ..etc

Thanks,

Praneeth.

I would rather create a view on database and then related CDT in Appian. This will give you an option to use simple query entity expression to get results.

for Oracle you can check that: https://docs.oracle.com/javadb/10.8.3.0/ref/rrefsqlj15446.html