Execute Statement in DatabaseConnector

0
Dear all, I’m trying to load data from SQL statement – Execute Statement, or execute query. If possible, would you share sample package or module for data extract and loading? Best Regards, Charlie  
asked
1 answers
1

Hi,

I can guide you, what needs to be done for this scenario:

Create Microflow and add the following logic, 

Establish JDBC connection in JDBC_url object, 

Write query i  SqlQuery Object and

Inside ExceuteQuery map the Jdbc_Url, Username, Password, Sql Query and Result object is the one which you will store the data by creating an empty object.

 

Hope it might be helpful 

answered