Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This topic contains the hardware and software requirements for running the Aptify 6.3 server components and the Windows Desktop client. It includes the following sections: 


Info

This topic lists the minimum system requirements to run Aptify 6.3 in various environments. Note that these requirements are only an estimate; an individual client's requirements may vary. For example, a client’s disk array solution will depend on projected transactions per minute. This needs to account for orders, queries, web transactions and other types of database transactions.

Disk Subsystem requirements vary greatly from customer to customer due to factors such as transactional throughput and capacity. Because of this, Aptify is unable to make complete recommendations for the required storage solution. The examples given for each hardware class should be used as a starting point for understanding the storage requirements to be implemented in your system.

If you would like to virtualize your environment please consult with Aptify’s Infrastructure Specialists for additional recommendations.

...

The requirements are listed in the following sub-sections:


Note
titleNote Concerning Windows Updates

Aptify recommends that you install the latest updates to the Windows server where you will be installing Aptify 6.3. 

...

Database Server Operating Systems

Aptify 6.2 3 databases deployed and active in:

Microsoft SQL Server 2012

Microsoft SQL Server 2014

Microsoft SQL Server 2016

Microsoft SQL Server 2017 (with CLR Security setting disabled)

The Aptify database supports the following editions for all versions:

  • Standard
  • Business Intelligence (SQL 2012, 2014, 2016, and 2019 only)
  • Enterprise (including SQL Server Enterprise Clustering support)
  • Developer (for developer use only)

Windows Server 2012 – Foundation, Essentials, Standard, and Datacenter

Windows Server 2012 R2 – Foundation, Essentials, Standard, and Datacenter

Windows Server 2016 – Foundation, Essentials, Standard, and Datacenter

Windows Server 2019 – Foundation, Essentials, Standard, and Datacenter


...

  1. Log into SQL Server 2019 with Administrator privileges.
  2. Right-click the Aptify database and select the 'New Query' option.To confirm that the 'CLR Strict Security' is enabled, ' option.
  3. To confirm that the 'CLR Strict Security' is enabled, run the given query.

    Info

    select name,value from sys.configurations where name = 'clr strict security'. 

    1. If the value = 1, your 'CLR Strict Security' is enabled.

    2. If the value = 0, your 'CLR Strict Security' is disabled.

  4. Enable ‘show advance options’ to proceed further. To confirm the value of ‘show advance options’ run the given query.

    Info

    select name,value from sys.configurations where name = 'clr strict security'. show advanced options'

    1. If the value = 1, your 'CLR Strict Securityshow advance options' is enabled.

    2. If the value = 0, your 'CLR Strict Securityshow advance options ' is disabled.
      • Enable ‘show advance options’ by executing given procedure.

        Info

        EXEC sp_configure 'show advanced options', 1

        RECONFIGURE


  5. To disable the 'CLR Strict Security' (value = 0) include the given query and execute it.

    Info

    EXEC sp_configure 'clr strict security', 0

    RECONFIGURE


    USE APTIFY

    ALTER DATABASE CURRENT SET TRUSTWORTHY ON;

    ALTER DATABASE CURRENT SET TRUSTWORTHY OFF;


  6. Execute the below query to make sure that the 'CLR Strict Security' is disabled (value = 0).

    Info

    select name,value from sys.configurations where name = 'clr strict security'. 


...

Aptify recommends optimizing the memory that SQL Server utilizes so the setup can be successful. See Note Concerning SQL Memory Usage below for more details.

Note
titleNote Concerning Non-Aptify Named Databases

If your Aptify database is named something other than APTIFY, additional steps are required prior to installing Aptify 6.3. Please contact the Aptify Technical Support team for additional information. 

...

When installing a large service pack like Aptify 6.2 3 (and on busy systems in general), Aptify recommends restricting the amount of memory that SQL Server can utilize based on the system's overall available memory. This will ensure the setup program itself has access to the appropriate memory it needs to successfully install. You can find several examples online, including posts like the following, for guidance:

...

Anchor
_AppServ
_AppServ
Application Server Requirements

See Application Server System Requirements for more information on the software and hardware requirements to support an Application Server for executing asynchronous process flow runs and scheduled tasks. An organization can deploy 1 to n application servers, depending on utilization and load.

Anchor
_deskclient
_deskclient
Aptify Desktop Client Requirements

This section lists the recommended software and hardware requirements for running the Aptify Desktop client in the supported environments.


Note
titleNote

The Aptify Desktop client will function on hardware that does not meet these requirements, but for best performance, a user’s workstation should meet these requirements. 

...

  • Operating System: Windows 10, Windows 8.1, Windows 8 (Professional, Ultimate or Enterprise Editions)
  • Aptify 6.0 Desktop client
  • 32-bit version of the Crystal Reports 13 viewer (Aptify can provide the installer for this software)
  • SSRS Installer
  • Microsoft .NET Framework v3.5 and 4.5: The Aptify setup program adds SSRS Installer
  • Microsoft .NET Framework 3.5 to a desk­top computer if it is not already installed. .v4.8: NET Framework 4.5 8 is not installed by Aptify. If not already installed on the computer, you can download the installer here: https://wwwdotnet.microsoft.com/en-us/download/details.aspx?id=30653.dotnet-framework
  • Microsoft DHTML Editing Control: This control is required to use HTML fields in the Aptify desktop client. You can download the control here: https://www.microsoft.com/en-us/download/details.aspx?id=8956.
  • Microsoft Office 2007 or later: 
    • This includes Office 365 if you are using it in conjunction with the desktop version of Microsoft Office (2007, 2010, or 2013) or if you have Office Professional Plus with Office 365.
    • Microsoft Office is only required if an organization intends to use any of Aptify’s Microsoft Office integration features, such as the Export to Excel wizard, the Microsoft Word Mail Merge wizard, Pivot Table views, and Outlook integration.
    • Note that Aptify’s Pivot Table view type requires the Office Web Components that are included with Office 2003 (OWC 11). You need to download and install OWC 11 separately to enable pivot table sup­port. OWC 11 is available for download at: http://www.microsoft.com/downloads/details.aspx?Fami-lyId=7287252C-402E-4F72-97A5-E0FD290D4B76&displaylang=en
    Microsoft MapPoint for Map Views support in Aptify Windows desktop application
    • to enable pivot table sup­port. Please contact our Technical Support team if you need any assistance.

Anchor
#_dchw
#_dchw
Hardware Requirements

...

This section lists the minimum software and hardware requirements for development environments.

Anchor
_devsw
_devsw
Software Requirements

  • Operating System: Windows 8, Windows 8.1 or Windows 10
  • Microsoft SQL Server 2012 or later
  • Aptify 56.5.6 3 Server components and the Windows Desktop client
  • 32-bit version of the Crystal Reports 13 viewer (Aptify can provide the installer for this software)
  • Microsoft .NET Framework v3.5 and 4.5: The Aptify setup program adds .NET Framework 3.5 to a desk­top computer if it is not already installed. .NET v4.8: NET Framework 4.5 8 is not installed by Aptify. If not already installed on the computer, you can download the installer here: https://wwwdotnet.microsoft.com/en-us/download/details.aspx?id=30653.dotnet-framework
  • Microsoft DHTML Editing Control: This control is required to use HTML fields in the Aptify desktop client. You can download the control here: https://www.microsoft.com/en-us/download/details.aspx?id=8956.
  • Microsoft Office 2007 or later: 
    • This includes Office 365 if you are using it in conjunction with the desktop version of Microsoft Office (2007, 2010, or 2013) or if you have Office Professional Plus with Office 365.
    • Microsoft Office is only required if an organization intends to use any of Aptify’s Microsoft Office integration features, such as the Export to Excel wizard, the Microsoft Word Mail Merge wizard, Pivot Table views, and Outlook integration. 
    • Note that Aptify’s Pivot Table view type requires the Office Web Components that are included with Office 2003 (OWC 11). You need to download and install OWC 11 separately to enable pivot table sup­port. OWC 11 is available for download at: http://www.microsoft.com/downloads/details.aspx?Fami-lyId=7287252C-402E-4F72-97A5-E0FD290D4B76&displaylang=en.

  • Microsoft MapPoint for Map Views support in Aptify Windows desktop applicationMicrosoft Report Viewer 2012 to support viewing of Microsoft SQL Server Reporting Services (SSRS) reports

...

  • The following software is required to develop any component for Aptify 6.23
    • Microsoft Visual Studio

  • Additionally, the following products are required to develop new user interface components for the Aptify Desktop client that utilize the Aptify framework: 
    • Infragistics NetAdvantage 2008 Volume 1:
      • You need a license for these Infragistics control if you are creating new Aptify forms within Visual Studio since several Aptify bound controls inherit from Infragistics controls (and when you use the components in Visual Stu­dio, licensing is required for the underlying third-party controls).
      • While newer versions of the Infragistics tools may be available, Aptify 6.2 3 and later uses NetAdvantage® 2008 Volume 1. In order to obtain this software, you may need to purchase the latest version and then contact Infragistics to obtain the 2008 Volume 1 version (and an appropriate installation key for that version). 
      • Note that this requirement only applies to developing new functionality for the Aptify desktop application.
         
    • ComponentOne Studio® for WinForms:
      • Note that this requirement only applies to developing new functionality for the Aptify desktop application.
      • You need a license for this developer tool if you intend to add an Entity List View control to a form you are developing within Visual Studio (since the Entity List View control uses the ComponentOne C1FlexGrid control) or if you are inheriting from one of the Aptify wizard assembly that uses the C1FlexGrid control. Aptify uses the 2.6.20073.357 version of the C1FlexGrid control.
      • Aptify also leverages the C1SpellChecker control for the text field spell check functionality. Aptify uses the 2.0.20073.5 version of the C1SpellChecker con­trol.

        Note
        titleNote

        If you are developing user interfaces using the Aptify Visual Designer environment, you do not need these third-party applications. The Visual Designer allows you to modify existing form templates in the system and is the most common way of altering the user interfaces in Aptify. Since when using the Visual Designer you are interacting with Aptify controls within Aptify’s design time environment (and not within the Visual Studio environment), a license to the third party controls is not necessary.


    • The following software is required to write Crystal Reports:
      • SAP Crystal Reports.
      • The 6.2 3 Aptify Desktop client and Aptify web interface use the Crystal Reports 13 (Crystal Reports for Visual Studio 2010) viewer to display reports. Upgrading Crystal Reports versions for a Crystal Reports writer should not have an impact on Aptify. The reports viewed through Aptify should continue to use the Crystal Reports viewer leveraged by the Aptify interfaces. Existing reports should continue to function as they do today. New reports should still be compatible with the Crystal Reports 13 viewer.

        Note
        titlenote

        Aptify distributes the run time libraries from Crystal Reports so that end users can run reports directly from the Aptify Windows Desktop client. However, report writers need a license for the full version of Crystal Reports to create and edit reports.


    • The following software is required for Microsoft SQL Server Reporting Services (SSRS) Reports:
      • The 6.2 3 Aptify Desktop client and Aptify Web interface use the Microsoft Report Viewer 2012 to display reports. This software is installed by the Aptify 6.2 3 install program.


Anchor
_devhw
_devhw
Hardware Requirements

...

  • Aptify Desktop client installed with 6.2 3 components.
  • Aptify Desktop client has connected at least once to the Aptify 56.5.6 3 database server.

This topic contains the hardware and software requirements for running the Aptify 6.2 3 server components and the Windows Desktop client. It includes the following sections: 

...

Info

This topic lists the minimum system requirements to run Aptify 6.2 3 in various environments. Note that these requirements are only an estimate; an individual client's requirements may vary. For example, a client’s disk array solution will depend on projected transactions per minute. This needs to account for orders, queries, web transactions and other types of database transactions.

Disk Subsystem requirements vary greatly from customer to customer due to factors such as transactional throughput and capacity. Because of this, Aptify is unable to make complete recommendations for the required storage solution. The examples given for each hardware class should be used as a starting point for understanding the storage requirements to be implemented in your system.

If you would like to virtualize your environment please consult with Aptify’s Infrastructure Specialists for additional recommendations.

...

...

Note
titleNote Concerning Windows Updates

Aptify recommends that you install the latest updates to the Windows server where you will be installing Aptify 6.23

Anchor
_suppdb
_suppdb
Supported Database and Operating Systems

Database Server Operating Systems

Aptify 6.2 3 databases deployed and active in:

Microsoft SQL Server 2012

Microsoft SQL Server 2014

Microsoft SQL Server 2016

Microsoft SQL Server 2017 (with CLR Security setting disabled)

The Aptify database supports the following editions for all versions:

  • Standard
  • Business Intelligence (SQL 2012, 2014, 2016, and 2019 only)
  • Enterprise (including SQL Server Enterprise Clustering support)
  • Developer (for developer use only)

Windows Server 2012 – Foundation, Essentials, Standard, and Datacenter

Windows Server 2012 R2 – Foundation, Essentials, Standard, and Datacenter

Windows Server 2016 – Foundation, Essentials, Standard, and Datacenter

Windows Server 2019 – Foundation, Essentials, Standard, and Datacenter


...

To support the Microsoft SQL Server 2019 for Aptify 6.2 applicationapplication, the 'CLR Strict Security' must be disabled. If your 'CLR Strict Security' setting is enabled (value = 1), follow the below steps to disable the same:

  1. Log into SQL Server 2019 with Administrator privileges.
  2. Right-click the Aptify database and select the 'New Query' option.To confirm that the 'CLR Strict Security' is enabled, ' option.
  3. To confirm that the 'CLR Strict Security' is enabled, run the given query.

    Info

    select name,value from sys.configurations where name = 'clr strict security'. 

    1. If the value = 1, your 'CLR Strict Security' is enabled.

    2. If the value = 0, your 'CLR Strict Security' is disabled.

  4. Enable ‘show advance options’ to proceed further. To confirm the value of ‘show advance options’ run the given query.

    Info

    select name,value from sys.configurations where name = '

    clr strict security'. 

    show advanced options'

    1. If the value = 1, your 'CLR Strict Securityshow advance options' is enabled.

    2. If the value = 0, your 'CLR Strict Securityshow advance options ' is disabled.
      • Enable ‘show advance options’ by executing given procedure.

        Info

        EXEC sp_configure 'show advanced options', 1

        RECONFIGURE


  5. To disable the 'CLR Strict Security' (value = 0) include the given query and execute it.

    Info

    EXEC sp_configure 'clr strict security', 0

    RECONFIGURE


    USE APTIFY

    ALTER DATABASE CURRENT SET TRUSTWORTHY ON;

    ALTER DATABASE CURRENT SET TRUSTWORTHY OFF;


  6. Execute the below query to make sure that the 'CLR Strict Security' is disabled (value = 0).

    Info

    select name,value from sys.configurations where name = 'clr strict security'. 


...

When installing a large service pack like Aptify 6.2 3 (and on busy systems in general), Aptify recommends restricting the amount of memory that SQL Server can utilize based on the system's overall available memory. This will ensure the setup program itself has access to the appropriate memory it needs to successfully install. You can find several examples online, including posts like the following, for guidance:

...

  • Operating System: Windows 10, Windows 8.1, Windows 8 (Professional, Ultimate or Enterprise Editions)
  • Aptify 6.0 3 Desktop client
  • 32-bit version of the Crystal Reports 13 viewer (Aptify can provide the installer for this software)
  • SSRS InstallerMicrosoft .NET Framework v3.5 and 4.5: The Aptify setup program adds Installer
  • Microsoft .NET Framework 3.5 to a desk­top computer if it is not already installed. .NET v4.8: NET Framework 4.5 8 is not installed by Aptify. If not already installed on the computer, you can download the installer here: https://wwwdotnet.microsoft.com/en-us/download/details.aspx?id=30653.dotnet-framework
  • Microsoft DHTML Editing Control: This control is required to use HTML fields in the Aptify desktop client. You can download the control here: https://www.microsoft.com/en-us/download/details.aspx?id=8956.
  • Microsoft Office 2007 or later: 
    • This includes Office 365 if you are using it in conjunction with the desktop version of Microsoft Office (2007, 2010, or 2013) or if you have Office Professional Plus with Office 365.
    • Microsoft Office is only required if an organization intends to use any of Aptify’s Microsoft Office integration features, such as the Export to Excel wizard, the Microsoft Word Mail Merge wizard, Pivot Table views, and Outlook integration.
    • Note that Aptify’s Pivot Table view type requires the Office Web Components that are included with Office 2003 (OWC 11). You need to download and install OWC 11 separately to enable pivot table sup­port. OWC 11 is available for download at: http://www.microsoft.com/downloads/details.aspx?Fami-lyId=7287252C-402E-4F72-97A5-E0FD290D4B76&displaylang=en
    Microsoft MapPoint for Map Views support in Aptify Windows desktop application
    • (OWC 11). You need to download and install OWC 11 separately to enable pivot table sup­port.

      Anchor
      #_dchw
      #_dchw
      Hardware Requirements
Item Requirements
Operating System Windows 10, Windows 8.1, Windows 8
Processor Intel Core2 Duo or higher, or AMD equivalent
Recommended Hard Drive500 GB SATA or 512 GB SSD
Minimum Hard Drive Space 2 GB
Recommended RAM 8 GB

Minimum Free RAM Required for Application

400 MB

Recommended Video Resolution

1920 x 1080 pixels
CD-ROM Optional
Network Card 100 Mbps

...

  • Operating System: Windows 8, Windows 8.1 or Windows 10
  • Microsoft SQL Server 2012 or later
  • Aptify 5.5.6 Server 6.3 Server components and the Windows Desktop client
  • 32-bit version of the Crystal Reports 13 viewer (Aptify can provide the installer for this software)
  • Microsoft .NET Framework v3.5 and 4.5: The Aptify setup program adds .NET Framework 3.5 to a desk­top computer if it is not already installed. .NET v4.8 : NET Framework 4.5 8 is not installed by Aptify. If not already installed on the computer, you can download the installer here: https://wwwdotnet.microsoft.com/en-us/download/details.aspx?id=30653.dotnet-framework
  • Microsoft DHTML Editing Control: This control is required to use HTML fields in the Aptify desktop client. You can download the control here: https://www.microsoft.com/en-us/download/details.aspx?id=8956.
  • Microsoft Office 2007 or later: 
    • This includes Office 365 if you are using it in conjunction with the desktop version of Microsoft Office (2007, 2010, or 2013) or if you have Office Professional Plus with Office 365.
    • Microsoft Office is only required if an organization intends to use any of Aptify’s Microsoft Office integration features, such as the Export to Excel wizard, the Microsoft Word Mail Merge wizard, Pivot Table views, and Outlook integration. 
    • Note that Aptify’s Pivot Table view type requires the Office Web Components that are included with Office 2003 (OWC 11). You need to download and install OWC 11 separately to enable pivot table sup­port. OWC 11 is available for download at: http://www.microsoft.com/downloads/details.aspx?Fami-lyId=7287252C-402E-4F72-97A5-E0FD290D4B76&displaylang=en.
    Microsoft MapPoint for Map Views support in Aptify Windows desktop application


  • Microsoft Report Viewer 2012 to support viewing of Microsoft SQL Server Reporting Services (SSRS) reports

...

  • The following software is required to develop any component for Aptify 6.3: 
    • Microsoft Visual Studio

  • Additionally, the following products are required to develop new user interface components for the Aptify Desktop client that utilize the Aptify framework: 
    • Infragistics NetAdvantage 2008 Volume 1:
      • You need a license for these Infragistics control if you are creating new Aptify forms within Visual Studio since several Aptify bound controls inherit from Infragistics controls (and when you use the components in Visual Stu­dio, licensing is required for the underlying third-party controls).
      • While newer versions of the Infragistics tools may be available, Aptify 6.2 3 and later uses NetAdvantage® 2008 Volume 1. In order to obtain this software, you may need to purchase the latest version and then contact Infragistics to obtain the 2008 Volume 1 version (and an appropriate installation key for that version). 
      • Note that this requirement only applies to developing new functionality for the Aptify desktop application.
         
    • ComponentOne Studio® for WinForms:
      • Note that this requirement only applies to developing new functionality for the Aptify desktop application.
      • You need a license for this developer tool if you intend to add an Entity List View control to a form you are developing within Visual Studio (since the Entity List View control uses the ComponentOne C1FlexGrid control) or if you are inheriting from one of the Aptify wizard assembly that uses the C1FlexGrid control. Aptify uses the 2.6.20073.357 version of the C1FlexGrid control.
      • Aptify also leverages the C1SpellChecker control for the text field spell check functionality. Aptify uses the 2.0.20073.5 version of the C1SpellChecker con­trol.

        Note
        titleNote

        If you are developing user interfaces using the Aptify Visual Designer environment, you do not need these third-party applications. The Visual Designer allows you to modify existing form templates in the system and is the most common way of altering the user interfaces in Aptify. Since when using the Visual Designer you are interacting with Aptify controls within Aptify’s design time environment (and not within the Visual Studio environment), a license to the third party controls is not necessary.


    • The following software is required to write Crystal Reports:
      • SAP Crystal Reports.
      • The 6.2 3 Aptify Desktop client and Aptify web interface use the Crystal Reports 13 (Crystal Reports for Visual Studio 2010) viewer to display reports. Upgrading Crystal Reports versions for a Crystal Reports writer should not have an impact on Aptify. The reports viewed through Aptify should continue to use the Crystal Reports viewer leveraged by the Aptify interfaces. Existing reports should continue to function as they do today. New reports should still be compatible with the Crystal Reports 13 viewer.

        Note
        titlenote

        Aptify distributes the run time libraries from Crystal Reports so that end users can run reports directly from the Aptify Windows Desktop client. However, report writers need a license for the full version of Crystal Reports to create and edit reports.


    • The following software is required for Microsoft SQL Server Reporting Services (SSRS) Reports:
      • The 6.3 Aptify Desktop client and Aptify Web interface use the Microsoft Report Viewer 2012 to display reports. This software is installed by the Aptify 6.3 install program.

...

  • Aptify Desktop client installed with 6.3 components.
  • Aptify Desktop client has connected at least once to the Aptify 56.5.6 3 database server.