PostgreSQL Loader - 23.1

Spectrum Dataflow Designer Guide

Version
23.1
Language
English
Product name
Spectrum Technology Platform
Title
Spectrum Dataflow Designer Guide
First publish date
2007
Last updated
2024-05-09
Published on
2024-05-09T23:01:03.226155

The PostgreSQL Loader allows you to load data to any PostgreSQL database configured in the Enterprise 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 Spectrum Management Console. If you need to make a new database connection, or modify or delete an existing database connection, click Manage Connections.

If you are adding or modifying a database connection, complete these fields:
Connection name
Enter a name for the connection. The name can be anything you choose.
Database driver
Select the appropriate database type.
Connection options
Specify the host, port, instance, user name, and password to use to connect to the database.
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.
  • Select Insert to write data to an empty table or to append it to an existing data table.
  • Select Truncate and Insert to truncate the data before loading it to the database table.
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.