Enter the following information on the Output tab to specify the output destination of the source data:
Option | Description |
---|---|
Database connection |
Select your database connection from a list of existing Azure SQL DB connections. If you do not have an existing connection, click New. If you need to modify an existing connection, click Edit. See the Install Pentaho Data Integration and Analytics document. |
Schema | Select the schema to use for the bulk load. The Bulk load into Azure SQL DB entry reads the schemas that exist in the database to populate this list. |
Table name | Select the name of the table to bulk load. The Bulk load into Azure SQL DB entry reads the table names from your selected schema to populate this list. |
Columns | Preview of the column names and associated data types within your selected table. |
Note: You can use variables in the schema and table name fields.