Open Database connection

Opens a database connection using a provider name and a connection string that can be used for Run Query, Run Non Query, Start Transaction or Add data Table. To close the connection we need to Close Database connection activity.

Designer Properties

1. Provider Name The provider used to connect to the database. For instance, in the example below we use Odbc to connect to a postgres database.
2. Connection string Database connection string. As an example, for the example below the format is "Driver={PostgreSQL ODBC Driver(UNICODE)};Server=127.0.0.1;Port=5432;Database=postgres;UID=postgres;PWD=yourpassword"
3. Out Connection The generated database connection. To simplify the process, we generate the connection variable automatically, but it can be changed under Variable tab at the bottom of the workflow.

Properties

Input

See Designer Properties above.

General Properties

See General Properties.

Misc

See Misc.

Out Error

See Out Error.

Output Properties

See Designer Properties above.

Example

Open database connection and add table

In this example we open a database connection to a postgres database, add the content of data table to a database table and display the content of the resulting database table.
In this case we used "Odbc Data Provider" as provider name.

To connect to postgres database, we had to

1. Install postgres from here https://www.enterprisedb.com/downloads/postgres-postgresql-downloads
2. Using Stack Builder installed by postgres (to find it, just type stack builder in windows start), select the database and press the next button to install the drivers as in the below screenshot.
3. Use a Connection string like the following "Driver={PostgreSQL ODBC Driver(UNICODE)};Server=127.0.0.1;Port=5432;Database=postgres;UID=postgres;PWD=". Just make sure you update the password or any other relevant field in the above connection string.