Export to SQL database
Summary
This operator copies the records to an external database of type oracle, postgresql or mssql.
Configuration
Input settings of existing table
Name | Value | Opt. | Description | Example |
|---|---|---|---|---|
Columns to be exported | System.Object | - | The specified columns are exported to the database. |
Settings
Name | Value | Opt. | Description | Example |
|---|---|---|---|---|
Tablename | System.String | - | The name of the table in the target database | - |
Database system | System.String | - | Select the database system where the data will be stored. Oracle, MSSqlServer or postgreSQL can be used. | col2 |
Hostname | System.String | - | Name of the database server, how it can be addressed from the network | - |
Instancename | System.String | opt. | Name of the database server instance. (relevant if ORACLE or MSSQL is selected). | - |
Name of the database or schema | System.String | opt. | Name of the database or schema (ORACLE) where the table is to be stored. The user must have CREATE TABLE and INSERT/UPDATE permission in the database/schema | |
TCP/IP Port db-server | System.Int32 | opt. | TCP/IP port of the db-server (default values: ORACLE=1521 MSSQL=1433 PostgreSQL=5432) | |
Connection string | System.String | opt. | ORACLE Connection string: [host]:[port]/[instance] MSSQL Connection string: server=tcp:[host][\[instance]],[port] PostgreSQL connection string: host=[host];port=[port];[dbname=[databasename]];user='[username]';password='[password]' | |
Username | System.String | - | Username used for database login. The user must have CREATE TABLE and INSERT/UPDATE permission in the database/schema. | |
Password | System.String | - | Password used for database logon. (shown as *) | |
Add to existing table | System.Boolean | - | If the option is selected and the table exists, the data will be added. If the table does not exist, it will be created. If the option is not selected and the table exists, an error will be thrown | |
Replace existing table | System.Boolean | - | If this option is selected, the table will be deleted and recreated | |
Exact length in string columns | System.Boolean | - | The maximum number of allowed characters of the database columns of the string type, is the same as the maximum number of characters in the node table. If this option is not active, the columns will be created with the maximum string length of the database | |
Maximum length of the column names | System.Int32 | opt. | Maximum length for column names in the database table. If this value is greater than the allowed length of the database system, the database value is used as the maximum length | |
Number of records per transfer to database | System.Int32 | opt. | Number of records sent to the database per transfer. This setting can be used to reduce the number of necessary data transfers and thus reduce the runtime. ATTENTION! The larger this value is, the larger the required memory Default values:
|