Database Targets

You can define a database target to be used with Database Dynamic Secrets.

Available database targets:

  • MySQL

  • PostgreSQL

  • Redshift

  • MSSQL

  • MongoDB

  • Snowflake

  • Oracle

  • Cassandra

  • HanaDB

๐Ÿ‘

Tip

To create database target from Akeyless CLI choose the database type within the create-db-target command

In order to create database targets you can define the following fields on Akeyless Conole UI or using Akeyless CLI:

akeyless create-db-target
--db-type <Database type> # mysql/mssql/hanadb/postgres/mongodb/snowflake/oracle/cassandra/redshift
--user-name <Database user name>
--host <Database host>
--pwd  <Database password>
--port <Database port>

Depending on your Database type, please provide the relevant settings accordingly:

MySql

-Name: A unique name for the target. The name can include the path to the virtual folder in which you want to create the new target, using slash / separators. If the folder does not exist, it will be created together with the target.

DB Username - Privilege database user name with sufficient rights to create users.

DB Password- Password of the database privilege user name.

DB Hostname- Target database hostname or IP address.

DB Port- Target database port.

DB Name - Target database name.

Use SSL - To enable SSL,requires SSL certificate.

Advanced:

DB Server Certificate - Set of root certificate authorities in base64 encoding used by clients to verify server certificates.

DB Server Name - The server name is used to verify the hostname on the returned certificates unless InsecureSkipVerify is provided. It is also included in the client's handshake to support virtual hosting unless it is an IP address

PostgreSQL

Name: A unique name for the target. The name can include the path to the virtual folder in which you want to create the new target, using slash / separators. If the folder does not exist, it will be created together with the target.

DB Username - Privilege database user name with sufficient rights to create users.

DB Password- Password of the database privilege user name.

DB Hostname- Target database hostname or IP address.

DB Port- Target database port.

DB Name - Target database name.

MSSQL

Name: A unique name for the target. The name can include the path to the virtual folder in which you want to create the new target, using slash / separators. If the folder does not exist, it will be created together with the target.

DB Username - Privilege database user name with sufficient rights to create users.

DB Password- Password of the database privilege user name.

DB Hostname- Target database hostname or IP address.

DB Port- Target database port.

DB Name - Target database name.

Redshift

Name: A unique name for the target. The name can include the path to the virtual folder where you want to create the new target, using slash / separators. If the folder does not exist, it will be created together with the target.

DB Username - Privilege database user name with sufficient rights to create users.

DB Password- Password of the database privilege user name.

DB Hostname- Target database hostname or IP address.

DB Port- Target database port.

DB Name - Target database name.

SSL - Check to enable SSL.

Oracle

-Name: A unique name for the target. The name can include the path to the virtual folder in which you want to create the new target, using slash / separators. If the folder does not exist, it will be created together with the target.

DB Username - Privilege database user name with sufficient rights to create users.

DB Password- Password of the database privilege user name.

DB Hostname- Target database hostname or IP address.

DB Port- Target database port.

Service Name - Target database name.

MongoDB

Name: A unique name for the target. The name can include the path to the virtual folder in which you want to create the new target, using slash / separators. If the folder does not exist, it will be created together with the target.

DB Username - Privilege database user name with sufficient rights to create users.

DB Password- Password of the database privilege user name.

Host and Port- Target database hostname or IP address with port.

Advanced:

Default Authentication DBโ€‰- MongoDB default authentication database.

Options - URI options (e.g. replicaSet=mySet&authSource=authDB)

Mongo Atlas

Name: A unique name for the target. The name can include the path to the virtual folder in which you want to create the new target, using slash / separators. If the folder does not exist, it will be created together with the target.

DB Name - Target database name.

Project IDโ€‰- MongoDB Atlas project ID

API public keyโ€‰- MongoDB Atlas public key

API private keyโ€‰- MongoDB Atlas private key

Snowflake

Name: A unique name for the target. The name can include the path to the virtual folder in which you want to create the new target, using slash / separators. If the folder does not exist, it will be created together with the target.

Account Username - Username for a Snowflake user administrator (with the USERADMIN role or higher).

Account Password - Password for the Snowflake user administrator account.

DB Name - Target database name.

Account Name - Snowflake account name in xy12345.region.cloud_provider.snowflakecomputing.com format.

Cassandra

Name: A unique name for the target. The name can include the path to the virtual folder in which you want to create the new target, using slash / separators. If the folder does not exist, it will be created together with the target.

DB Username - Privilege database user name with sufficient rights to create users.

DB Password- Password of the database privilege user name.

DB Hostname- Target database hostname or IP address.

DB Port- Target database port.

DB Name - Target database name.

HanaDB

-Name: A unique name for the target. The name can include the path to the virtual folder in which you want to create the new target, using slash / separators. If the folder does not exist, it will be created together with the target.

DB Username - Privilege database user name with sufficient rights to create users.

DB Password- Password of the database privilege user name.

DB Hostname- Target database hostname or IP address.

DB Port- Target database port.

DB Name - Target database name.

Use SSL - To enable SSL,requires SSL certificate.

๐Ÿ“˜

Usage

akeyless create-db-target command includes all available databases target, please follow the relevant database section for the relevant fields.

The full list of options for database targets can be found here:

You can find the complete list of parameters for this command in the CLI Reference - Akeyless Database Targets section.


Did this page help you?