While building our data integration product line, one of the things that we noticed
we did over and over again was query a database to make sure all data was
copied and transformed correctly. This meant having to open up each vendor's
(often confusing) query tool and deal with their respective idiosyncrasies.
To speed things up, we built our own query tool that could be used to query data
from all of the database vendors we support.
Database Browser
Centerprise comes standard with this fully functional database query tool.
You can interface directly with a database by using the "Database Browser" dockable
window. From this window, you can export, import, view table data, view a
table's schema, or open a new query to write as you wish. Best of all, you
can do all of this for each database vendor we support. You can query both your source and destination databases right from one tool!
Click image to view a demo