A2019 Tutorials - Read Configuration Values From SQL Server

Today we are going to see how we can store configuration details in SQL Server Database, Connect A2019 to SQL Server with Windows Authentication and dynamically map the configuration dictionary variable. To enable SQL Server connection with Windows Authentication, follow the below steps : 1) Download the latest JDBC driver from Microsoft official website : https//docs.microsoft.com/en-us/sql/connect/JDBC/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-ver15 2) Unzip the package and upload mssql-7.2.2.jre8.jar file to A2019 Control Room. 3) Locate and Rename sqljdbc_auth.dll file in the unzipped package folder. 4) Copy the file to i) C:\Windows\System32 ii) C:\Program Files\Automation Anywhere\Bot Agent\jre\bin 5) This enables Windows Authentication. Now go to SQL Configuration Manager by determining the installation path as per your SQL Server version. 6) Enable the TCP port at 1443 and restart the service if this was not enabled by default. 7) Go to A2019 and create a new bot. Use the connect command at default connection mode and provide the following connection string : jdbc:sqlserver://localhost;databaseName={YOUR_DB_NAME};integratedSecurity=true; 8) Use the driver file as the one which we uploaded at step 2. 9) Use a read command and loop through the database table. Please do like, comment and subscribe to my channel for more interesting contents going ahead.