Man illustrationFlower illustration

Docy

Open connection

Estimated reading: 2 minutes 101 views

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


*Connection
name
The connection name defined to be used as the database connection variable.
*Database nameThe name of the previously defined database on the DB Definitions page in the RPA-Admin module.
*Database userDatabase user name information is written.
*Database urlJdbc url entry is written in accordance with the database to be connected.
*Database passwordDatabase user password information is written.
*Driver nameThe 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

CONTENTS