Table of Contents

Search

  1. Preface
  2. Informatica Developer
  3. The Model Repository
  4. Searches in Informatica Developer
  5. Connections
  6. Physical Data Objects
  7. Flat File Data Objects
  8. Logical View of Data
  9. Viewing Data
  10. Application Deployment
  11. Application Patch Deployment
  12. Application Patch Deployment Example
  13. Continuous Integration and Continuous Delivery (CI/CD)
  14. Object Import and Export
  15. Appendix A: Data Type Reference
  16. Appendix B: Keyboard Shortcuts
  17. Appendix C: Connection Properties

Developer Tool Guide

Developer Tool 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!