Add table content to Database

Adds the content of data table to a database table. The database connection can be opened using the provider name and connection string, or an existing connection created with OpenConnection activity.

Add datatable designer

Designer Properties#

  1. Table The data table to be added to database.
  2. Table Name The database table name to add the content of the data table.

Properties#

Open database properties

Input#

  1. Connection The connection opened using OpenConnection activity. We can either set the connection or create another using Provider Name and Connection String.
  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. 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.
  4. See Designer Properties above.

General Properties#

See General Properties.

Misc#

See Misc.

Out Error#

See Out Error.

Output Properties#

  1. Added Rows The number of added rows in database.

Example#

Please check Open database connection example.