Clarity

  • 1.  Help - Using DBeaver for OnDemand Sites

    Posted Apr 23, 2019 11:12 AM

    Hi there, we use to connect to the onDemand sites of ppm via Dbeaver, when we create a query the result shown is limited, for example.

     

    SELECT count(*) FROM scXXXXX.ODF_CA_INV the result is 3298

     

    but if i do

     

    SELECT * FROM scXXXXXX.ODF_CA_INV

     

    its return 200 records, if I scroll a get 200 more records, and so on.

     

    Is there any limitation on the query to Jasper or is any configuration on the JDBC driver, or the DBeaver.

     

    This is what i user

    jdbc:jaspersoft@https://cppmrpt103.ondemand.ca.com/reportservice;datasource=/ca_ppm/data_sources/CA_PPM_BEAN;pagesize=500

     

    Cheers,

    Pablo



  • 2.  Re: Help - Using DBeaver for OnDemand Sites

    Broadcom Employee
    Posted Apr 23, 2019 11:26 AM

    Hi Pablo - 

     

    I'm not sure I understand your question correctly.

     

    Select count (*) will only give you the number of rows in this table.  Select * will give you all the data in the table.  The scrolling is just what the UI can show you on the screen.  If you kept scrolling, it would stop at 3298.

     

    Can you let me know exactly what you are expecting?

     

    -Stephanie



  • 3.  Re: Help - Using DBeaver for OnDemand Sites

    Posted Apr 23, 2019 12:42 PM

    Its stop at 2000 results

     

     

    I dont know if the problem is the dbeaver or what.

     

    Cheers,

    Pablo



  • 4.  Re: Help - Using DBeaver for OnDemand Sites
    Best Answer

    Broadcom Employee
    Posted Apr 24, 2019 01:39 AM

    It should be a DBeaver setting. DBeaver gets 200 results each time by default.

     

     

    In this screenshot, the configuration is set to get 200 results ('Result-set fetch size' setting), and the value next to it specifies that there are more than 200 results ('200+'), so scrolling would fetch additional rows.

     

    https://dbeaver.com/files/docs/wiki/navigation.html

     

    You can also check their old forums (archived) https://dbeaver.io/forum/index.php or their issue tracker https://github.com/dbeaver/dbeaver/issues for more info.

     

    Regards,

    Marc



  • 5.  RE: Re: Help - Using DBeaver for OnDemand Sites

    Posted Jan 15, 2021 03:28 PM
    Hi Marc, 

    Would you be able to help me with creating credentials in DBeaver to connect to PPM PostgreSQL DB.

    We use PPM SaaS, not sure if DBeaver can connect to SaaS database.

    Thank you,
    Ahsan 


    ------------------------------
    Business Analyst
    PHSA
    ------------------------------



  • 6.  RE: Re: Help - Using DBeaver for OnDemand Sites

    Broadcom Employee
    Posted Jan 18, 2021 01:17 AM
    Hello Ashan,

    There is no database access in GCP Clarity SaaS, so the issue is not related to DBeaver or any other software.

    You can use ODATA to query the DWH schema.

    https://knowledge.broadcom.com/external/article?articleId=197766
    https://community.broadcom.com/enterprisesoftware/communities/community-home/digestviewer/viewthread?GroupId=1747&MessageKey=57550199-49e7-47fc-a045-507610c18a12&CommunityKey=7f0cbca3-5f93-4d44-a369-1a8ce98f5578&tab=digestviewer&ReturnUrl=%2fenterprisesoftware%2fcommunities%2fcommunity-home%2fdigestviewer%3fcommunitykey%3d7f0cbca3-5f93-4d44-a369-1a8ce98f5578%26tab%3ddigestviewer

    I hope this helps.

    Best regards,

    Marc