Create Public or Private projects, invite members and begin collaborating ..Read more
Write and Execute Queries in the Query tab, then include them in scheduled AquaScripts ..Read more
Write simple AquaScripts to perform advanced ETL tasks and generate Reports and Charts ..Read more
Connects to all of your databases: Oracle, SQL Server, DB2, Sybase, MySQL, ParAccel, nCluster and many more ..Read more
Incorporate custom User Files for use in AquaScript inputs, outputs and reporting ..Read more
Schedule your AquaScripts to run whenever you likeRead more
Integrated social collaborative tools with a complete range of Data Warehousing, ETL and Reporting Applications to ensure that organizations achieve maximum productivity and deliver high quality products.
Projects allow you to manage your team and organize your reporting workflows into Workspace, Query, AquaScripts, Servers, User Files and Scheduled Jobs.
You can create and organize Private and Public Projects from the new enhanced home page. All data in a private project is private and you control who can see what. All data in a Public project is viewable by anyone.
Write an AquaScript and select its output to be executed and displayed in the Workspace tab of a project. You can choose the output of any of your AquaScripts to be displayed from the Project Settings options.
A project contains a set of AquaScripts, Servers and User Files. AquaScripts contain the source code and logic of the software solution, servers are registration parameters for database servers and User Files are a set of files which are used by the logic of the software solution for configuration or file output. Within the project, jobs may be scheduled for executing AquaScripts at defined intervals. Each project has a defined set of users, roles and permissions to control the access of the software logic.
A Project Owner is the person who created the project and has full privileges to manage the project. Project Owners can transfer ownership to any other member in the project. Server Admins can assign the Project Owner role to existing users so they can access the "New Public Project" and "New Private Project" buttons.
Project Owner will invite other users to his project. Project Owner can assign team members different roles in the project - Developer, Project Administrator, QA Engineer, Technical Writer and User.
After the installation, an Aqua Data Server Adminstrator creates your account and gives you a server role with appropriate permissions.
Login to Aqua Data Server, edit your profile, add a photo, experience, education and skills. Create your Project.
Add existing Aqua Data Server users to your project and assign them Project Roles like User, Developer, Administrator etc.
Write AquaScripts using Open API methods, create new server registrations, execute queries.
Import Projects, AquaScripts, Servers or User Files one at a time. Deploy an entire Project from Aqua Data Studio.
Schedule AquaScripts to automate your database and reporting tasks.
Communicate with Team Members in the Network Activity Feed. Add connections, share your current status and links.
Explore Public Projects, set AquaScripts for Project Workspace.
As part of developing your project solution, you might want to execute some database (DB) queries from your AquaScripts. The Query tab provides a convenient mechanism for ensuring proper DB connectivity and entering, editing and executing queries for debugging purposes.
Prior to using the Query tab, you must register your DB servers in the Servers tab.
When a query is executed, its results appear directly below the Query editing area within a grid layout.
Choose to view or hide syntax highlighting.
As you would expect from a text editor, you can perform Find, Find Next, Replace, Replace All and even use Regular Expressions for complex text replacement options.
Need more room to look at a larger query? Using the Full Screen mode you can have as much space as you need to examine your query.
Cursor Line and Character position get updated at the bottom of the query editor window as you type. The total number of lines and characters is also visible.
The AquaScripts Editor provides an easy interface to view and navigate your AquaScript code, make minor code modifications and enable limited script debugging.
AquaScript Editor provides three panes: “AquaScript” editor for entering and editing AquaScript code, the "Results" pane which shows output created from the aqua.response.write API (this is also what is shown in the project's workspace) and the “Console Output” pane which shows messages that are sent to the console - typically output of aqua.console API methods.
Create and Edit folders to organize your AquaScripts, move them wherever you need and search them to find what you are looking for. Expand and collapse the directory tree to see what's inside each folder.
If you have some .xjs files you've made in Aqua Data Studio, it's easy to import and edit them.
Quickly deploy just your AquaScripts from a Project in Aqua Data Studio into Aqua Data Server with just a few clicks, even if you have hundreds of .xjs files.
When viewing the AquaScripts tab, you get to see Creation and Update datetime, Creator and Owner, and File Size of all your files.
Add a description to go along with your filename to help explain what the script is for. This description is visible with a mouse hover over the script's name within the AquaScripts list.
The Register Server action allows you to register any server that is supported by Aqua Data Server. Aqua Data Server supports all databases that are supported by Aqua Data Studio and provides a nearly identical interface for server registration. Server registartion is specific to the type of database server selected, and the input fields vary depending on the database vendor and version chosen.
If you're familiar with Aqua Data Studio, then Registering a Server in Aqua Data Server will be a snap. The interface is nearly identical so it's very easy to navigate and enter database properties.
Create and Edit filters for your server connections.
Want ensure you connect via an SSL connection with PostgreSQL? The Server Driver tabs allows including Driver Parameters like "?ssl=true"
Once your server is registered, you can easily run a query on it through the Query tab.
Access to the Servers tab can be restricted so that only appropriate users can view or edit your database connections. Saved Passwords for Server connections are always encrypted and never visible to the end user.
The Servers list includes details about Server Name, Creation Date, Update Date, Creator and Owner so that changes can be monitored.
If you have an AquaScript that needs to access a file for input or output, import it to the User Files tab. AquaScripts that read Excel or Text files, display icons for buttons in your Workspace, or parse XML data can point to this location for what they need.
Just like the other areas of Aqua Data Server, you can create, expand and collapse folders, move and rename, or delete. Only file names can be edited in the User Files tab, file contents is not editable.
View a file's Creation and Update Date, Creator and Owner or check its file size in the User Files list.
It's possible to have an AquaScript generate a downloadable file (.xls, .txt, .csv, .html, .zip etc.) and store in the User Files tab so users can access it.
For ETL processing, your AquaScript can place exported database content in the User Files tab.
After you have developed production ready AquaScripts, you might want to execute some of them on a periodic basis or in a background thread. Aqua Data Server's scheduled job functionality is designed to address these requirements.
In a scheduled job, you specify the AquaScript to run and how often the AquaScript should be executed. Aqua Data Server's Scheduler engine automatically invokes the AquaScript at the designated time.
Any AquaScript can be scheduled to run precisely when you want it to. Want it to run every 3 seconds for the next month? No problem.
View a Scheduled Job's Next Run Date, Last Run Date, Execution Duration, Created Date and Updated Date from the Scheduled Jobs tab. The Scheduled Jobs list also displays who created and last edited the Job.
If you need to edit an AquaScript that's scheduled to run, simply pause the job or disable it while you or your coworkers work on it.
Set a job to only run once at some future date, or have it run daily for as long as you like.
The New Job button and the Edit Job action enable you to specify all Job related parameters for scheduling an AquaScript's execution.
Clicking the Execute action will immediately run the job in a background thread. Similar to a job that is invoked automatically, the job's execution history will be updated, and the job can be viewed in the Scheduled Jobs -> Jobs Detail page.
The new Network Activity feature helps you keep track of your connections' activities.
You can share your current "Status" and a URL with the entire community, so that everyone knows what you are working on at a given moment.
Tabs, Menus, Confirmations, Warnings and Error Messages in Aqua Data Server are translated into the supported 21 languages.
Set your preferred language to receive Email notifications.
If enabled, the only way to log in is via HTTPS. It's also possible to restrict logins to only private IP address ranges.
If your AquaScripts are designed to send email, the System Administrator's Email Queue tab handles the delivery process and gives you details on its status and SMTP Email Service settings. Pause, Stop and Restart the Email Queue as needed.
Password Policies control password complexity, minimum length, expiration, reset code expiration, password history and the use of "Forgot your password" links. If you enable the added security of captcha or ReCAPTCHA and Brute Force Login prevention mechanisms, you can protect Aqua Data Server from unauthorized attempts to access it.
System Administrators get a complete view of all Scheduled Jobs for all projects in Aqua Data Server. Scheduled and Running Jobs details can be examined, the jobs can be executed on demand and stopped if need be.
System Administrators get a complete list of all Projects (Private and Public) and can transfer project ownership easily from one user to another. They also have the ability to delete or edit projects, and they can export the projects list as a CSV, Excel or XML file.