Database Connector v2.1.1

Overview

FortiSOAR™ provides you with a number of pre-installed connectors or built-ins, such as the Utilities or Database connectors that you can use within FortiSOAR™ playbooks, as a connector step, and perform automated operations. These connectors are bundled and named based on the type of operations the connectors can perform. For example, the Database connector would contain actions that you can perform with respect to the database like querying the database. It is easy to extend and enhance these connectors.

Apart from the FortiSOAR™ Built-in connectors, Fortinet also provides a number of connectors for popular integrations like SIEMs, such as FortiSIEM, Splunk, etc., and Ticketing systems such as Jira. You can see a list of published connectors on the FortiSOAR Connectors Documentation site.

The process of installing, configuring, and using connectors is defined in the Introduction to connectors chapter in the "Connectors Guide", which is part of the FortiSOAR™ documentation or see the Installing a connector and Configuring a connector articles.

FortiSOAR™ Built-in connectors are upgraded by default with a FortiSOAR™ upgrade. Use the Content Hub to upgrade your connectors to the latest version. For more information on the connector store, see the Introduction to connectors chapter and see the FortiSOAR Built-in connectors article.

Important: Before you upgrade your FortiSOAR™ version, it is highly recommended that you take a backup of your FortiSOAR™ Built-in connector's (SSH, IMAP, Database, etc.) configuration since the configuration of your FortiSOAR™ Built-in connectors might be reset if there are changes to the configuration parameters across versions.

Database

Use this connector to connect to a database and then query the database and retrieve data. You can connect to multiple databases by setting up multiple configurations.

Note: If you have externalized your PostgreSQL Database, then you will require to update the host information and the credentials in the database connector configuration page, based on the credentials that you have specified for your externalized PostgreSQL database. For more information on the externalization of the PostgreSQL Database, see the Externalization of your FortiSOAR™ PostgreSQL database chapter in the "Administration Guide", which is part of the FortiSOAR™ documentation

Database Connector Release Notes

Version 2.1.1

• Fixed the issue of Python dependency now the database connector will require only a specific version of the Python library, which is pymssql==2.1.4. The connector logo has also been updated in version 2.1.1 of the Database connector.

Version 2.1.0

• Fixed the issue of Python dependency issues occurring while working with the database connector.

Version 2.0.2

• Fixed the issue of update and insert queries. Now, the update and insert queries, updates, or inserts a table in the database appropriately. It also contains an enhanced logo for the "Database" connector.

Version 2.0.1

• Enhanced the Database Connector's configuration parameter "Engine", to a drop-down list containing the valid options, which are postgresql, mssql, and mysql. Earlier it was a text field, and therefore it was possible that an invalid option could be entered in this field.