I need to save the results from executing a procedure in a dbexecute component, how can I write it to a write component?
Best answer by Martin Burian
View originalI need to save the results from executing a procedure in a dbexecute component, how can I write it to a write component?
Best answer by Martin Burian
View originalOutput 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.
Sign in with your community account. This is different than your login to your GoodData account. Don't have a community login? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.