Step 6Ĭhoose the database connection and click the OK button Step 7 Step 4Ĭlick the New button to create a connection to the Db2 database server. Click the Select button to choose the JDBC driver file and click the OK button to accept the JDBC driver. Click the Add Entry… button Step 3īrowse to the location that you store the JDBC driver file, in this case, it is db2jcc.jar under d:\software directory. Search for JDBC, you will find the Third Party JDBC Drivers under Database. Choose Tools > Preferences… menu item: Step 2 Launch SQL Developer and follow these steps: Step 1. Download PluginĬlick the following link to download the JDBC Db2 driver version:ĭownload JDBC DB2 driver Connect to Db2 Using SQL Developer Note that you need to create an Oracle account in case you don’t have one before you can download it. Download SQL DeveloperĬlick the following link to download the SQL Developer program. However, by using third party plugins, you can use SQL developer to work with other database systems such as MySQL, SQL Server, or IBM Db2. In the past, SQL Developer solely supported Oracle Database. SQL Developer is a free Database IDE that allows you to interact with databases using a graphical user interface instead of command-line tools like Db2 command line or Db2 command line plus.
DOWNLOAD SQL TABS HOW TO
Summary: in this tutorial, you will learn how to interact with Db2 database servers using the SQL Developer tool.