Skip to main content
日本語

PostgreSQL Connector - How to set up connection resource and use connector

  • Updated

Preparing the database

Prepare connection information for the database you want to connect with the PostgreSQL Connector.

-Host name/IP address
-Port number
-Administrative database
-User name
-Password

 

Creating a Connection resource

To use the PostgreSQL Connector in HULFT Square, you need to create a connection resource first.

1. In HULFT Square, go to [Main] - [DATA INTEGRATION] - [Connections] and click [Add New]. 

2. In the Type section, select [PostgreSQL] for Connector and [PostgreSQL 12 connection] for Type, then click [Next].

3. In the General section, set a name of the connection resource, workspace (optional) and description (optional), then click "Next".

4. In the Settings section, set the parameter values required for the connection.
To verify the connection with the entered values, click [Verify Connection].

Item name Description Required Remarks
Host name Enter the database host name.

○
  • Disabled when [Enter URL directly] is checked.
Port number

Enter the database port number.

Default number is 5432.

 ○
  • Disabled when [Enter URL directly] is checked.
Database name Enter the database name.  
  • Disabled when [Enter URL directly] is checked.
Enter URL directly Select whether or not to enter the URL of destination PostgreSQL database directly.
  • [Checked]:
    Enter the URL directly.
  • [Not checked]: (default)
    Generate URL based on the settings of [Host name], [Port number], and [Database name].
    
URL Enter the URL.
Standard URL format of PostgreSQL is “jdbc:postgresql://<Host name>:<Port number>/<Database name>”. 		 
  • Enabled as a required field when [Enter URL directly] is checked.
User name Enter the user name. ○

 
password Enter the password ○  
SSL connection Select whether or not to perform SSL connection.
  • [Checked]:
    SSL connection will be performed.
  • [Not checked]: (default)
    SSL connection will not be performed.
  
  • Disabled when [Enter URL directly] is checked.
Limit the number of tables in list Select whether to limit the number of tables listed or not.  
  • If not checked, table names listed are not limited and all of the table names available are fetched.
Number of tables in list Enter a number of tables listed.  
  • Enabled when [Specify the number of tables in the list] is checked.
  • Default value is 500. When omitted, or when an invalid value is entered, 500 will be applied.
Limit the number of procedures Select whether to limit the number of procedures or not.  
  • If not checked, procedures listed are not limited and all of the table names available are fetched.
Number of procedures Enter the number of the procedures listed.  
  • Enabled when [Specify the number of procedures in the list] is checked.
  • Default value is 500. When omitted, or when an invalid value is entered, 500 will be applied.

 

5. When the Verify connection dialog box opens, set [Integrate service] and [Profile to load resources] and click "OK".
The verification test result will appear on the dialog box.

6. If there are no problems, click "Finish" to complete the connection resource creation process.

Now you have a PostgreSQL connection resource.

 

Setting up the connector

Here is an example of using the PostgreSQL Connector on a script using the connection resource added above.

Example: Setting up a PostgreSQL Connector [Read Table] operation

Drag and drop [Database] - [PostgreSQL] - [Read Table] onto the script canvas to open the properties dialog.

The setting values for each item in the required settings tab are as follows:

-Destination: Select the resource name created in the section above (Creating a Connection resource).
-Table name: Select a table from the list of tables in the database.
-Schema definition: Automatically set when the Table name is selected.

Related articles

Comments

0 comments

Article is closed for comments.