External Dissemination Ideas Portal

Is it possible to have a direct access to the table/view of All datasets report?

Dear team, 

We have to produce number of reports for our work. It would be great if we could have a dynamic access to the table/view for all datasets rather than a static one so that we don't have to generate all datasets report each time. 

Thanks,

Nobuko

  • Nobuko Miyachiyo
  • Apr 23 2018
  • Shipped
  • Attach files
  • Nobuko Miyachiyo commented
    23 Apr 09:24

    It would be great if this can be done quickly as I have to implement something important.

    Thanks,

    Nobuko

  • Ludivine Baudouin commented
    23 Apr 10:38

    that is a great idea, thanks Nobuko!

  • Admin
    Claudia Tromboni commented
    23 Apr 10:46

    Hello,

    could you give some more detail on the use case and on what you mean by a dynamic view?

    Do you mean an HTML format that would show in the page when you click on the button?

    The report is a search result that you download once the search is done, depending in the number of objects it is feasible to do it dynamically or not.

    How would this help more than the current report?

    This is very important so I can justify the priority in comparison with other ongoing needs

    thanks

    Claudia

  • Nobuko Miyachiyo commented
    23 Apr 11:11

    Sorry, I wasn’t specific enough. Usually, we work in Excel. It would be great to retrieve the table/view via ODBC or data connection directly from the kappa database. I hope this is clear. Thanks, Nobuko

  • Admin
    Claudia Tromboni commented
    23 Apr 12:40

    Nobuko.

    Kappa is a Marklogic xml database and the tests with ODBC connector have not been satisfactory at all.

    I think you could see with the technical team the possibilities we can propose.

    Using the API might be possible, or an SQL copy we make everyday from Kappa (but not sure it has all metadata you need)

    Thanks

    Claudia

  • Nobuko Miyachiyo commented
    23 Apr 13:21

    Thank you, Claudia.

    I'll create a redmine for the technical team?

    it would be great if can get access to the SQL copy.

    Best,

    Nobuko

  • Admin
    Claudia Tromboni commented
    15 May 10:43