互換性

Aqua Data Studio is compatible with various containers, platforms, and products, making it a versatile tool for database management and development. Here's a shorter breakdown of its compatibility:

Container Technologies

• Docker: Supports databases in Docker containers (e.g., MySQL, PostgreSQL, MongoDB, SQL Server).
• Kubernetes: Connects to databases running in Kubernetes clusters.
• Virtual Machines: Works in VMware, Hyper-V, and other virtualized environments.

Add-Ins and Integrations

• Version Control: Git, SVN for managing database scripts.
• BI tools: Supports query development and optimization for Tableau and Power BI.
• ER Modeling: Supports ERX file format for use with third party ER modeling tools.
• Cloud Databases: Supports AWS RDS, Google Cloud SQL, Azure SQL Database for cloud database management.
• DevOps & CI/CD: Works with CI/CD tools like Jenkins, Azure DevOps, and GitHub with version-controlled database processes.
• Authentication & Security: Supports LDAP and Active Directory for user authentication and access control.

Supported Programming Environments

• SQL: Full support for SQL scripting and query execution.
• Scripting Languages: JavaScript, for automation and MapR.

Cloud Database Services

• AWS RDS, Google Cloud SQL, Azure SQL Database: Aqua Data Studio can manage databases hosted on these cloud platforms.
• Amazon Redshift, Google BigQuery, HPE Ezmeral Data Fabric (formerly MapR): Integration for cloud data warehousing and querying.

Supported Databases

• Relational: Oracle, SQL Server, MySQL, PostgreSQL, MariaDB, DB2, Redshift, BigQuery, Snowflake, SAP HANA, Greenplum, Sybase ASE.
• NoSQL: MongoDB, Cassandra.
• Excel - Register Excel as a data source for sequel execution - also supported as an export format.

Data Formats and Tools

• Import/Export: Supports CSV, Excel, JSON, XML, and SQL formats.
• Data Visualization: Built-in and external BI tool integration for creating reports.
• Aqua Data Studio provides robust support for containers, cloud environments, databases, and third-party tools, making it a flexible solution for database management and development.