Below steps are used to connect to various databases using Oracle SQL Developer.
- Install Oracle SQL Developer from the Oracle website here
- By default, it can be able to connect with Oracle database. So no explanation needed.
- Before connect to databases, need to configure the drivers for the databases into the Oracle SQL Developer.
- Go to Tools > Preferences > Third party JDBC drivers, configure all the drivers here.
- For Microsoft SQL Server, follow below steps to configure.
- Download jtds jar file from here
- In SQL Developer, Add entry in the above mentioned page Third party JDBC drivers.
- Give all credentials in the SQLServer tab and click the Retrieve database which is like in this image
- For MySQL, follow below steps to configure.
- Download MySQL connector from here
- In SQL Developer, Add entry in the above mentioned page Third party JDBC drivers.
- Give all credentials in the MySQL tab and click the Retrieve database which is like in this image
- For PostgreSQL, follow below steps.
- Download PostgreSQL connector from here
- In SQL Developer, Add entry in the above mentioned page Third party JDBC drivers.
- For selecting the database, use host name as like shown in this image, here test is a database name
Comments
Post a Comment