Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

No Vmart schema in dbvisualizer

Hey, i have a question concerning vertica and dbvisualizer.

For beginning, defined the vmart schema and imported the example data.

 

Now i wanted to have a look on the different tables with dbvisualizer but the schema table is not showing.

I connected the dbvisualizer via jdbc driver. I installed the jdbc package from the oracle site.

The server is 127.0.0.1 and the default port is 5433 and i was able to ping and connect to it

 

 

Why i am not able to see the data in the tables?

 

Please help me!

 

Kind regards and thanks in advance

Karim

Comments

  • When connecting with DBVisualizer are you using a USERID that has the required permissions to access VMart schema and objects (tables/views) ?

     

    Can you login with vql using the same credentials and \dt on VMart chema, please?

     

    Regards,

    Sudhakar

  • Hey,

     

    thanks for the answer.

    But i think thats not the solution :(

    I was able to login into the admintools via vsql commands and make queries.

    The user is dbadmin.

     

    Thanks in advance

     

    Kind regards

    Karim

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.