The connection agent can be thought of as the gatekeeper to your databases and LDAP systems as far as exposing data to PerfectForms™. The connection agent is required for the following connection types:
| • | Database (Oracle 10g XE, SQL Server 2005 / 2008, MySQL 5.0 / 5.5, Sybase ASE 15.0) |
| • | Directory services (LDAP/Active Directory) |
| • | Text/CSV files |
If a form needs access to a database then contact the database administrator or system administrator and provide the following information:
| • | The database that needs to be accessed |
| • | Which tables need to be accessed |
| • | Which users or user groups should be granted access |
The database administrator can then provide a user name and password that gives access only to specific databases and tables. The database administrator can control who is able to build forms that have read-only or read-write access to specific databases. A PerfectForms™ administrator is then given the login details and can set up connections that talk to the connection agent.
Updated: 30/03/2012
Page url:
http://www.perfectforms.com/Documentation/manual/html/?lookup_agent.htm
PerfectForms™ -- forms software, workflow software, and business process management