

This will open the 'Create New Connection Profile' window. In the Connections tab, click the 'New Connection Profile' icon or right click anywhere inside the empty list and choose it. Once you have opened the SQL Explorer, you will need to add a new connection. You can start using it by selecting it in the Open Perspective list ( Window -> Open Perspective -> Other.). The SQL Explorer plugin should now be installed and available as a new perspective.


From within Eclipse, choose 'Help -> Software Updates -> Find and Install' from the menus.
#Setup jodbc r mac os x install
Here is how it's done: Download and Install Eclipse SQL Explorer Plugin
#Setup jodbc r mac os x update
You can download and manually install the plugin, but choose to use the built-in Eclipse Install and Update functionality to download and install the plugin. I assumed it would be as simple as downloading the plugin and creating the connection to my local MySQL database - but that didn't work. SQL Explorer is really nice, once you get it working. Since I do everything else from within Eclipse, moving outside the Eclipse window just to view tables/data in the database really interrupts my work-flow (not to mention the distractions that come with using a web browser 😉 ). Up until now I have been using phpMyAdmin through an external web browser to view/edit the MySQL database (Eclipse's built-in web browser sucks - I cannot even copy/paste from it!). I have a local LAMP (or in this case, MAMP) environment setup on my Mac for development purposes. There is a great plugin for Eclipse called SQL Explorer, which "is a thin SQL client that allows you to query and browse any JDBC compliant database".
