A database is a structured and organized collection of data which can be accessed, managed and updated. Databases are widely used in business to store information.

Obviously AI allows you to connect your databases so that you can make predictions directly on the data present in the database.

We support the following Databases:

MYSQL
PostgreSQL
SQL Server

Connecting MySQL Database

Click on Add Dataset option on the sidebar.



This will open the Dataset tab which has the options to choose the source of the Data.Click on the dropdown in the Source menu and select MySQL.





Next, you need to enter your database credentials including hostname, username and password.



You will have the option to Use the SSH Tunnel.Also, note that you must use a whitelist IP address.



Choose the Database schema and input the Port number. The default port is 3306. Finally click on Connect Database.



Connecting PostgreSQL

Click on Add Dataset option on the sidebar.



This will open the Dataset tab, which has the options to choose the source of the Data. Click on the dropdown in the Source menu and select PostgreSQL.



Finally, enter you credentials, port number, database schema name and click on Connect Database.



Connecting SQL Server

Click on Add Dataset option on the sidebar.



This will open the Dataset tab which has the options to choose the source of the Data. Click on the dropdown in the Source menu and select SQL Server.



Finally Enter you credentials, port number, Database schema name and click on Connect Database.



If you're experiencing issues connecting your database, tap the link below.

Contact Support
Was this article helpful?
Cancel
Thank you!