We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


No Vmart schema in dbvisualizer — Vertica Forum

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

  • Sudhakar_BSudhakar_B Vertica Customer ✭✭

    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