Database Connections

Any database connections you set up are available to all forms within any FormFlow instance in your Campus portal.

Database connections let you exchange information between your form and the EX database, a custom ICS NET table, or your own custom table. Database connections use ODBC connection strings. When EX and JICS are installed, an EX database connection is created for you based on your JICS Site Manager settings. Jenzabar recommends verifying the connection string before using the form, and deleting, updating, or creating different connections as needed.  

Ensure the user specified in the database connection string has permission to access the objects defined in your data sources, mapped statements, or stored procedures.

Sample Setup

Set Up the EX Database Connection


 
Jenzabar creates the default EX connection string for your school based on your school's JICS Site Manager, Site Settings, Framework Settings, and ERP (Example). You can then verify the connection string using the EX FormFlow - Forms databases page.

The database connection is specific to EX FormFlow and not a specific form. This means you do not need to set up a database connection for every form; the connection will be available for any and all forms you create.

Recommended Practice: Instead of using your school's SA credentials, create a generic FormFlow - Forms user account or use a dedicated service account such as ICSNetUser to access the data. This user account will need to be granted the appropriate permissions to the database tables used regularly. TE_PGMR can be used, but if the TE_PGMR password changes, your team may forget to make the update in FormFlow - Forms and the database connection will no longer work.

1.         Log in to JICS as an Administrator and access EX FormFlow - Forms.

2.         Click Manage Forms. The Manage Forms page appears.

3.         Access the Database page:

o     Click Site Administrators. When the Site Administrators page appears, click Databases.

OR

o     Click on the name of the form you are working with. When the form appears, select Databases from the Tools menu.

4.         From the Database drop-down, select your EX database.

5.         Verify the connection string is valid and follows your school's internal best practices.

6.         Click Save database.

7.         Click Done.

Add a Database Connection

1.         Log in to JICS as an Administrator and access EX FormFlow - Forms.

2.         Click Manage Forms. The Manage Forms page appears.

3.         Access the Database page:

o     Click Site Administrators. When the Site Administrators page appears, click Databases.

OR

o     Click on the name of the form you are working with. When the form appears, select Databases from the Tools menu.

4.         Click Databases. The Database page appears.

5.         Click the Add icon.

6.         In the Name field, enter the name of the database you are adding.

7.         In the Connection String field, enter the ODBC connection string needed to connect to your database.

Connection string formatting is detailed on the connection strings website. The site includes details for SQL database strings as well as other databases.

8.         Click Save database.

9.         Click Done.