DbVisualizer 是專為開發人員和資料庫管理員開發的一個資料庫工具,有幫於開發和維護資料庫。DbVisualizer是一個完美的解決方案,她是跨平臺的資料庫工具,支援各種關係資料庫。
資料庫瀏覽器
通過所有資料庫對象的譜系導航。瀏覽對象的詳細信息和管理功能。
資料庫管理對象
可視化支援創建、改變和修改資料庫物件的圖表。支援編輯以及編譯程式的程序、功能、套件以及觸發器。廣泛的資料庫的具體支援
表格數據管理
支援編譯表格的數據,像二元制/ BLOB 以及CLOB數據類型。並且可以從檔案中導入。
SQL工具
SQL編輯器,可同時支援自動完成,參數化的SQL, SQL格式化,可視化查詢產生器,解釋計劃,導出結果設定。
資料庫伺服器管理
資料庫管理員的功能,例如資料庫伺服器的資料庫管理,存儲和安全參數。
Table Data Management
類似電子表格的表數據編輯器,包括二進制/ BLOB和CLOB數據類型,從CSV和Excel文件導入。
出口
將數據庫對象和表數據導出為CREATE / INSERT語句,CSV,XML等。支持導出大量的成果。
Key Features
Multi-database and cross-platform Database Management Tool
- Work with multiple database brands and perform many development and administration tasks from a single tool
- Easily explore your databases
- Automatic graphs of primary/foreign-key constraints
Visually create and manage the database
- Construct and manage database objects with ease
- Multiple object action executions
- Create, Compile and Run functions and procedures
- Object scripting
- Visually compare table and result set data
- Powerful data editing
Write and execute SQL scripts
- SQL IDE with syntax highlighting
- Auto completion
- Parameterized SQL execution
- Chart any result set in nice diagrams
- Tune your queries with integrated explain plans
- Query builder using drag and drop, no manual SQL required
- Visually compare SQL scripts
Data and database transfer
- Export table data in CSV, SQL, HTML, XML,Excel, JSON, Text
- Export all objects in the database including table data or all objects for a specific type
- Import table data from CSV files into existing table or create table from import data
General productivity
- Tasks are executed in background allowing for parallel operations
- Auto save of the workspace
- Resume where you left off with editors preserved between sessions
- Flexible workspace based on a tabbed interface supporting customized layout that is saved between sessions
- Tag DB objects and SQL script files as favorites for instant loads
Supported Databases
|
|
|
Extended support
Oracle
Oracle Autonomous Database is an all-in-one cloud database solution for data marts, data lakes, operational reporting, and batch data processing.
Version 8i - 21c validated
Extended support: DbVisualizer supports database-specific object types, functions and features.
MySQL
MySQL is an Oracle-backed open source relational database management system (RDBMS) very popular with web applications and online publishing.
Version 3.23, 4, 5, 8 validated
Extended support: DbVisualizer supports database-specific object types, functions and features.
PostgreSQL
PostgreSQL also known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance.
Version 8+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.
Microsoft SQL Server
Microsoft SQL Server is a industry standard relational database management system (RDBMS) used in a wide variety of BI and analytics applications.
Version 2000+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.
ClickHouse
ClickHouse is a fast open-source column-oriented database management system that allows generating analytical data reports in real-time using SQL queries.
Extended support: DbVisualizer supports database-specific object types, functions and features.
SQLite
SQLite implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine.
Version 3.6+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.
MongoDB
MongoDB is a cross-platform document-oriented and NoSQL database.
Version 5.0 validated
Extended support: DbVisualizer supports database-specific object types, functions and features.
Cassandra
Apache Cassandra is an open source NoSQL distributed database trusted by thousands of companies for scalability and high availability.
Version 4.x+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.
Google BigQuery
BigQuery is a fully-managed, serverless data warehouse that enables scalable analysis over petabytes of data. It is a Platform as a Service (PaaS) that supports querying using ANSI SQL.
Extended support: DbVisualizer supports database-specific object types, functions and features.
Microsoft Access
Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational Access Database Engine (ACE) with a graphical user interface and software-development tools.
Extended support: DbVisualizer supports database-specific object types, functions and features.
Oracle Cloud
Oracle Autonomous Database is an all-in-one cloud database solution for data marts, data lakes, operational reporting, and batch data processing.
Version 8i - 21c validated
Extended support: DbVisualizer supports database-specific object types, functions and features.
Azure SQL Database
Azure SQL Database is a SQL Server database engine, based on the latest stable Enterprise Edition of SQL Server and fully managed by Azure.
Extended support: DbVisualizer supports database-specific object types, functions and features.
Db2
Db2, or Database 2, is a set of relational database products built and offered by IBM to store, analyze and retrieve data with maximum performance.
Version 8.2+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.
Derby
Apache Derby is a rdbms developed by the Apache Software Foundation focusing on easy installation and usage with a minimal disk-space footprint.
Version 10.2+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.
Elasticsearch
Elasticsearch is the world’s leading free and open search and analytics solution with an emphasis on speed and scalability.
Version 7.15+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.
Exasol
Exasol is a high-performance, in-memory, MPP database specifically designed for analytics of large data sets in real time.
Version 6.0+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.
Greenplum
Greenplum Database (GPDB) is an advanced, fully featured, open source data warehouse, based on PostgreSQL.
Version 6.13.0+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.
H2
H2 is a open source rdbms that can be embedded in Java applications or run in client-server mode.
Version 1.3 - 1.4, 2.x+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.
IBM Db2 on Cloud
IBM Db2 on Cloud is a fully managed SQL cloud database with point-in-time recovery and high-availability disaster recovery (HADR).
Extended support: DbVisualizer supports database-specific object types, functions and features.
Informix
IBM Informix is an embeddable, high-performance database for integrating SQL, NoSQL, JSON, time-series and spatial data that's designed for analytics int the cloud.
Version 9+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.
MariaDB
MariaDB is an open source relational database management system (DBMS) that is a compatible drop-in replacement for the widely used MySQL.
Version 10.4+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.
Mimer SQL
Mimer SQL is a high performance database engine, targeted at mission-critical client/server environments while offering scaleable performance on multiple plattforms.
Version 9.1 - 11 validated
Extended support: DbVisualizer supports database-specific object types, functions and features.
MySQL Cloud
MySQL is an Oracle-backed open source relational database management system (RDBMS) very popular with web applications and online publishing.
Version 3.23, 4, 5, 8 validated
Extended support: DbVisualizer supports database-specific object types, functions and features.
Netezza
IBM Netezza is a powerful and highly parallelized Data Warehousing system that is simple to administer and to maintain.
Version 7.2+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.
NuoDB
NuoDB is an SQL-oriented transactional database management system (DBMS) designed for distributed deployment in the cloud.
Version 2.0.4 - 4.3 validated
Extended support: DbVisualizer supports database-specific object types, functions and features.
Presto
Presto is a distributed query engine for big data using the SQL query language.
Version 0.270+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.
Redshift
Redshift is a data warehouse product which forms part of the larger cloud-computing platform Amazon Web Services.
Version 1.0.7804+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.
SAP ASE
SAP ASE is a relational model database server developed by Sybase Corporation.
Version 12.5+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.
Snowflake
The Snowflake Cloud Data Platform includes a pure cloud, SQL data warehouse.
Version 3.56+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.
Trino
Trino is an ANSI SQL compliant query engine, that works with a wide variety of BI tools.
Version 360+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.
Vertica
Vertica is a columnar data storage platform designed to handle large volumes of data, which enables very fast query performance in traditionally intensive scenarios.
Version 6.1.3+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.
Yellowbrick
Yellowbrick Data Warehouse is an advanced, massively parallel processing (MPP) SQL database designed for batch, real-time, ad hoc, and mixed workloads.
Version 4.1+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.
SingleStore
SingleStore (formerly MemSQL) is a cloud-native database designed for data-intensive applications. A distributed, relational, SQL database management system (RDBMS) that features ANSI SQL support.
Version 7.6+ validated
Extended support: DbVisualizer supports database-specific object types, functions and features.
Basic support
Hive
Apache Hive is a distributed, fault-tolerant data warehouse system that enables analytics at a massive scale.
Basic support: Users have validated that they can use DbVisualizer to work with the database.
Solr
Solr is a fast, open source enterprise search platform built on Apache Lucene™
Basic support: Users have validated that they can use DbVisualizer to work with the database.
Salesforce.com
The Salesforce Database is powered by Oracle. There are a number of languages that are used for the Salesforce Database including SQL.
Basic support: Users have validated that they can use DbVisualizer to work with the database.
Firebird
Firebird is an open-source SQL relational database management system that runs on Linux, Microsoft Windows, macOS and several Unix platforms.
Basic support: Users have validated that they can use DbVisualizer to work with the database.
Teradata
Teradata is a Relational Database Management System (RDBMS) suitable for large data warehousing applications.
Basic support: Users have validated that they can use DbVisualizer to work with the database.
CrateDB
CrateDB is a open-source distributed SQL database management system that integrates a fully searchable document-oriented data store.
Basic support: Users have validated that they can use DbVisualizer to work with the database.
HSQLDB
HSQLDB (HyperSQL DataBase) is a SQL relational database system written in Java. It offers a small, fast multithreaded and transactional database.
Version 1.7+ validated
Basic support: Users have validated that they can use DbVisualizer to work with the database.
InterSystems IRIS
Iris is an object-oriented database management system being developed at Hewlett-Packard Laboratories.
Basic support: Users have validated that they can use DbVisualizer to work with the database.
MaxDB
MaxDB is a heavy-duty, SAP-certified open source database that offers high availability, scalability and a comprehensive feature set.
Basic support: Users have validated that they can use DbVisualizer to work with the database.
Actian X (Ingres)
Actian X is a combination of Ingres transactional and Vector analytic databases, integration and a monitoring tool.
Basic support: Users have validated that they can use DbVisualizer to work with the database.
CData Software JDBC Drivers
Easy-to-use JDBC Drivers with powerful Enterprise-level features. Connect JDBC with Salesforce, NetSuite, SharePoint, Secure File Transfer, and more.
Basic support: Users have validated that they can use DbVisualizer to work with the database.
DataDirect's Autonomous REST Connector
Progress DataDirect Autonomous REST Connector is an intelligent, customizable data connectivity solution enabling build and deploy of data connectors without coding.
Basic support: Users have validated that they can use DbVisualizer to work with the database.
FrontBase
FrontBase is a relational database management system written in ANSI C to be scalable and fast.
Version 4+ validated
Basic support: Users have validated that they can use DbVisualizer to work with the database.
HPE NonStop SQL
NonStop SQL is a relational database management system designed for fault tolerance and scalability, offered by HP.
Basic support: Users have validated that they can use DbVisualizer to work with the database.
IBM Db2 iSeries
IBM Db2 is a family of data management products, including the Db2 relational database.
Basic support: Users have validated that they can use DbVisualizer to work with the database.
IBM Db2 z/OS
IBM Db2 for z/OS is a relational database management system that runs on the mainframe.
Basic support: Users have validated that they can use DbVisualizer to work with the database.
IBM IMS
IBM IMS is a hierarchical database management software system for online transaction processing (OLTP) and online batch processing.
Basic support: Users have validated that they can use DbVisualizer to work with the database.
JDBC Drivers for CSV, XML, dBase, MS Access
JDBC driver from Sesame Software for connecting to CSV, XML, dBase and MS Access.
Basic support: Users have validated that they can use DbVisualizer to work with the database.
Pervasive
Pervasive PSQL is a relational database developed by Pervasive Software mostly used as embedded database.
Version 9+ validated
Basic support: Users have validated that they can use DbVisualizer to work with the database.
Progress
Progress OpenEdge RDBMS supports modern, mission-critical, business applications developed using the OpenEdge application development platform.
Basic support: Users have validated that they can use DbVisualizer to work with the database.
SAP IQ (Sybase IQ)
SAP IQ is a column-based, petabyte scale, relational database software system used for BI, data warehousing, and data marts. Replaced by Yellowbrick.
Basic support: Users have validated that they can use DbVisualizer to work with the database.
SAP SQL Anywhere (Sybase SQL Anywhere)
SAP SQL Anywhere is a proprietary relational database management system (RDBMS) product from SAP.
Version 11+ validated
Basic support: Users have validated that they can use DbVisualizer to work with the database.
/* SYSTEM REQUIREMENTS */
OS Support:
Windows 64-bit 11/10/8/7
Windows ARM64 11
Linux
macOS 10.11+
Windows: Java 17 is required
macOS: Java 17 is required
Linux: Java 17 is required