DB Connect

DB Connect

Type: db-connect  ·  Package: Database Activities v1.0.0  ·  Output: ZoanDbSession

Opens a connection to a database and returns a session (ZoanDbSession) that is shared by other database activities. It is the starting point of any work with SQL.

How it works

Connect to the motor indicated in provider using the connectionString. You have two modes (see the session model):

• With body: Activities inside inherit the connection automatically (you don’t configure session), and the connection closes itself upon completion.
• No body: save the session to an output variable; pass it as session to the other activities and close it with DB Close.

Required parameters

Parameter	Editor	Description
provider	list	Motor: sqlserver · postgres · mysql · odbc.
connectionString	expression	ADO.NET connection string. Supports expressions.

Optional parameters

Ninguno.

Subflows (lanes)

body optional

Activities to execute with this connection. If omitted, returns the session as output (and you must close it with DB Close).

Output

Returns a ZoanDbSession. Pass it as session to the other database activities.

Example

DB Connect   provider = sqlserver   connectionString = = credential("db-erp").ToPlainText()
 └─ body:
      DB Query   sql = "SELECT TOP 10 * FROM Clientes"   → output: clientes

Protect the connection string

The connectionString contains the database password. Save it in a credential and use it with = credential("db-erp").ToPlainText(), never in plain text. See connection string.

Related activities

• DB Query / DB Execute / DB Scalar — operate with the session.
• DB Close — close the connection (mode without body).