Skip to content

Flowtrail AI Datasource

Flowtrail AI datasources are the basis of your reporting and analytics workflows. Adding a datasource is the first step to accessing and analyzing your data. We are now offering MySQL, PostgreSQL, MSSQL support in Flowtrail AI, and we will be adding more options in the near future. By following the steps outlined here, you’ll be able to connect your database to Flowtrail AI, allowing you to generate reports and visualizations effortlessly.

datsource-list

Add new datasource

It is easy to create a datasource in Flowtrail AI. You have to follow these steps in order to create a successful datasource.

Click on the “Add New Datasource” Button

Begin by clicking on the “Add New Datasource” button from the main Datasources section. You will be navigated to the Datasource form where you can select the type of source and input the necessary details.

datsource-add-new-btn

Select the Source Type

Choose the type of database you want to connect. Flowtrail AI now supports Mysql, MSSQL and Mysql. We are working on the more datbases including SQL and NoSQL databases.

datasource-type

Fill in the Connection Details

Enter the required connection details such as host, port, username, password, and database name. Ensure the details are correct to avoid any connection issues.

datasource-form

Test the Connection

Click the “Test Connection” button to ensure your database details are accurate and that Flowtrail AI can establish a secure and reliable connection to your database server. This step confirms connectivity, ensuring you can proceed confidently with data retrieval and analysis.

test-connection

Save the Datasource

Once the connection test is successful, click the “Save” button to securely store your datasource details in Flowtrail AI. Saving confirms that your database connection is set up and ready for generating reports and visualizations effortlessly. This step completes the setup, enabling you to start analyzing your data right away

Troubleshooting and Additional Help

If you have more questions about the datasource connection or encounter any issues, please visit our FAQ section or email us for support.