Hi,
I need to automate a report. It involves two different servers. First i will fetch data from one server and will pass the as input to another server. Please let me know the way to automate this report.
Regards,
Priya
Hi Priya,
Can you please elaborate on the application type from where you fetching data.
Am fetching the data from SQL database. I will execute the query in one server first and will send a particular column as input to the other query which i execute in another server.
OK. Use Application activity and provide the SQL server details in it. IN the process, add application activity and inside it add ExecuteDBQuery activity with operation=query and query will be your select query. Second step, add another application activity (if you are connecting to a different server) and executedb again with insert query
Hi,
To add when you run select query the result set will be a data table. You will have to iterate over individual row of data table and insert value one by one in another db
Regards,
Amit Anand