HomeForum
Welcome, Guest

Improve Netezza support
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: Improve Netezza support

Improve Netezza support 1 year, 4 months ago #1019

  • eleavings
  • OFFLINE
  • Fresh Boarder
  • Posts: 1
  • Karma: 0
First, thanks for adding SQLite support into the portable version. Very helpful!

Something maybe you can improve would be the use of ODBC connections to Netezza databases.
We heavily use Netezza (www.netezza.com/) for it's abilities to process huge volumes of data very fast.
Making the connection work is fine using ODBC. When creating the ODBC System DSN using the Netezza-provided driver, you have to name the database you want as the default.
So when connecting with DB Browser, naturally the objects you see are the ones in the DB listed in the DSN.
However, the way Netezza works, even though you connect to one DB you can still see the other DBs on the appliance and switch to any of those without reconnecting.
So what would be ideal in DB Browser is to see the tree structure in the pane on the left with each DB and their objects inside their leaves so to speak.

Other products I've used similar to DB Browser are able to handle this scenario.
But I'd like to use this one and as it stands if I want to change DBs on Netezza, I need to close DB Portable, change the DSN in Windows, reconnect.

Thanks for the hard work on this product so far!

Re:Improve Netezza support 1 year, 4 months ago #1021

  • admin
  • OFFLINE
  • Moderator
  • Posts: 1931
  • Karma: 11
We will have a look at what can be done about it.
I think we can add a drop down box under the list of connections so users can choose the database or schema for SQL server, MySQL etc.

You said you have to modify you system dsn

There is another and better option.

DSN is just a connection string stored in the registry like OLE DB connection.

You can use Build Connection string to create odbc connection in this case the connection will not be stored in the registry but on your USB drive

So you can create several connections for different databases and store all of them on your drive

Mike
  • Page:
  • 1
Time to create page: 0.14 seconds

Testimonials

We tried many expensive software in our test environment but no one qualified.

C Gandhi
Nesa-Canada

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC


Databases we work with

Go to top