Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • PowerExchange Adapters for PowerCenter 10.5
  • All Products

Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange for Vertica
  3. PowerExchange for Vertica Configuration
  4. Vertica Sources and Targets
  5. Vertica Mappings
  6. Vertica Sessions
  7. Appendix A: Vertica Data Type Reference

PowerExchange for Vertica User Guide for PowerCenter

PowerExchange for Vertica User Guide for PowerCenter

Back Next

Vertica Relational Connection Properties

Vertica Relational Connection Properties

The following table describes the properties that you must configure for a Vertica relational connection:
Property
Description
Name
Enter a name for the connection.
Type
The connection type is set by default. You cannot edit this value.
User Name
Enter the user name to connect to the Vertica database.
The user must have read permissions on the schema where the Vertica source table resides. Similarly, the user must have write permissions on the schema where the Vertica target table resides.
Password
Enter the password to connect to the Vertica database.
Use Parameter in Password
Indicates that the password for the repository user name is a session parameter, $Param
Name
. Define the password in the workflow or session parameter file, and encrypt it by using the
pmpasswd
 CRYPT_DATA option.
Default is disabled.
Connect String
Enter the name of the ODBC data source that you created for the Vertica database.
Code Page
Select the code page that the PowerCenter Integration Service must use to read or write data.
Connection Environment SQL
Runs an SQL command with each database connection.
Default is disabled.
Transaction Environment SQL
Runs an SQL command before the initiation of each transaction.
Default is disabled.
Connection Retry Period
The number of seconds that the PowerCenter Integration Service attempts to reconnect to the database if the connection fails. If the PowerCenter Integration Service cannot connect to the database in the retry period, the session fails.
Default value is 0.
Load Balance
Select this option to enable load balancing on the Vertica database. When you enable load balancing, the PowerCenter Integration Service requests a load balanced connection with the Vertica database.
Default is enabled.
For more information on load balancing, see the Vertica database documentation.
0 COMMENTS
We’d like to hear from you!