Question5Replies6370Views Yukihito Member since 2017 16 posts Power Solutions, Ltd. Posted: 3 years agoLast activity: 3 years 1 month ago Closed How to connect SQL Server and select/insert dataHi,How can I connect SQL Server Data Base which is on my local PC, and select/store data from/into a table?It seems that I have to use something like 'sqlQuery' but I couldn't found details about the control and the others.Could anyone show me the way to do that?Thank you**Moderation Team has archived post**This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post. Robotic Process Automation ×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! Moderation Team has archived post This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question. Posted: 3 years agoKrishnaveniB Bresatech replied to YukihitoHi, Go through the below links , https://pdn.pega.com/sites/pdn.pega.com/files/help_v73/procomhelpmain.h… https://pdn.pega.com/sites/pdn.pega.com/files/help_v719/procomhelpmain… Thanks Posted: 3 years agoYukihito Power Solutions, Ltd. replied to KrishnaveniBHi KrishnaveniB, I've never seen these documents, will look at details. Thanks for a prompt reply. Posted: 3 years agoYukihito Power Solutions, Ltd. replied to YukihitoHi, I could execute insert query by using sqlQuery's CommandText property and Excute method. I think it's fine but is there any other way like: not writing SQLs something like visual based I'd like more easy way, and hope it is... Thanks, Posted: 3 years agoPeterGousios_GCS PEGA replied to YukihitoCan you clarify if this is a standalone db for experimenting, a Pega instance DB or a database you wish to connect to with Pega? There are quite a lot of database tools, and many support imports from other tools like spreadsheets, so that can be an option to consider. Posted: 3 years agoYukihito Power Solutions, Ltd. replied to PeterGousios_GCSHi Peter, I've never thought using import function, I'll try that. Thank you.