Jenzabar creates the default J1 connection string for your school based on your school's campus portal Site Manager, Site Settings, Framework Settings, and ERP. You can then verify the connection string using the Databases page.

The database connection is specific to J1 FormFlow and not a specific form. Additionally, the database connections you access through the Workflow feature are the same as those accessed through FormFlow - Forms. This means you do not need to set up a database connection for every feature or form; the connection will be available for any forms and feature instances 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 and other database objects 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 the campus portal as an administrator and access J1 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 J1 database.

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

6.         Click Save database. Click Done.

1.         Log in to the campus portal as an administrator and access J1 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. Click Done.