We are going to use out of Postgres also Hive and Graph engine, is it hard to support new database type, should we ask Support or should we do it on our own?
Thank you.
Ladislav
We are going to use out of Postgres also Hive and Graph engine, is it hard to support new database type, should we ask Support or should we do it on our own?
Thank you.
Ladislav
Any idea how to support new database DDL generation?
Thanks a lot, we need it on project.
Sorry for a late response, I’ve been absent and I think the VP team overlooked your initial question.
Just so I understand what you mean: you want to provide SQL support for another database engine?
Now, I quickly peeked at the Hive website and I noticed that they provide a JDBC driver. This means that, theoretically, you should be able to import that driver into Visual Paradigm. Note that I don’t have hands on experience with this myself, but:
You can find this dialog by opening the Tools pane and then opening the DB menu and selecting ‘database configuration’:
Hope this can help!
@ShelLuser - I didn’t test this solution yet, but another came to my head based on your answer here:
Scenario of automated DDL pipeline with support for Postgres and Hive:
Its not big deal, if you have any other idea let me know.
Thx for discussion.
Ladislav
For VP team - We are looking for Hive support generation of DDL.
The issue is that we need to use partitioning on both Postgres and Hive. At moment I can define custom DDL clauses on Entity level in ER diagram, but I need support to distinguish to execute these custom clauses per technology level (Hive is different definition and Postgres as well.)
Hi Ladislav,
Thanks for your enquiry and sorry for the late reply.
I’m pleased to inform you that we planned to support DDL generation for Hive in future version of VP, probably in 16.0.
I second the motion for graph database support.
I’m using dgraph, a free open source distributed graph database. Others you may want to connect, eg. Neo4J, … well here’s a list:
Would love to see these work with VP!