Preloading from Custom Schema

Hello @_manoj_kumar_ ,

You can create your own preloading activity from Java Script (Script activity) where you can use jsapi database calls such as queryDef, sqlSelect, sqlExec ...  and then store the data under ctx.recipient.@id, .... All OOTB activities will read it as you would use the Preloading activity, also you can display the information on page.

Marcel

Hello @marcel_szimonisz,

Yes, you are correct this is what we are using right now to preload users from custom schema. But it will be great if we can get that option to configure this in the preloading activity itself.

@_manoj_kumar_ 

I thought this was a question 🙂  I think they left behind the web app development so you need to workaround many things here. But yes it would be nice to choose the dimension in preload activity

carefull with SQLExec, SQLSelect, SQLGetDouble, etc
the scaling is better with queryDef as it goes through the normal query engine that will handle in a better way any locks on the tables

"SQL injection is evil" ^^

Hi @_manoj_kumar_,

Are you referring to web download workflow activity or transfer file workflow activity?  If you can then kindly provide a screenshot of the same.

Thanks!