Question

Extract metadata from a dbexecute component?

  • 9 September 2020
  • 1 reply
  • 78 views

I need to save the results from executing a procedure in a dbexecute component, how can I write it to a write component?


1 reply

Output parameters of stored procedure or result set of query are sent to the first output port of the DBExecute component. You will need to fill Query output parameters and/or Result set output fields properties of the DBExecute component, based on what the stored procedure returns. Of course that you sill have to connect the DBExecute with a Write component via a Metadata. Complete documentation of the DBExecute component is available here: https://help.gooddata.com/cloudconnect/manual/dbexecute.html. But I do not recommend to use CloudConnect for a new development, it is a legacy tool which will be discontinued. I recommend use the GoodData data pipeline as described in Data Preparation and Distribution.

Reply