Search

Installation for PowerCenter and Data Quality

Installation for PowerCenter and Data Quality

10.5.5
- 10.5.6
- 10.5.5.1
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0

Back Next

PostgreSQL Connection Properties

PostgreSQL Connection Properties

Use a JDBC connection to access tables in a PostgreSQL database.

The following table describes the Oracle connection properties:

Property	Description
User name	Database user name.
Password	Password for the user name.
JDBC Driver Class Name
Connection String	Connection string to use to read data and metadata from the database. Define the connection string in the following format: jdbc:informatica:postgresql://<host>:<port>;Database=<id>
Environment SQL	Optional. Enter SQL commands to set the database environment when you connect to the database. The Data Integration Service executes the connection environment SQL each time it connects to the database.
Transaction SQL	Optional. Enter SQL commands to set the database environment when you connect to the database. The Data Integration Service executes the transaction environment SQL at the beginning of each transaction.
Support Mixed-case Identifiers	When enabled, the Data Integration Service places identifier characters around table, view, schema, synonym, and column names when generating and executing SQL against these objects in the connection. Use if the objects have mixed-case or lowercase names. By default, this option is not selected.
SQL Identifier Character	The type of character used to identify special characters and reserved SQL keywords, such as WHERE. The Data Integration Service places the selected character around special characters and reserved SQL keywords. The Data Integration Service also uses this character for the Support Mixed-case Identifiers property.
Use Sqoop Connector
Sqoop Arguments

Create Connections

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.