Aqua Data Server is a specialized application server designed to build and deploy production-quality, visually compelling database and reporting applications quickly and easily. Aqua Data Server help organizations simplify and lower the cost of their Business Intelligence and Data Warehousing environments by streamlining the development and 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.
The foundation of Aqua Data Server is AquaScripts — a JavaScript based programming language which uses Aqua Open API library methods. The framework includes a web server, an AquaScripts Editor, script scheduler and a security layer to define user access control, permissions and roles. Custom solutions built with Aqua Open APIs and AquaScripts are deployed in the form of Aqua Projects on the server.
ProjectsCreate Public or Private projects, invite members and begin collaborating |
QueryWrite and Execute Queries in the Query tab, then include them in scheduled AquaScripts |
AquaScriptsWrite complex AquaScripts to generate reports for others or perform advanced ETL tasks |
ServersConnects to Oracle, SQL Server, DB2, Sybase, MySQL, PostgreSQL and many more... |
User FilesAttach custom User Files for AquaScript inputs, outputs and reporting |
Scheduled JobsSchedule your AquaScripts to automate tasks |
BI ReportsGenerate BI Reports and Charts |
Aqua Data Server 2.0 expands traditional reporting workflows, data import/ export, querying capabilities with collaboration and social networking. Aqua Data Server 2.0 features a simple but powerful design for collaboration within an Organization and a universal framework for building custom functionality for your database applications. Aqua Open APIs, combined with an accelerated collaborative workflow, ensures that organizations achieve maximum productivity and deliver high quality products. You can Create Private and Public Projects, Create your profile, Add connections, Share status, links, Explore public projects, invite new members to your project, connect with your colleagues and grow your developer network. Aqua Data Server includes enterprise role-based security ready for deployment with any new database project right out of the box.
Share your work status that Team Members can then reference, making it much easier for users to interact and capture valuable insights. Aqua Data Server v2.0 provides an excellent workspace to support how users think and work. It delivers the complete range of Data Warehousing, ETL and Reporting Applications.
Aqua Data Server users can choose to make some or all of their profile information available to the Public. Learn more »
You can add connections and grow your social network. Connections are displayed in the user profile page. Learn more »
Users can share their current "Status" and a URL with the entire community, so that everyone knows what they are working on at a given moment. Team Members in a project can communicate by sharing Statuses. Learn more »
Every item in the Network Activity Stream can be Liked or Commented on. Learn more »
Aqua Data Server user home page is enhanced with many features. Learn more »
The Scheduler now supports occurrence of  scripts to be executed every 1 second. Learn more »
Users can browse the entire repository of Public projects. The projects are conveniently categorized. Learn more »