AquaFold, Inc. has introduced Aqua Data Server 1.0, the first release of a new product that helps organizations simplify and lower the cost of their Business Intelligence and Data Warehousing environments by streamlining the development and production deployment of ETL (Extract Transform Load) tasks, Data Migrations, Reporting, Dashboards and Form based web applications. Database Administrators, Software Developers, Data Analysts, Statisticians and Quality Assurance Engineers can centralize and automate various data processing tasks in a simple and unified product. Aqua Data Server is a flexible cross-DBMS and cross-platform application server, fully integrated with the universal desktop database administration tool, Aqua Data Studio.
Aqua Data Server provides a rich Open API for accessing, manipulating and visualizing data from many data sources. These APIs are accessible from scripts, known as AquaScripts, which may be easily deployed into projects within Aqua Data Server. The scripts use a simple JavaScript based programming language supported both in Aqua Data Server and Aqua Data Studio. AquaScripts deployed on Aqua Data Server can be executed by multiple users simultaneously, or scheduled for automatic execution with the Aqua Data Server scheduler. AquaScripts are grouped in the project areas of Aqua Data Server that provide login security access, drop in permissions, parameterized launch of AquaScripts and rich GUI features.
"Our users often face challenges dealing with the necessity of performing complex data mining and processing transactions on a recurrent basis or doing identical operations from multiple workplaces, which require running local copies of data mining tools for every user," explains AquaFold's Chief Software Architect, Niels Gron. "With Aqua Data Server, the data processing scripts deployed on the server can be executed by many users from a centralized location. Results will only be distributed to intended recipients in the form of emails, HTML reports or Excel spreadsheets."
Aqua Data Server, coupled with Aqua Data Studio, is a unique solution offering users an unprecedented combination of versatility, simplicity and scalability. Companies deploying Aqua Data Server will boost their efficiency and reduce costs by automating routine data management tasks with AquaScripts. The Open APIs behind the script engine allow users to query and modify multiple server connections from a single AquaScript, even when dealing with multiple relational database management systems from several vendors.
Aqua Data Server offers a full-fledged scripting environment based on JavaScript, making it easy for developers to get started without learning a new programming language. Users can edit and debug AquaScripts either locally in Aqua Data Studio or directly on Aqua Data Server within the browser based GUI. Like all Aqua Data Studio documents, scripts can be placed into a version control repository to allow for team collaboration in developing solutions. Once the scripts are created and tested, they can be deployed into production environments for access and execution by multiple corporate users.
Aqua Data Server works with Windows, Mac OS X and Linux on the Java 1.6 Platform. It is based on the Apache Tomcat application server and MySQL database for application metadata. The web-based interface is supported by all modern web browsers, including Internet Explorer, Firefox, Opera, Chrome and Safari web browsers. Aqua Data Server comes with native connectivity for all major DBMS servers: Aster nCluster, Apache Derby, DB2 LUW, DB2 iSeries, DB2 zOS, Informix, MS SQL Server, MySQL, Netezza, Oracle, PostgreSQL, Sybase ASE, Sybase IQ, Sybase Anywhere and Teradata. Other databases are supported through generic ODBC and JDBC drivers.
Aqua Data Server is available for immediate download at http://www.aquafold.com/aquadataserver_downloads.html. Aqua Data Server is licensed on the per-execution-thread principle. Pricing starts at $1500 USD for a Standard License. Volume discounts are also available and can be viewed at http://www.aquafold.com/store.html.
