DBeaver supports more than 80 databases.
With this features, DBeaver offers users the option to connect to varieties of database drivers.
The database drivers come in various supported types such as relational, analytics, document-oriented, cloud, bigdata / Hadoop, key value, time series and much more.
The following are the overview of several DBeaver Enterprise databases support :
Database type: Document oriented
Overview
DBeaver Enterprise edition supports MongoDB features include:
- Schema browser
- Data viewer
- SQL queries execution
- JavaScript queries execution
- Administrative tools such as server sessions manager
DBeaver supports MongoDB servers from 2.x to 4.x since it utilises MongoDB Java driver to run with a server.
Connecting DBeaver to MongoDB server can be done directly to a server or either using SSH tunnel or SOCKS proxy.
InfluxDB
Database type: Time series
Overview
DBeaver Enterprise edition supports InfluxDB:
- Schema browser
- Data viewer
- InfluxQL queries execution
DBeaver supports InfluxDB servers of any version and utilises influxDB Java driver to run with a server over HTTP/HTTPS.
Connecting DBeaver to influx server can be done directly to a server or either using SSH tunnel or SOCKS proxy.
Database type: Key value
Overview
DBeaver Enterprise edition supports Cassandra:
- Schema browser
- Data viewer
- CQL queries execution
- Various administrative tool
DBeaver uses supports Cassandra servers from 2.x, 3.x or higher since it utilises Data Java driver to run with a server.
Connecting DBeaver to Cassandra servers can be done directly to a server or either using SSH tunnel or SOCKS proxy.
Redis
Database type: Key value
Overview
DBeaver Enterprise edition supports Redis:
- Key browser
- Key value viewer
- Redis commands shell
DBeaver supports Redis servers of any version and utilises Redis/Jedis driver 2.9.0 to run with Redis server.
Connecting DBeaver to Redis servers can be done directly to a server or either using SSH tunnel or SOCKS proxy.
AWS DynamoDB
Database type: Cloud
Overview
DBeaver Enterprise edition supports AWS dynamoDB:
- Table data view
- Table data edit in document (json) mode
- Data filters
- SQL queries execution
- JSON queries execution
- Data export and import
DBeaver supports both version of servers of Dynamo DB; AWS cloud and standalone.
To connect to standalone server, users need to enter endpoint (http or https URL) while for cloud server, users have to enter the AWS region.
The connection requires the use of AWS Access Key and Secret Key.
AWS DocumentDB
Database type: Cloud
Overview
Document DB is almost similar as the MongoDB engine where every features that work for mongoDB are applicable for Document DB.
DBeaver Enterprise edition supports DocumentDB include:
- Schema browser
- Data viewer
- SQL queries execution
- JavaScript queries execution
- Administrative tools such as server sessions manager
Users need to ensure that DBeaver is deployed on the EC2 instant to connect it directly to DocumentDB using the cluster host name since direct access for DocumentDB clusters from outside of the cloud are restricted by AWS.
Users can as well use the SSH tunnel through a proxy machine to access DocumentDB instance.
In other situation, users can use the SSH tab on the connection settings page in DBeaver by entering the proxy host, user name and specify a private key file.
Google Big Table
Database type: Cloud
Overview
DBeaver Enterprise edition supports Big Table:
- Table data view
- Table data edit in document (json) mode
- Data filters
- SQL queries execution
- Data export and import
For connection, the setting can be done as below.
Database type: Document oriented
Overview
The clients of Couchbase client utilise multiple ports to connect to a cluster for example 8091-8096, 9140 and etc. Certain ports are dynamic and do not allow to be overwritten such that connection via SSH tunnel is impossible. Therefore users are required to set up VPN connection or SOCKS proxy if they are working with a remote Couchbase deployed behind a firewall.
Apache hive
Database type: Big Data / Hadoop
Overview
Since hive applies Hadoop-based storage system, it utilises special SQL dialect (HiveQL) to run with data and metadata.
DBeaver uses Hive JDBC Uber Jar driver which includes every essential dependencies.
Other implementations of storage systems that use Hive on the server-side are Apache Spark and Apache Impala.
The connection set up is as in the diagrams below.
Create new connection > Select the connection > Generic JDBC connection settings
E-SPIN has been actively promoting DBeaver full range of products and technologies as part of the company Database Management Portfolio (from database platform management, performance monitoring, risk management, security monitoring to protection). E-SPIN is active in consulting, supplying, training and maintaining DBeaver products for the enterprise, government and military customers (or distribute and resell as part of the complete package) on the region E-SPIN do businesses. The enterprise ranges from corporate, universities, government agencies, medium to large corporations to IT service providers on data center, enterprise application management /operations.
Please feel free to contact E-SPIN for your inquiry and requirement, so we can assist you on the exact requirement in the packaged solutions that you may require for your operation or project needs.