PostgreSQL Connection
The Postgre SQL Connection component in Robbot RPA allows you to establish a connection to a PostgreSQL database. This component creates a session that includes the necessary database information, such as the server, database name, username, and password, to share with other components in your automation workflow.
Parameters
Server : Insert the address or hostname of the PostgreSQL database server. This parameter specifies the location where the database is hosted. Type : String
Database : Insert the name of the PostgreSQL database that you want to connect to. This parameter identifies the specific database within the PostgreSQL server. Type: String
User Name : Insert the username or credentials for accessing the PostgreSQL database. This parameter provides the authentication information to establish the connection. Type : String
Password : Insert the password associated with the specified username for accessing the PostgreSQL database. This parameter is used for authentication purposes to ensure secure access. Type : String
Usage
To use the PostgreSQLConnection component in your Robbot RPA project, follow these steps:
Drag and drop the PostgreSQLConnection component into your sequence or workflow. Configure the component by providing the necessary inputs: Insert the address or hostname of the PostgreSQL database server into the Server parameter. Insert the name of the PostgreSQL database into the Database parameter. Insert the username or credentials for accessing the PostgreSQL database into the User Name parameter. Insert the password associated with the specified username into the Password parameter. Continue building your sequence or workflow by adding other components or actions that require the established PostgreSQL connection. Execute your sequence or workflow. The PostgreSQLConnection component will create a session that includes the database connection information and share it with other components in your automation workflow. Use the established PostgreSQL connection in subsequent components or actions to interact with the PostgreSQL database, such as executing queries or performing database operations. By utilizing the PostgreSQLConnection component in your Robbot RPA automation, you can easily establish a connection to a PostgreSQL database and leverage the session for executing queries and performing various database operations within your automation workflow.