ECMT AIM - SQL Connections tab

SQL Connections defined on this tab are available as connections when configuring Dropdowns and Lookups in both Header and Detail fields.

To create a new SQL Connection:

Name the connection via Connection Name field
Enter the Server and Database
Choose Authentication type
If SQL Server Authentication you must enter a Username and Password.
Click the blue “Save” button

To delete a SQL Connection:

Select the SWL Connection from the dropdown that’s filled with “Choose A Connection”
Click the red “Delete”

To edit a SQL Connection:

Select the SQL Connection from the dropdown “Choose A Connection”
Edit values, and Click the blue “Save” button on the bottom

Pressing the green “Create New” Button will clear our all the fields so that a SQL Connection can be entered, but the blue “Save” button needs to be pressed in order to actually save the SQL Connection