Database Connection
Connections store authentication information. For general information about sharing database connections, please see Using Database Connections.
Note that different subsets of the Database Connection parameters below are made available in different contexts.
Connection
This parameter specifies a database connection for the reader through a drop-down menu. The Add Database Connection option in the menu allows you to create a new connection. The connection requires a name that describes the connection.
Note: The following characters are not allowed in connection names: ^ \ / : * ? " < > | & = ' + % #
The new connection can be made visible only to the current user, or can be shared among multiple users.
Connection Parameters
Note: The source and destination dataset must be set to the database name.
Host
This specifies the machine running the PostgreSQL ORDBMS as either an IP address or host name. The database must have proper permissions and be set up to accept TCP/IP connections if connecting from a remote machine.
Port
When connecting remotely, this specifies the TCP/IP port on which to connect to the ORDBMS service. The default port is 5432.
Database
Specify the name of the PostgreSQL database. The database must exist in the ORDBMS.
Note: In most cases, the Database field should be left with blank values, and the Dataset should contain the name of the PostgreSQL database.
Username and Password
Enter the username and password to access the database, user account, or wherever authentication is required.
Note: If you are having trouble connecting to the database, ensure you can connect to the database with the host, port, database, user name, and password using psql. See PostgreSQL documentation for proper security and connection information, and for the usage of the psql utility.
Schemas for Table Listing
If this is not set, the Table List dialog will only show choices from the search path for the current user. Selecting specific schemas here will cause tables from those schemas to be shown instead.
This parameter also specifies the schemas to fetch candidate tables from when merging feature types. If it is not set, candidate tables are fetched based on the search path for the current user.
Constraints
Table List
Enter, or browse for, the name(s) of specific database table(s) to read from.
Note: If the table list in the PostgreSQL reader Reader Parameters box does not display your table, try typing the name with the schema prefix, i.e. public.mytable. If this works, then your search path for schemas may not be set to the desired values.
Schema Attributes
Additional Attributes to Expose
Use this parameter to expose Format Attributes in Workbench when you create a workspace:
- In a dynamic scenario, it means these attributes can be passed to the output dataset at runtime.
- In a non-dynamic scenario where you have multiple feature types, it is convenient to expose additional attributes using this one parameter. For example, if you have ten feature types and want to expose the same attribute in each one, it is easier to define it once than it is to set each feature type individually in the workspace.