Azure SQL Database Connector - How to set up connection resource and use connector – HULFT Square

Preparing the database

Prepare connection information for the database you want to connect with the Azure SQL Database Connector.

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

Creating a Connection resource

To use the Azure SQL Database 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 [Microsoft Azure] for Connector and [Azure SQL Database 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 1433.	○	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 Azure SQL database directly. [Checked]: Enter the URL directly. [Not checked]: (default) Generate URL based on the settings of [Host name], [Port number], and [Database name].		In case of [Not Checked], the parameters will be provided automatically.
URL	Enter the URL. Standard URL format of Azure SQL Database is jdbc:sqlserver://<Host name>:<Port number>;DatabaseName=<Database name>. The connector supports URL which is supported by the JDBC driver.		Enabled when [Enter URL directly] is checked.
User name	Enter a user name.	○	For more details on client information property, inquire the database vendor.
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. [Checked]:(default) limit the number of procedures listed. [Not Checked]: Procedure names listed are not limited. Fetches all of the procedure names.
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 Azure SQL Database connection resource.

Setting up the connector

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

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

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