Table of Contents

Search

  1. Preface
  2. Understanding Domains
  3. Managing Your Account
  4. Using Informatica Administrator
  5. Using the Domain View
  6. Domain Management
  7. Nodes
  8. High Availability
  9. Connections
  10. Connection Properties
  11. Schedules
  12. Domain Object Export and Import
  13. License Management
  14. Monitoring
  15. Log Management
  16. Domain Reports
  17. Node Diagnostics
  18. Understanding Globalization
  19. Managing Distribution Packages
  20. Appendix A: Code Pages
  21. Appendix B: Custom Roles
  22. Appendix C: Informatica Platform Connectivity
  23. Appendix D: Configure the Web Browser

Administrator Guide

Administrator Guide

Greenplum Connection Properties

Greenplum Connection Properties

Use a Greenplum connection to connect to a Greenplum database. The Greenplum connection is a relational type connection. You can create and manage a Greenplum connection in the Administrator tool or the Developer tool.
The order of the connection properties might vary depending on the tool where you view them.
When you create a Greenplum connection, you enter information for metadata and data access.
The following table describes Greenplum connection properties:
Property
Description
Name
Name of the Greenplum relational connection.
ID
String that the Data Integration Service uses to identify the connection. The ID is not case sensitive. It must be 255 characters or fewer and must be unique in the domain. You cannot change this property after you create the connection. Default value is the connection name.
Description
Description of the connection. The description cannot exceed 765 characters.
Location
Domain on which you want to create the connection.
Type
Type of connection.
The user name, password, driver name, and connection string are required to import the metadata. The following table describes the properties for metadata access:
Property
Description
User Name
User name with permissions to access the Greenplum database.
Password
Password to connect to the Greenplum database.
Driver Name
The name of the Greenplum JDBC driver.
For example:
com.pivotal.jdbc.GreenplumDriver
For more information about the driver, see the Greenplum documentation.
Connection String
Use the following connection URL:
jdbc:pivotal:greenplum://<hostname>:<port>;DatabaseName=<database_name>
For more information about the connection URL, see the Greenplum documentation.
PowerExchange for Greenplum uses the host name, port number, and database name to create a control file to provide load specifications to the Greenplum gpload bulk loading utility. It uses the Enable SSL option and the certificate path to establish secure communication to the Greenplum server over SSL.
The following table describes the connection properties for data access:
Property
Description
Host Name
Host name or IP address of the Greenplum server.
Port Number
Greenplum server port number. If you enter 0, the gpload utility reads from the environment variable $PGPORT. Default is 5432.
Database Name
Name of the database.
Enable SSL
Select this option to establish secure communication between the gpload utility and the Greenplum server over SSL.
Certificate Path
Path where the SSL certificates for the Greenplum server are stored.
For information about the files that need to be present in the certificates path, see the gpload documentation.

0 COMMENTS

We’d like to hear from you!