v14 - Access to OOTB tables

Hi Evryone,


In our current setup we have custom reporting code that calls stored procedures, and those procedures query the OOTB tables directly. My understanding is that v14 no longer allows direct database access, so that approach won't carry over as is. From what I've seen, the only supported way left is to get the data through the in-process APIs.

The challenge is that our procedures join several OOTB tables, sort the combined result (mostly by date, newest first) and page it in a single query, with a total count. The APIs don't seem to let us sort and page across the data in one consistent way like that. So I'd like to know how others have handled this.


My questions:

- Is my understanding correct that the in-process APIs are the only supported way to get this data in v14?


Thanks in advance.

Parents
  • Hi Satish,

    V14 has been a long time coming and there has been adequate time to prepare for this point.  What you will need to do is either rewrite your plugins to use the API's as you correctly identified.  If those API's do not do what you need, then you need to create your own API's datasets, query and maintain those as custom tables.  The V14 upgrade process will allow you access to pull the data you need into those new tables, so you should not lose any historical data.  If you need some technical help with that let us know, I understand it's not the easiest answer to digest.

        

Reply
  • Hi Satish,

    V14 has been a long time coming and there has been adequate time to prepare for this point.  What you will need to do is either rewrite your plugins to use the API's as you correctly identified.  If those API's do not do what you need, then you need to create your own API's datasets, query and maintain those as custom tables.  The V14 upgrade process will allow you access to pull the data you need into those new tables, so you should not lose any historical data.  If you need some technical help with that let us know, I understand it's not the easiest answer to digest.

        

Children