On-Premise Installation  On-Premise Installation

On this page, you will find information about installing Data Applied in your environment (the hosted online version can be accessed here). After installing the on-premise version, you will be able to create one user account, and analyze small data sets (up to 500 rows of data and 6 fields) at no cost and without expiration. To support a larger number of users or larger data sets, you can also order a license key. You can install Data Applied on Microsoft Windows Server, but also on most Microsoft Windows Vista editions. Download the 64 bit or 32 bit setup, unzip to your local drive, and start crunching data!

Install Database  Step 1: Install Database

Install one of the following:

MySQL + ODBC Driver Installation:

close

  • Download MySQL binaries and run setup. The "typical" setup option is sufficient.
Installation step

  • Upon completion, configure the SQL instance. This walk-through uses the "detailed configuration" setup option.
Installation step

  • Select the type of installation most appropriate for your environment. Review FAQ information below to learn more about optimizing MySQL settings for production environments.
Installation step

  • Data Applied does not use SQL transactions. Selecting the non-transactional database option is therefore sufficient and often yields better performance.
Installation step

  • Data Applied uses a custom SQL connection pool. Allow for 10+ connections per Data Applied Web instance (or adjust configuration parameters such as SqlMaxConnections).
Installation step

  • Data Applied connects to MySQL using an ODBC connector. This requires TCP/IP networking to be enabled, even when the SQL instance is installed on the same machine as Data Applied Web. Select strict mode.
Installation step

  • Data Applied supports storing data containing international characters. The UTF-8 option provides true international support and is therefore recommended.
Installation step

  • Data Applied connects to MySQL using an ODBC connector. Download and install the MySQL 5.1 ODBC connector on the computer(s) where Data Applied Web will be deployed.
Installation step

SQL Express Installation:

close

  • Download SQL Express 2005 or 2008 binaries and run setup. The installer offers minimal installation options.
Installation step

  • Select "Windows Integrated Authentication" and finish the installation.
Installation step

  • The IIS account under which Data Applied Web runs must be able to log in to SQL Express. Unfortunately, by default, the IIS account will often NOT have rights to do so. To address this issue, grant the IIS account sufficient SQL permissions, including the right to create databases. The local Network Service account is the default account for any IIS installation. The following commands grant full access to SQL Express to the local Network Service account.
  • open a command prompt
  • osql -E -S .\SQLEXPRESS
  • sp_addsrvrolemember N'NT AUTHORITY\NETWORK SERVICE', sysadmin
  • go
Installation step

Configure IIS  Step 2: Configure IIS

Enable and configure IIS (show me):

  • Enable the Windows "Internet Information Services" (IIS) feature
  • Ensure the "ASP.NET" option is enabled
  • Ensure the "IIS Metabase and IIS 6 Configuration Compatibility" option is enabled
  • IIS is available on Microsoft Windows Server systems, but also on most Microsoft Windows Vista editions

IIS Configuration:

close

  • Make sure the IIS 6 Metabase compatibility option is enabled. The UI to enable features depends on Windows versions.
Installation step

  • Make sure the ASP.NET option is enabled. The UI to enable features depends on Windows versions.
Installation step

  • After enabling features, Windows will typically take several minutes to update the system.
Installation step

Install Data Applied Web  Step 3: Install Data Applied Web

Run Data Applied Web setup (show me):

  • Select binaries matching your Operating System (64 bit or 32 bit)
  • Extract zipped content to a local drive (don't run setup.exe directly from the zip archive)
  • Run setup.exe on the machine where IIS is enabled
  • Review the license agreement and follow the steps
  • Navigate to your installation URL (ex: http://localhost) and click "sign up" to create a local user account

Data Applied Web Installation:

close

  • Carefully review the license agreement and accept only if you agree.
Installation step

  • Enter the SQL connection string for your SQL database. Ensure that specified credentials (or the IIS account) can connect to the SQL database, with sufficient permission to create new databases. Carefully enter a valid connection string (see examples)!
Installation step

  • Enter SMTP server settings if you want to enable e-mail notifications upon task completion, require users to confirm their e-mail addresses to register, or want to enable e-mail password resets. Otherwise, leave all settings blank and proceed.
Installation step

  • Select e-mail options to enable. If you did not enter an SMTP server name in the previous screen, proceed directly to the next screen.
Installation step

  • Select the IIS location where Data Applied Web should be installed. Leave the virtual directory value empty if you want to install in the root (default) virtual directory of the selected site. Warning: existing files in the selected location may be replaced.
Installation step

Troubleshooting  Troubleshooting

Error What does "Windows found that this file is potentially harmful. Windows has blocked access to this file." mean?
Windows security software can block the execution of setup files downloaded from the Internet. Right-click on the zipped file you saved on your computer, select "Properties", and click on the Unblock action (show me). We obviously scan all our binaries using anti-virus software before publishing them!

Unblock

Error What does "This installation package is not supported by this processor type." mean?
This probably means you installed the wrong binary version (x86 vs. x64) of the setup program. Please select the binary version which matches your Operating System. To know if your Operating System is 32 or 64 bit, check Windows system properties .

Error What does "The installer was interrupted before Data Applied Web could be installed." mean?
This probably means you did not enable the "IIS Metabase and IIS 6 Configuration Compatibility" feature. Find and add this Windows feature, which is located several levels below the "Internet Information Services" root feature. Please also review step-by-step IIS configuration instructions above.

Error What does "You do not have sufficient privileges to complete this installation for all users of the machine." mean?
This probably means you accidentally executed an .msi file, when you should be executing setup.exe. The setup .msi file can be used for administrative (silent) installations, but this typically requires elevated permissions. The normal way to install Data Applied is by executing setup.exe.

Error What does "Cannot open database "DataApplied" requested by the login. The login failed." mean?
This could mean that the IIS account running Data Applied Web does not have rights to log in to SQL. We recommend checking the event log to see if there is any "Data Applied" warning event with more details. Please also review step-by-step SQL Express installation instructions above (if applicable).

Error What does "The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine." mean?
This probably means Excel files cannot be parsed because a Microsoft component called "2007 Office System Driver: Data Connectivity Components" (also known as "AccessDatabaseEngine.exe") is missing. Search for this component on Microsoft's Web site, and install it.

Error What does "This configuration section cannot be used at this path. This happens when the section is locked at a parent level." mean?
Data Applied Web's web.config file specifies important IIS settings, which may have been locked down by an administrator. Please review file %windir%\system32%\inetsrv\config\applicationHost.config, and in particular any "Deny" statements under <location path="your_install_path">.

Error Why do I get "Access Denied" errors when trying to save changes made to a Data Applied .config file?
In some Operating Systems such as Microsoft Vista, an elevated security context is required to make certain system changes. Search for "Windows Explorer", right-click on the shortcut, and select the "Run as administrator" action. Navigate to, edit, and save the configuration file.

Error Why did calling sp_addsrvrolemember fail with an invalid login error?
This probably means that account 'NT AUTHORITY\NETWORK SERVICE' has another name on your Operating System. For example, on a Spanish Operating System, it would be 'NT AUTHORITY\SERVICIO DE RED', while on a French Operating System, it would be 'AUTORITE NT\SERVICE RÉSEAU'. Contact Data Applied if you're unsure.

FAQ  FAQ

Info Where are the Data Applied Web binaries?
Download the 64 bit or 32 bit setup, unzip to your local drive, and start crunching data!

Info Where are the MySQL, MySQL ODBC 5.1 Driver, SQLServer, or SQLExpress binaries?
Because these third-party products are frequently revised, we do not provide download links, and recommend a Web search to locate them.

Info I've heard there is also a Data Applied Service, but what is it for?

Data Applied Web:

  • Is a required Web site component which runs within IIS, and is responsible for processing HTTP requests sent by clients. Optionally, it can also be configured to process long-running background analysis tasks (this capability is enabled by default).

Data Applied Service:

  • Is an optional Windows service which does not integrate with IIS, and therefore does not process any HTTP requests sent by clients. Instead, it is entirely dedicated to processing long-running background analysis tasks.

Installing a single Data Applied Web instance (as described above) is your best bet. It is able to process both HTTP requests and background tasks. In a complex implementation however, multiple Data Applied Web and Service instances may be deployed to enable load-balancing and distributed computing. Contact us if you want to install Data Applied Service.

Info How do I enable back-end distributed computing?
The goal of back-end distributed computing is to process background analysis tasks more efficiently. To enable back-end distributed computing, you should install Data Applied Service on multiple back-end computers. Data Applied Service does not require IIS, and is entirely dedicated to processing background tasks. All deployed Data Applied Service instances should be directed to the same SQL database.

Info How do I enable front-end load balancing?
The goal of front-end load balancing is to process HTTP requests more efficiently. To enable front-end load balancing, you should install Data Applied Web on multiple front-end computers. Data Applied Web integrates with IIS to process HTTP requests received from clients. All deployed Data Applied Web instances should be directed to the same SQL database.

Info How do I prevent specific Data Applied Web instances from processing tasks?
After deploying multiple Data Applied Web instances, or one or more Data Applied Service instances, you may want to configure specific Data Applied Web instances to only process HTTP requests. You can instruct Data Applied Web instances to stop processing background tasks by setting the "JobAcceptWork" configuration option.

Info How do I optimize my MySQL database?
Here we assume that you selected the non-transactional MYISAM engine. Even selecting the "large instance" option during MySQL configuration results in poor SQL performance, because of very conservative defaults. Data Applied uses mostly reads, and many of these reads are repeat ones. Therefore, the single best parameter you can change is called query_cache_size. Allocating sufficient memory to this parameter allows MySQL to cache responses for frequent SQL SELECT requests. Please review MySQL documentation for more information. Also consider adjusting the key_buffer_size parameter to improve in-memory caching of table indexes.