Parameterization of Connection Settings for Data Connectors

Connecting to data connectors typically requires application login. To be able to connect, you may need to enter the following information, depending on the connector:

• Host Name

• Port

• Server Name

• User ID

• Password

• Database

These information are then stored in XML files detailing user & group permissions in workbooks. To secure data access and avoid storing connection information in the workbook, it is recommended to parameterize these fields in connectors.

NOTE: Parameterization is supported in Progress DataDirect connectors and most of the other data connectors.

Parameterization of Connection Settings

1. In the Parameters section under the Data Table in the Edit Data Table window, define the connection settings you will use for the connector. Such as the following:

1. • Host

   • User

   • Pwd

   • Server

   • DB

   • Port

For example:

2. Click the of the data source. The Connection Settings dialog of the data source displays.

3. Parameterize the entries in the dialog.

For example:

4. Click OK.