Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
With Aqua Data Studio Version 17.0 release, we now support SAP HANA, an in-memory database and application platform that can be deployed on premise or in the cloud (SAP HANA One, SAP HANA Cloud Platform, and SAP HANA Enterprise Cloud). SAP HANA gives you the ease of registering, connecting, querying and analyzing your big data to gain valuable insights. Create HANA Database objects - Schemas, Tables, Views, Functions and much more through Aqua Data Studio's highly streamlined Visual Editing UI. Our Import and Export tools, Query Builder, ER Modeler, Compare Tools, plus many other features are available for HANA. These functionalities let you take full advantage of the in-memory performance and high availability of SAP HANA. Our Visual Analytics is a powerful and interactive visualization tool that quickly creates insightful charts of your big data via a drag & drop interface.
We've brought all of our easy-to-use and feature rich database functionality to SAP HANA and if you are looking for a simple IDE to manage your big data, you'll feel right at home with Aqua Data Studio 17.0.
Explore your SAP HANA server's schema by using the Schema Browser. Schema Browser is a visual tree that shows the contents of all of your Schema Objects. Right click on an object to view its properties, create new objects, or alter existing ones.
Add SAP HANA tables and columns, modify table constraints, and create new schemas. Edit your table data using an Excel-like grid via Aqua Data Studio's Table Data Editor. Use Query Builder to create complex join statements without ever typing a line of SQL code and see what the SQL Aqua Data Studio is generating for you.
Script an SAP HANA object as CREATE, ALTER or DROP for Aqua Data Studio to generate a DDL. With the Schema Script Generator, you can either choose objects to script or script the complete content of a server.
View activity information about your SAP HANA deployment including the Process ID, User, Database, the status of Current Queries and more.
Maintain Security for your SAP HANA database through the Security component of the Schema Browser. Create, Alter, and Drop Users and Groups, by assigning and altering permissions.
Connect to SAP HANA and execute SQL queries effortlessly by using intelligent Autocomplete, SQL Abbreviations, and SQL Automation. Perform advanced analysis by using the built-in Pivot Grid and Charts, or one-click export to Excel feature.
Learn more
Quickly create SAP HANA Schemas, Tables, Views, Functions and much more through Aqua Data Studio's highly streamlined Visual Editing UI. Alter and Drop objects just as easily.
Learn more
Use powerful, Excel-like grid editing of your SAP HANA table data. Edit any result set and access features such as find/replace, copy, paste, delete, insert, alter, and copy rows with a single click. Preview the resulting SQL statements prior to executing them.
Learn more
Use our UI's built-in ETL functionality to import data, configure it to suit your needs, and export it in a different format. Use Aqua Data Studio's wizards to step by step import data into existing SAP HANA tables and exporting SAP HANA data based on your desired format.
Learn more
Script a complete SAP HANA database to file, including CREATE, DROP DDL, and INSERT DML without typing an SQL command. Save the generated scripts for later or share them with coworkers.
Learn more
Create and manage SAP HANA ER diagrams. From a simple reverse engineering of your existing database to designing a highly complex diagram involving thousands of entities, you can annotate, forward engineer, performs diffs, generate HTML reports and much more.
Learn more
Use Open APIs to create fully automated end-to-end solutions for your SAP HANA databases using JavaScript. Aqua Data Studio provides a full-fledged IDE with APIs to SAP HANA database access, schema DDL generation, Grid and Pivot Grid charts, version control, and much more.
Learn more
Generate beautiful charts and graphs from your SAP HANA database content. Choose from a variety of chart types and customize the way you want to visualize your data. Visual Analytics gives you a clear picture of what your data means.
Learn more
Generate beautiful charts and graphs from your SAP HANA database content. Choose from a variety of chart types and customize the way you want to visualize your data. Visual Analytics gives you a clear picture of what your data mean as it updates your charts in real time based on your query results. You can even pivot your data and create charts based on your pivoted data.
Learn more
Automate your database ETL tasks using FluidShell, which is an interactive shell that combines the power of an SQL command line with the versatility of a UNIX shell.
Learn more
Use the Schema Compare tool to determine the differences between SAP HANA Schema Objects, Databases, Functions, Packages, and more quickly. Generate HTML reports of the comparison results.
Learn more
After generating results from a query, use the Results Compare Tool to search, filter and sort differences. Generate and share HTML reports of the comparison results.
Learn more
Quickly and easily find Database Objects within your SAP HANA database server. Narrow your search by Schema and Object Type, and enter a text to find.
Learn more
Construct sophisticated database queries without writing a line of SQL. Use our UI to select tables and columns and leverage our rich set of visual options including JOINs, GROUP BYs, SORT ORDER, equality comparisons, and more.
Learn more
Automatically record and archive all queries that you run on SAP HANA servers, or store them in a centralized location for auditing purposes. View a history of all the SQL statements and scripts that have been executed within the Query Analyzer, Query Builder, and Table Data Editor. Execute a query from months or even years ago.
Learn more
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|