2

From Linux (Red Hat dist), we need to read an AS400 database. We have the ODBC driver to connect, what's the best query tool?

Anthony C
  • 1,990
  • 3
  • 23
  • 40
  • Could you provide some more details into what you're trying to achieve? Hard to determine the "best" without knowing wether you're aiming for stability / portability / performance / etc. – Tim Jan 28 '09 at 22:09
  • Actually, best doesn't even need apply. I'm just looking for anything! Our company is interfacing with a third party system that runs on Linux. They need to be able to read our database from their system. Any Linux ODBC database tool would work. – Anthony C Jan 29 '09 at 01:38
  • Sorry, I don't have any more info. The best I can do is come up with an analogy: If I had a Windows PC and I needed to view a foreign computer database via ODBC, I'd use MS Access to link to it. What is the equivalent of MS Access on Linux? – Anthony C Jan 29 '09 at 02:20

2 Answers2

2

Kexi calls itself "Microsoft Access for Linux", and it's pretty good, but the ODBC driver isn't quite there yet.

A similar program is OpenOffice.org BASE. IMO, Kexi is a better overall product, but Base has an ODBC driver.

Lighter-weight graphical tools for databases with ODBC drivers include Datakiosk and Tora (which, despite its name, works with more than just Oracle).

What's "best"? Depends on your tastes and your needs. This is by no means an all-inclusive list.

ephemient
  • 198,619
  • 38
  • 280
  • 391
0

Eclipse and Quantum DB

Mike Wills
  • 20,959
  • 28
  • 93
  • 149