BluePrism - SQL Server || Reality & Useful
Hi Friends, Now We will discuss about MSSQL Connectivity and fetch data from SQL Table --------------------------------------------------------------------------- First Check the table available in MSSQL or not and create one sample table with two columns Create table sample(no int,name text); HostName: BALAJI-PC\SQLEXPRESS I am going to create above table completed successfully. let me check query the table select * from sample; Now we will create a bot to fetch data from table. For this we will insert dummy data 1. We will use Action stage and 'Data - SQL Server' VBO to configure the database details Using the set connection we need to configure the SQL Server details Server - BALAJI-PC\SQLEXPRESS Database - Robotics-DB For my database no username and no password I Created againt the table using IDE. updating the query with this SELECT * FROM [Robotics-DB].[dbo].[sample] So, those are empty 2. we will use Action Stage to query the data We have a Action called 'Get Collection' SQL - select * from sample Now we got the data. Let's do the insertion of records For this we need to use Execute Action in Data - SQL Server' VBO insert into [Robotics-DB].[dbo].[sample] values(4,'Manager') Now we got the data with inserted record into collection Thank you for watching video and output will be the collection and success & message 3. Let's link it and execute we got error saying that invalid object name 'sample' That means unable to identify the table name Let me solve it
Hi Friends, Now We will discuss about MSSQL Connectivity and fetch data from SQL Table --------------------------------------------------------------------------- First Check the table available in MSSQL or not and create one sample table with two columns Create table sample(no int,name text); HostName: BALAJI-PC\SQLEXPRESS I am going to create above table completed successfully. let me check query the table select * from sample; Now we will create a bot to fetch data from table. For this we will insert dummy data 1. We will use Action stage and 'Data - SQL Server' VBO to configure the database details Using the set connection we need to configure the SQL Server details Server - BALAJI-PC\SQLEXPRESS Database - Robotics-DB For my database no username and no password I Created againt the table using IDE. updating the query with this SELECT * FROM [Robotics-DB].[dbo].[sample] So, those are empty 2. we will use Action Stage to query the data We have a Action called 'Get Collection' SQL - select * from sample Now we got the data. Let's do the insertion of records For this we need to use Execute Action in Data - SQL Server' VBO insert into [Robotics-DB].[dbo].[sample] values(4,'Manager') Now we got the data with inserted record into collection Thank you for watching video and output will be the collection and success & message 3. Let's link it and execute we got error saying that invalid object name 'sample' That means unable to identify the table name Let me solve it