Open connection

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.

Connection name example

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

robustaConnection

Database name example

You can use the Database user shown in the example.

MYSQL

Database user example

You can use the Database user shown in the example.

root

Database url examples

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

Database password example

You can use the Database password shown in the example .

1234

Driver name examples

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