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 an ACL command.

    2. If you want to copy the settings from an existing profile to the new profile, select the appropriate profile from the Copy Settings From drop-down list.
    3. Click OK.
  4. 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.

    • 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 prompts you for it the first time you use the server profile each session. ACL retains 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.

  5. 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.

  6. Click Save.
  7. If you entered a password, click OK to save the password with the profile.
  8. Click Close.

    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
Database profiles
Server profiles

(C) 2015 ACL Services Ltd. All Rights Reserved.