Preparing the database
Prepare connection information for the database you want to connect with the JDBC Connector.
-Host name/IP address
-Port number
-Administrative database
-User name
-Password
Creating a Connection resource
To use the JDBC 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 [JDBC] for Connector and [JDBC 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 |
| Driver class name | Enter the JDBC driver class name. |
○ |
|
| URL | Enter the URL to connect to the database. | ○ |
|
| User name | Enter the user name of the database. | ||
| Password | Enter the password of the database user. | ||
| Execute transaction processing |
Select whether to perform transaction processing.
Refer "Transactions" for more information. |
||
| Client information property list | Specify the additional information of the client. |
|
|
| Client information property list / Name | Enter the name of the client information property. | ○ | |
| Client information property list / Value | Enter the value of the client information property. | ||
| Limit the number of tables in list | Select whether to limit the number of tables listed or not. |
|
|
| Number of tables in list | Enter a number of tables listed. |
|
|
| Limit the number of procedures | Select whether to limit the number of procedures or not.
|
|
|
| Number of procedures | Enter the number of the procedures listed. |
|
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 JDBC connection resource.
Reference: When connecting to resources on Amazon Web Services
When connecting to resources on Amazon Web Services (AWS), HULFT Square and your AWS environment (VPC) will be connected via AWS PrivateLink as needed.
By creating a VPC endpoint in HULFT Square, you can connect to the VPC endpoint service in your AWS environment via PrivateLink.
In this case, the [DNS Name] of the created VPC Endpoint must be used for the [Host Name] or [URL] in the Add New screen under Resources - Connections.
For more information on VPC Endpoint", please refer to the following HULFT Square document.
----------
VPC Endpoint - HULFT Square documentation
https://www.hulft.com/help/en-us/HULFTSquare/Content/HULFT_Square/HS_Settings/settings_vpc_endpoint.htm
Setting up the connector
Here is an example of using the JDBC Connector on a script using the connection resource added above.
Example: Setting up a JDBC Connector [Read Table] operation
Drag and drop [Database] - [JDBC] - [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.
Comments
0 comments
Article is closed for comments.