Creating server profiles

Before you create a server profile, you need to get the required server settings from your systems administrator.

If more than one user is sharing an ACL project, you must make sure each of them uses the same profile name, and has the same host and port settings, for each server profile used in the project. Each user can specify their own login credentials in the server profile, but they must have the appropriate security rights assigned.

To create a server profile:

  1. Select Server > Server Profiles.
  2. Click New.
  3. In Add New Profile, complete the following steps:
    1. Enter a descriptive name in Profile Name. The profile name can have up to 50 alphanumeric characters, including spaces. If spaces are used, the profile name must be enclosed in quotation marks if you reference the profile name in a command.
    2. If you want to copy the settings from an existing profile to your new profile, select the appropriate profile from the Copy Settings From drop-down list.
    3. Click OK.
  4. Select Windows in the Server Type drop-down list.
  5. Enter the connection details for the server by completing the following fields:
    • Use Integrated Windows Authentication – If your organization is an ACL Analytics Exchange customer, and AX Server is configured to use Integrated Windows Authentication, select this checkbox to use your Windows account information to automatically log in when required.

    • User ID – The user ID required to log on to the server. This text box is disabled if Use Integrated Windows Authentication is selected.

    • Password(Optional) The password required to log on to the server. This text box is disabled if Use Integrated Windows Authentication is selected.


      You are not required to save your password with the profile. If you choose not to save your password, ACL will prompt you for it the first time you use the server profile each session. ACL will retain the password for the remainder of the session only.

    • Prefix – The file path for your working directory on the server. For example: C:\ACL\MonthEndAnalysis

    • Host Name – The hostname or IP address of the server to connect to. If you selected the Use Integrated Windows Authentication checkbox, you must specify the full hostname for the server. For example:

    • Port – The port to use to connect to the server. The default value is 10000.

  6. If necessary, select either of the following options:
    • Encryption – Encrypts network communications between ACL and the server using a secure 32-bit encryption algorithm. This option is selected by default, but encrypting all data may noticeably slow down communications. Deselect this option if encrypted communication is not required.

    • Compression – Compresses data sent between ACL and the server. Compressing data speeds up transmission time, even if the data is encrypted. Depending on the type of data being transferred, compression may be as high as 10:1. However a compression ratio of 3:1 is characteristic of most data.

  7. Click Save.
  8. If you entered a password in the Server Profiles dialog box, ACL displays a message box asking you to confirm whether you want to save the password with the profile. Click OK to save the password with the profile.

    After you complete these steps you can connect to the server. If you are connecting to ACL Analytics Exchange Server you must create database profiles for any SQL Server, Oracle, or IBM DB2 databases you want to connect to using the server profile you have configured.

Related concepts
Sharing projects that use server profiles
Database profiles
Server profiles
Related tasks
Modifying server profiles
Deleting server profiles

(C) 2013 ACL Services Ltd. All Rights Reserved. | Send feedback