Connect to relational database via live mode

Created by Hirak Kocharee, Modified on Wed, 16 Oct, 2024 at 3:14 PM by Hirak Kocharee

The first thing to do before creating a report is to connect Grafieks to your SQL database or data warehouse, in case you have not already connected to your database before and saved it.


To access the data source configuration page:

1. Click on "Data Source" from the left-side menu and go to "All Data Source"   

2. Click on the "Create" button

Or

3. Click on the "Quick Add" button and then on "New Data Source".

4. From the right side pane, click on the "Relational Database" menu and then click on the required connector




5. Enter the database credentials and click on "Next".



Network ports for reference:

Adding a port number when adding database credentials is very important. The port numbers below can be referred to for your database connection.


Database

Port

Amazon Redshift5439
ClickHouse9440
MySQL3306
PostgreSQL5432




Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article