Click the New icon in the toolbar to save the current ODBC Connection and then clear the page making it ready for a new item.

Click the Save icon in the toolbar to save the current ODBC Connection and return to the Define ODBC Connections listing.

Click the Save As icon in the toolbar to save the current ODBC Connection to a new name. You will be prompted to enter a new name. Click OK to save the ODBC Connection to a new name and then continue editing the ODBC Connection definition. Click Cancel to return to the existing ODBC Connection definition without saving.

Click the Delete icon in the toolbar to delete the current ODBC Connection . You will be prompted with a "Are you sure you want to delete?" dialog. Clicking Yes will permanently delete the ODBC Connection and then return to the ODBC Connections listing. Click Cancel to return to the existing ODBC Connection without deleting.

Click the Test icon in the toolbar to test the defined ODBC connection and confirm access to your data source. You will need to save your current definition before you can complete the test. You will then be notified if the test is successful or not. If the test fails, refer to the error dialog for possible reasons and corrective action.

Click the Help balloon to open the help for this page.

Field Name

Description - Usage - Notes

Name

Enter the name of the ODBC Connection. By convention, it would include a prefix that associates it to an integration and a general purpose separated by and underscore (e.g., SQL_ODS).

Description

Enter the description for the ODBC Connection. This should provide enough information to explain how the ODBC Connection is used.

Type

Select a Type from the list of available choices to indicate what type of database will be used for the ODBC connection. For example: Oracle 11g, MS Access, MS SQL. 

The available Types will depend on what database types are licensed and installed on the system. Contact Kore for more information on licensing additional database connectors.

ODBC Name

Enter the name of the System DSN as defined in the 32-bit version of the ODBC Data Source Administrator utility in Windows.  

For more information on setting up ODBC connections as System DSNs on your system contact your system administrator. 

Username

If you are not using Windows Authentication, enter the username portion of the user's credentials when connecting to the remote system. Credentials are only supported in certain ODBC Connection types. 

If you need to include the domain name in a Username make sure to enter two backslashes since the backslash character is the escape character in java applications (which Kourier uses to support FTP type DSNs).  

Password

If this ODBC Connection  has restricted access, enter the password portion of the user's credentials when connecting to the remote system. Credentials are only supported in certain ODBC Connection types.