PostgreSQL Loader
The PostgreSQL Loader allows you to load data to any PostgreSQL database configured in the Spectrum™ Data Integration platform.
Option Name | Description |
---|---|
Connection |
Select the
database connection you want to use. Your choices vary
depending on what connections are defined in the Connection
Manager of Management Console. If you need to make a new
database connection, or modify or delete an existing
database connection, click
Manage.
Note: This option is
available only through the Enterprise
Designer. If you are adding or modifying a database connection, complete
these fields:
|
Table/View | Click the browse button ([...]) to navigate to the table or view you want to use. |
Database fields | This column lists the field name in the database. You cannot modify these field names. |
Stage fields | This column lists the field names used in the dataflow. You cannot modify these field names. |
Types | This column lists the data type of each field. |
Runtime Tab
Option Name | Description |
---|---|
Load method | Specifies the method of writing data to the PostgreSQL database tables.
|
Note: You can achieve significant performance improvements by using multiple runtime instances
of this operation. To do this, click the Runtime button and enter the
required value in the Runtime instances field.