Connecting to the Databases

Activity Description

Use this activity to connect to databases, currently supported databases include: Mysql, SQLServer, Oracle, Db2, SQlite, PostgreSQL

Property Description

Database Type

Drop-down list box, support six database types: Mysql, SQLServer, Oracle, Db2, SQlite, PostgreSQL

Connection String

Enter a string consisting of database name, port number, user name, password, and character encoding

Database object

Get database objects by defining variables

Usage Example

Execution steps:
Fill in the database connection information -- Connect to the database -- Execute a one-line query -- View the results of the operation