SQL Developer is built by Oracle, for Oracle. It’s the database IDE. That’s my current elevator pitch, at least. But, SQL Developer is also a fully featured data modeling solution (have you been enjoying my data modeling posts?) AND a 3rd party database migration platform.

The migration piece is the Migration Workbench. Since we support migrations from these other database platforms, wouldn’t it be neat if SQL Developer could connect and query those 3rd party databases too? Surprise, surprise – that’s exactly what we DO do today.

What ‘Support’ means

You can connect to, browse, and query (SELECTs only) SQL Server, DB2, Access, MySQL, and Teradata.

What ‘Support’ does NOT mean

  • providing debuggers
  • delivering database administration features
  • write access to the database

Sound a little harsh or spartan? Going much further in any of these areas would just open a big ole can of worms, and we’re committed to providing an optimal experience for the Oracle database. But, since we already support these limited features, there’s no real reason to hide it.

So what’s it good for outside of migration projects?

You own one of those fancy-dancy MacBook Pros? Fall in love with Ubuntu? Need browse some SQL Server data? You sir/madam, are what we call a rebel! Instead of installing a VirtualBox Windows VM just so you can run SQL Server Management Studio (SSMS) or some other Windows-based database IDE, you can run Oracle SQL Developer natively on your machine and connect to that server.

This is pretty old news – here’s a nice blog post from 2007 talking about how to use SQL Developer to connect to SQL Server. But since the product name is ‘Oracle SQL Developer’, it’s probably a good idea to remind folks every now and then that SQL Developer is more than just a tool for Oracle developers 🙂

Download and Go

You will need the JDBC drivers for the database you want to connect to. These are conveniently indexed here. Couple of notes –

  • You need to be a registered IBM customer to access their downloads
  • The Teradata download manager page seems to be ‘missing’ – go grab the driver here

Once you have extracted the packages, you need to point SQL Developer to the .jar file

Registering 3rd party JDBC drivers in SQL Developer

Be sure to point to the actual file, not just the directory containing the jar.

Once you’ve done this, you can open the connection dialog and navigate to the appropriate database panel.

Windows Authentication is mostly going to be tough from OSX, mostly
thatjeffsmith
Author

I'm a Master Product Manager at Oracle for Oracle SQL Developer. My mission is to help you and your company be more efficient with our database tools.

78 Comments

  1. Hi Jeff,
    I was able to Move a SQLServer Database to Oracle SQL Developer, I was wondering if there was a way to query two tables (one from oracle and one from SQLServer) in one database. any idea how i can create a DB link in oracle to queries both databases in one connection?

  2. What is the syntax of calling a DB2 stored procedure from SQL DEVELOPER, that has IN and OUT parameters?

    • thatjeffsmith

      No idea. We’re not a IDE for DB2. We’re an IDE for Oracle that you can use to move your DB2 objects/data over to Oracle.

  3. Marianne Fisher Reply

    Hi Jeff,
    Most helpful article and comments I’ve come across so far. I am trying to migrate an Access database (.accdb) and have downloaded various versions of SQL Developer but get stuck somewhere in the process with all of them. The last was sqldeveloper-4.0.0.13.80-x64. I can connect to the access databse in SQL Dev. When I do an online migrate, it stops at the Capture step – no databases in the source or destination. If I try offline (create database capture scripts), I cannot see Access in the platforms dropdown. Any suggestions welcome. Does the latest version of SQL Dev perhaps allow ms access migration?
    Thanks,
    Marianne

    • thatjeffsmith

      Best thing for you to do would be to select 1 or more Access tables in the tree, right click, and ‘Copy to Oracle.’

    • Marianne Fisher

      Thanks for the reply. I have done that successfully, but cannot do that with the views. Any suggestions?

    • thatjeffsmith

      Not a great chance – the jTDS driver does what we need it to for BOTH SQL Server and Sybase ASE

  4. Hi Jeff,

    Nice article. I especially love that Access tab right next to the Oracle tab in the connections dialog. I have been really surprised how well Oracle SQLDeveloper allowed me to leverage MS Access for any number of scenarios (migration and otherwise). Really very useful.

    Sadly, the Access tab doesn’t seem show up with JDK 8 and later lack of support for the JDBC-ODBC bridge.

    Any way we can get it back?

    • thatjeffsmith

      We’ve talked about just getting a proper jdbc driver for Access and bringing back the migration feature support for that ‘platform’ – but in the meantime, best to get an older copy of SQLDev (3.0) and use that to work with Access.

    • Get this back please. It is way to troublesome to do a second SQL Developer. My company needs this, because of all of our requirements.

      Thank you

Write A Comment