Solved

Extract metadata from a dbexecute component?

  • 9 September 2020
  • 1 reply
  • 132 views

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

icon

Best answer by Martin Burian 9 September 2020, 22:11

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.

View original

1 reply

Userlevel 1

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