Connecting to Access, DB2, MySQL, SQL Server, Sybase, & Teradata with SQL Developer

thatjeffsmith SQL Developer 78 Comments

Tell Others About This Story:

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

Related Posts

Tell Others About This Story:

Comments 78

  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?

    1. thatjeffsmith Post
      Author
    1. thatjeffsmith Post
      Author
  2. 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

    1. thatjeffsmith Post
      Author
    2. Thanks for the reply. I have done that successfully, but cannot do that with the views. Any suggestions?

    1. thatjeffsmith Post
      Author
  3. 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?

    1. thatjeffsmith Post
      Author

      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.

    2. 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

    3. thatjeffsmith Post
      Author

Leave a Reply

Your email address will not be published. Required fields are marked *