Oracle SQLDeveloper is exclusively create to connect to Oracle database using either ojdbc driver or oracle instant client. But SQL Developer also provide utility to connect to non oracle database using Third party jdbc driver.
In my limitation of knowledge I have connected to databases like DB2, SQL Server, Sysbase and MySQL.
In this post I will not show how to connect ot individual database but as whole the steps to connect to third party database.
Select Tools from the main menu and select Preferences. From the preferences window expand the database node from the left pane. From there select Third Party jdbc driver and a list box will be found with a label Third-Party driver path.
On the bottom you will find an Add Entry button, click on the button to add new third party jdbc driver. Browse your PC to find the jdbc driver with extension .jar. Click on Ok after you see the entry ofvthe jdbc driver along with it's path into the listbox. Click on Ok.
Suppose you add jdbc driver sqljdbc6.jar to connect to SQL Server database. You will find a tab right left to the Oracle tab. Make your connection entry under the tab and click on connect.
In my later post I will come up with more on this as how to connect to different databases using jdbc driver and link to find such jdbc drivers.
In my limitation of knowledge I have connected to databases like DB2, SQL Server, Sysbase and MySQL.
In this post I will not show how to connect ot individual database but as whole the steps to connect to third party database.
Select Tools from the main menu and select Preferences. From the preferences window expand the database node from the left pane. From there select Third Party jdbc driver and a list box will be found with a label Third-Party driver path.
On the bottom you will find an Add Entry button, click on the button to add new third party jdbc driver. Browse your PC to find the jdbc driver with extension .jar. Click on Ok after you see the entry ofvthe jdbc driver along with it's path into the listbox. Click on Ok.
Suppose you add jdbc driver sqljdbc6.jar to connect to SQL Server database. You will find a tab right left to the Oracle tab. Make your connection entry under the tab and click on connect.
In my later post I will come up with more on this as how to connect to different databases using jdbc driver and link to find such jdbc drivers.
No comments:
Post a Comment