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!
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!
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
What does "The installer was interrupted before Data Applied Web could be installed."
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.
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.
What does "Cannot open database "DataApplied" requested by the login. The login failed."
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).
What does "The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local
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.
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">.
Why do I get "Access Denied" errors when trying to save changes made to a Data Applied
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.
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.
Where are the Data Applied Web binaries?
Download the 64 bit
or 32 bit setup,
unzip to your local drive, and start crunching data!
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.
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
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.
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.
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.
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"
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.