Skip to main content
日本語

SQL Server 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 SQL Server Connector.

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

 

Creating a Connection resource

To use the SQL Server 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 [SQL Server] for Connector and [SQL Server 2019 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. ○
  • 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 SQL Server 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 SQL Server is “jdbc:sqlserver://<Host name>:<Port number>;DatabaseName=<Database name>”. 		 
  • Enabled as a required field when [Enter URL directly] is checked.
User name Enter the user name. ○

 
password Enter the password ○  
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 SQL Server 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 SQL Server Connector on a script using the connection resource added above.

Example: Setting up a SQL Server Connector [Read Table] operation

Drag and drop [Database] - [SQL Server] - [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.