Header Ad Section

How to configure a new Data Source in IntelliJ IDEA

Introduction

create a database in mysql,create a database in excel,create a database in postgres,create a database,intellij plugins,intellij,intellij download,intellij idea ultimate,data source,data source settings power bi,data sources in research,data source company

So, Let's have look at how to configure a new data source in IntelliJ IDEA


❄️ For Example, I here describe how to create a new data source only for MySQL. But the flow of the configuration process is approximately identical. I hope that by examining this example you'd not get hard to configure for other Database types also.

To Configure a new Data Source in IntelliJ IDEA

1.  Open up your IntelliJ IDEA on your PC.


2. Then navigate to the Databases tab located in the Right corner of the IDE.

create a database in mysql,create a database in excel,create a database in postgres,create a database,intellij plugins,intellij,intellij download,intellij idea ultimate,data source,data source settings power bi,data sources in research,data source company


3. Then make sure that which database you want to configure and make sure that it already exists before start the configuration setup.  (Ex:- consider a database called supermarket)


4. Then again let's switch back to IntelliJ IDEA IDE. Locate and select on the + mark and click
    Data Source > MySQL.


5. Then you have to provide very basic information about your database such as database name, database port (to me MySQL default port: 3306), host (to me it's localhost). Once you have filled in all this information you can click Test Connection to confirm/check whether you've entered correct information about the database. After successful confirmation, it'll display a message with a green tick to indicate that you provided information is correct. Then click Apply and OK, then you will see a database on the database tab.


6. After completing the above step you will see already a new data source available on the database tab in the IDE. It'll display one out of all databases amount in front of the Database Name (Eg: - 1 of 6). Locate on that bale and point your cursor to it. So it'll display a tooltip saying 0 connections which means that your data source hasn't already had any connections established.


7. Then you can simply click on that label which indicating the no of databases (Eg:- 1 of 6) and select the current schema (Eg:- supermarket).


8. Now you have all done perfectly!. Finally, it looks like this. Enjoy coding with IntelliJ IDEA.



Keywords: create a database in mysql  create a database in excel  create a database in postgres  create a database  intellij plugins  java ideintellij  intellij idea  intellij download  intellij idea ultimate  data source  data source settings power bi  data sources in research  data source company

Post a Comment

0Comments