MSSQL Connection
The MSSQLConnection component in Robbot RPA allows you to establish a connection to a Microsoft SQL Server database. This component creates a session that includes the necessary information to connect to the specified database, which can be shared with other components in your automation workflow.
Parameters
Server : Insert the server name or IP address of the Microsoft SQL Server that hosts the database you want to connect to. This parameter specifies the target server for the database connection. Type : String
Database : Insert the name of the database you want to connect to. This parameter identifies the specific database within the SQL Server that you want to establish a connection with. Type: String
User Name : Insert the username for the database authentication. This parameter provides the credentials required to authenticate and authorize access to the specified database. Type : String
Password : Insert the password for the specified user. This parameter works in conjunction with the User Name parameter to authenticate and authorize the connection to the database. Type : String
Usage
To use the MSSQLConnection component in your Robbot RPA project, follow these steps:
Drag and drop the MSSQLConnection component into your sequence or workflow. Configure the component by providing the necessary inputs: Insert the server name or IP address into the Server parameter. Insert the name of the database into the Database parameter. Insert the username for the database authentication into the User Name parameter. Insert the password for the specified user into the Password parameter. Continue building your sequence or workflow by adding other components or actions that require the database connection. Execute your sequence or workflow. The MSSQLConnection component will establish a connection to the specified database, creating a session that can be shared with other components for performing database-related operations. By utilizing the MSSQLConnection component, you can seamlessly connect to Microsoft SQL Server databases within your Robbot RPA automation, enabling you to retrieve, manipulate, and manage data stored in the database.