Databases

Overview

fastn gives users the ability to either connect their flows to their externally managed databases or to the fastn DB available on the platform.

How to connect to an External DB

• Connections to external databases can be added into flows using database connectors.

• Database connectors can be added when building a flow using the connector flow element and selecting the database option, or by navigating to the Databases page using the left side menu and adding a new database.

• When adding a new database connection you can select what type of database to link to from amongst the available options.

• Provide the necessary configuration details to connect to your database and save.

How to connect to the fastn DB

• Connections to the fastn database can be added into flows using the database flow element.

• Database elements can be added when building a flow and configured with an SQL query to perform database operations.

• Since database flow elements allow users to add SQL queries they can be used to create tables.

• An alternative way of creating a table in the fastn DB is to navigate to Databases page from the left side menu and then click on the fastn DB.

• Click on the create table button here to create a new table in the database.

• Next you can define the table structure by specifying the name of the table and defining its columns. Once you have entered all the necessary details, you can save the table configuration and see it added in the database.