Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Sakshi Shrivastava (sakshis2) senior systems engineer
Infosys Ltd
IN
sakshis2 Member since 2017 1 post
Posted: Jul 13, 2017
Last activity: Jul 17, 2017
Posted: 13 Jul 2017 1:41 EDT
Last activity: 17 Jul 2017 2:51 EDT
Closed

How to connect Sql server and fetch data from database and store it into Excel in openSpan

Hi Team,

I have one requirement There is a table in Sql server and I wants to show that particular table in Excel. How can we achieve this in OpenSpan ?? please help me on this.

Thanks in Advance

***Updated by moderator: Lochan to update Categories***

To see attachments, please log in.
Robotic Process Automation

Posted: 7 years ago
Posted: 13 Jul 2017 9:04 EDT
Antara Chatta (AntaraC5)
Tata Consultancy Services (TCS)
Solution Architect- Pega Robotics
Tata Consultancy Services (TCS)
CA

Hi,

There are 2 ways to do that:-

1. using script component

2. using SqlQuery component from toolbox.

--

Thanks

To see attachments, please log in.
Posted: 7 years ago
Updated: 7 years ago
Posted: 17 Jul 2017 2:50 EDT
Updated: 17 Jul 2017 2:51 EDT
jayachandra kundu (jayachandrak)
Westpac Banking Corporation

Westpac Banking Corporation
AU

Hi Ameya,

First you need to interrogate the fields and get the data from these controls.

Drag sql query component to automation window and configure connection string and command type (text, procedure) as shown below

 

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice