Open connection

Estimated reading: 2 minutes 386 views

Open connection activity is used for establishing a connection to the desired database server.

*Connection name	A connection name is defined to be used as the database connection variable.
*Database name	The name of the previously defined database on the DB Definitions page in the RPA-Admin module.
*Database user	Database user name information is written.
*Database url	Jdbc URL entry is written in accordance with the database to be connected.
*Database password	Database user password information is written.
*Driver name	The driver suitable for the database to be connected is selected.

_{Note: * Fields selected with are required, others are optional.}

You can use the Connection name as shown in the example.

robustaConnection

You can use the Database user shown in the example.

MYSQL

You can use the Database user shown in the example.

root

You can use the Url for Mysql as shown in the example.

jdbc:mysql://localhost:3306/robusta

You can use the Url for Oracle as shown in the example.

jdbc:oracle:thin:@localhost:8080:robusta

You can use the Url for SQL server as shown in the example.

jdbc:sqlserver://localhost:1433;databaseName=robusta

You can use the Url for Apache Impala as shown in the example.

jdbc:impala://[Host]:[Port]

You can use the Url for PostgreSQL as shown in the example.

Connection db = DriverManager.getConnection(url, username, password)

You can use the Url for IBM S400 server as shown in the example.

JDBC URL: jdbc:as400://hostname/default-schema

You can use the Url for Sybase server as shown in the example.

jdbc:sybase:Tds:host:port?ServiceName=database

You can use the Url for Bkz. as shown in the examples.

https://docs.oracle.com/cd/E57185_01/ESTUG/apbs02s04s01.html

You can use the Database password shown in the example.

1234

You can use the Url for Mysql as shown in the example.

com.mysql.jdbc.Driver

You can use the Url for Oracle as shown in the example.

oracle.jdbc.driver.OracleDriver

You can use the Url for SQL server as shown in the example.

com.microsoft.sqlserver.jdbc.SQLServerDriver