Skip to Content

PowerDesigner for Hive/HBase

Wondering if anyone is using PowerDesigner for modeling tables for Hive and/or HBase? I have started a custom .xdb file for Hive but it falls short when dealing with complex data types and there are additional customizations needed that I have not figured out yet. I've heard that the next version will have some sort of support for big data, but no idea what that will look like.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    Posted on Mar 26, 2014 at 01:24 PM

    Hi Monique,

    We plan to include a new xdb for 16.5 SP04.

    I would be interested in your specific request about Hive in PowerDesigner.

    You can write directly to me (marc.ledier@sap.com).

    Regards,

    Marc

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      1) Enter service.sap.com website.

      2) Enter Software Downloads > Support Packages and Patches > A-Z Index

      3) Go to letter P and choose SYBASE POWERDESIGNER/SAP PowerDesigner on the list

      4) You may find two alternatives:

      - SYBASE POWERDESIGNER 16.5/SAP PowerDesigner 16.5 <--- Choose this one

      - SYBASE POWERDESIGNER SE 16.5/SAP PowerDesigner, standard edition 16.5

      5) Choose SYBASE POWERDESIGNER 16.5 -> Windows on x64 64bit

      6) Download and install EBF 16.5 SP04 PL01 PowerDesigner (x64)**

      ** You can confirm if your PowerDesigner installation is x64 by checking whether PowerDesigner is installed at C:\Program Files\Sybase\PowerDesigner that is installed in "Program Files (x86)" directory, that means it would be 32-bit, and then corresponding patch to download would be the corresponding "EBF : 16.5 SP04 PL01 PowerDesigner (w32)" through step 5 "SYBASE POWERDESIGNER 16.5 > Win32" instead.

      7) After installing the Patch level, enter PowerDesigner again and confirm if it now shows: 16.5 SP04 PL01 at Menu Help > About PowerDesigner

      Note: If you are using PowerAMC instead, the steps are the same. Just follow the very same steps above, but by changing Product Name to SYBASE

      POWERAMC/SAP PowerAMC in step 3 and by choosing the corresponding EBF numbers for PowerAMC instead.

      For more information go to : Understand EBF / Service Pack and what has been fixed

  • author's profile photo Former Member
    Former Member
    Posted on Sep 26, 2013 at 05:54 PM

    I haven't had a chance to try this yet, Monique, but it is something I'd be very interested in also.

    Would it be possible for you to share the .xdb file you've started so that I can better understand the error you're getting, and try to help you get it working?

    Add a comment
    10|10000 characters needed characters exceeded

    • Hello Eric. Not getting any errors. There is just a lot needed before PowerDesigner can support modeling for Hive. Some things I was able to customize myself - e.g. correct list of data types for Hive, certain statements desired before or as part of the create table DDL. Other things are more complex e.g. optional parameters for create table DDL, which I have been able to customize but which still needs manual effort to provide appropriate variables. The most difficult is what to for complex data types e.g. Struct - which is effectively a nested structure within the table. PowerDesigner is not (and may never be) set up for that. Not even sure what that would look like. It may be that PowerDesigner can only represent the logical model but not the physical. Don't see a way to attach the .xdb I've been working on so let me know how I can send it.

  • author's profile photo Former Member
    Former Member
    Posted on Jul 27, 2016 at 03:12 PM

    Hi David

    We are building HBASE solutions as well as Oracle solutions. We have stored all our Oracle data models in PowerDesigner and would like to do the same for the HBASE solution.

    We would also want to reverse engineer the tables/schemas into PowerDesigner to keep the model aligned.

    Can you please advise if 1) it is possible to model HBASE tables and 2) if the tables can be reverse engineered?

    Chantel

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.