![dbvisualizer wiki dbvisualizer wiki](http://3.bp.blogspot.com/-18tV76IWvlw/VDYz09n7uVI/AAAAAAAACW4/QKVUVDe-BgM/s1600/1.png)
You need to change the name of the service and possibly the port number based on the content of your tnsnames.ora file. Name: Whatever name you want to give to the connectionĭatabase Port: 1521 (see file tnsnames.ora) Now you can proceed as with PostgreSQL (see previous section), but instead of the PostgreSQL driver choose the "Oracle thin" driver. (ADDRESS = (PROTOCOL = TCP)( HOST = )( PORT = 1521)) Looking at the contenct of tnsnames.ora you will find the connection parameters: Obviously we are not interested in the sample. disk2/app/oracle/product/11.2.0/db_1/network/admin/samples/tnsnames.ora disk2/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora Find the connection configuration file tnsnames.ora and open it. If you need connections to different databases on the same PostgreSQL instance you can create additional connections.įirst of all you must search for some information, if you don't have it already. Notice that you must indicate a database. Environment: MS SQL Server, Oracle SQL Developer, HP ALM, JIRA, WIKI, Talend ETL. The additional items to enter should be straightforward. Databases: SQL Server 2012, SQL Server 2014, Oracle 11g, DbVisualizer. If necessary create a port forwarding ssh tunnel to the server where the DB is running.Īfter that click in the menu on database -> create database connection and choose the PostgreSQL driver. In order to do that, just right click on the icon and click "Lock to Launcher". If you are using the Unity Desktop, you may want to pin the icon in the launcher bar. Start the application: Open dash home and search for DbVisualizer. If you don't remember where you installed the application you may search for the startup script If you accepted the default value then this should be Note: The installation directory is the one you entered during the application setup.
![dbvisualizer wiki dbvisualizer wiki](https://i.ytimg.com/vi/XtS5tu2lP14/maxresdefault.jpg)
If this didn't happen, create the link yourself:
![dbvisualizer wiki dbvisualizer wiki](https://images.slideplayer.com/15/4703276/slides/slide_31.jpg)
Note: The installation process is supposed to generate a symlink in /usr/bin to access DbVisualizer from any location.
DBVISUALIZER WIKI INSTALL
Install DbVisualizer $ sudo apt-get install dbvis