Filter:
Submit Search

Release notes

2024.2 (2024/10/6)

New features

HULFT Square Link application

Installing the HULFT Square Link application makes it easier to see which services are using AWS PrivateLink. In addition, a more secure connection is achieved through inclusion of a step where connection requests must be accepted on the side to which the connection is made.

Installing the HULFT Square Link application requires HULFT Square Link Ver.2, which is a paid add-on.

  • When the HULFT Square Link application is installed from App Square, the PrivateLink-related permissions are added to HULFT Square. Configure the settings as needed before use.

  • Specify Inbound or Outbound in > NETWORK > PrivateLink.

Improved features

SFTP

A secure connection from SFTP services is now available. To use a secure connection, the HULFT Square Link application is required.

Installing the SFTP application requires FTP Service, which is a paid add-on.

  • When you set PrivateLink for Secure connection type, you can select a PrivateLink service that you have created.

App Square

App Square has been improved to facilitate smoother updates for applications in the future.

In accordance with this improvement, the App Square URL has been changed.

Previous: "app.square.hulft.com/portal/applications"

New: "store.square.hulft.com/portal/applications"

If an allowlist is set in the firewall access restrictions, setting the following URL is recommended.

square.hulft.com

Improvements to the handling of the REST connector certificate

For a REST connector created from Connections under HULFT INTEGRATE, the Disable server certificate verification option was added so that no errors occur if a self-signed certificate is used on the server side.

Update of the Amazon RDS for SQL Server driver

The driver used for Amazon RDS for SQL Server 2017 has been updated.

Fixed issues

The following issues were fixed.

 

Category

Fixed issues

1

> HULFT INTEGRATE > Connections > FTP connector

In Secure FTP connection settings, if you select FTP over SSL/TLS for Security type and run Verify Connection, the error "Operation not supported" occurs, regardless of whether the settings are configured correctly.

2

> SERVICE EVENTS > FTP

The Out of Memory error may occur when you refer to FTP logs.

3

> SERVICES > VPN

If no services are created immediately after the VPN application is installed, an error may be displayed.

4

> SERVICES > SFTP

When you specify a workspace or a directory that contains multi-byte characters for Root Directory, a problem such as being unable to connect to the SFTP service might occur.

5

> USER MANAGEMENT > Groups

After you add a native application policy to a group, the added policy might not be displayed.

6

> HULFT INTEGRATE > Calendars

If you have Language set to English (US), even if you configure the setting as "Every 2 month(s)," the interval may be displayed as Every month(s) on the summary page.

7

> SERVICES > HULFT Integrate

If you use a lot of Call Script operations, the CPU usage rate may increase significantly.

8

> SERVICES > FTP

With the FTP application, handling of file names that include multi-byte characters may fail.

Release note history

Closed2024.1.1 hotfix (2024/9/8–)

Fixed issues

The following issues were fixed.

 

Category

Fixed issues

1

> JOBS > REST API Jobs

If you change the settings for API clients specified in REST API Jobs, the error "Api Clients not found" may occur.

(2024/9/8)
Closed2024.1.1 (2024/7/28–)

New features

VPN Service

VPN Service, which is a native application, is now available. (2024/7/28)

  • When it's installed from App Square, the VPN-related permissions are added to HULFT Square. Configure the settings as needed before use.

  • Use the IKEv2 protocol for connections.

  • Use the IP allowlist to permit connections with specific IPs.

  • Manage the connection users in VPN services.

  • Password authentication ensures connections can be established only with the specified users.

FTP Service

FTP Service, which is a native application, is now available. (2024/7/28)

  • When it's installed from App Square, the FTP-related permissions are added to HULFT Square. Configure the settings as needed before use.

  • This FTP Service supports only passive mode.

  • Establish an FTP connection via a VPN created in VPN services.

  • Manage the connection users in FTP services.

  • Password authentication ensures connections can be established only with the specified users.

  • The storage of the FTP service is synchronized with HULFT Square storage.

Additional connectors

The following connector was added: (2024/7/28)

  • Amazon Athena connector

Improved features

Improvements to applications

  • For native applications that include contained scripts, you can now view the contained scripts.

    (2024/7/28)

  • Clone & Edit can now be used for native applications that can be redistributed.

    (2024/7/28)

  • Test, which is used when you create an application, now supports asynchronous execution. Now you can create an application even if the test fails due to a timeout.

    (2024/7/28)

Improvements to connectors

Supported versions for the following connectors were added: (2024/7/28)

  • Amazon Aurora for MySQL 8.0

  • Amazon RDS for PostgreSQL 15

  • SQL Server 2022

The JDBC driver of the Snowflake connector was updated to 3.13.30. (2024/7/28)

Improvements to notifications

Notifications to be sent when an application is installed or uninstalled or when an application test is completed were added. For more details on what you can send notifications about, refer to General.

(2024/7/28)

Improvements to logs

Logs for HULFT Transfer jobs have been improved.

Profiles are now also displayed in logs for HULFT Transfer jobs.

“Profile” was added to filters in Add filter on the same page.

(2024/7/28)

Improvements to native application logs

  • The settings of Workspace to save and Author were added to the native application settings. Now you can save the logs for native applications to storage.

    (2024/7/28)

  • If you already installed SFTP Service, update it to the latest version (must be 1.0.2 or later) from App Square. When you set Workspace to save and Author as described above, the service is automatically restarted.

    (2024/7/28)

Fixed issues

The following issues were fixed.

 

Category

Fixed issues

1

Common

As a guideline, if you have 5,000 or more files and directories placed directly under a single directory, a timeout error may occur. Use a hierarchical directory or other such means to avoid increasing the number of files and directories in a single directory by too much. The following connector has been fixed:

  • Designer > SharePoint > Get file path list

(2024/7/28)

2

Common

When a lot of workspaces (including deleted workspaces) exist, the response may slow down if you don't specify workspaces.

The following are affected.

  • > SERVICES > Storage

  • > HULFT INTEGRATE (under this menu)

  • > API MANAGEMENT > API Projects

  • > JOBS (under this menu)

(2024/7/28)

3

> HULFT TRANSFER

When you open a configuration screen, if you have the Transfer[Receive|Send|Host]AdminAccess permission but don't have the Edit[Recv|Send|Host]Config permission, the Edit and Delete menu items aren't displayed.

(2024/7/28)

4

SSO

Even though you logged in with SSO, an error is displayed indicating that your HULFT Square password is expired.

(2024/7/28)

5

> HULFT TRANSFER > Send Config

If you change Compress in Send Config from on to off, the Send processing fails.

(2024/7/28)

6

> HULFT TRANSFER > Host Info

If you change the VPC endpoint (outbound), the Send processing fails.

(2024/7/28)
Closed2024.1 hotfix4 (2024/7/16–)

Fixed issues

The following issues were fixed.

 

Category

Fixed issues

1

> JOBS > REST API Jobs

If you specify JSON format for Request body in Request settings of API Projects and include multi-byte characters in the request body when you issue the REST API, the REST API job may end unsuccessfully.

(2024/7/16)
Closed2024.1 hotfix3 (2024/7/11–)

Fixed issues

The following issues were fixed.

 

Category

Fixed issues

1

HULFT Square

Completed preventive maintenance on the infrastructure in order to ensure stable operation of services.

(2024/7/11)

2

> JOBS > REST API Jobs

If multiple REST API jobs are executed simultaneously, an exception (NullPointerException) may occur.

(2024/7/11)
Closed2024.1 hotfix2 (2024/6/28–)

Fixed issues

The following issues were fixed.

 

Category

Fixed issues

1

> SERVICES > SFTP

When you download a file using the SFTP get command or an SFTP client, the downloaded file has a size of 0 bytes.

(2024/6/28)
Closed2024.1 hotfix (2024/6/18–)

Fixed issues

The following issues were fixed.

 

Category

Fixed issues

1

HULFT Square

Completed preventive maintenance on the infrastructure in order to ensure stable operation of services.

(2024/6/18)
Closed2024.1 (2024/6/2–)

Functions with "Experimental" sign

These are trial functions to test usability. At present, proper verification of quality and usability haven't been performed yet. Therefore, because the UI and UX may change significantly in future releases, compatibility isn't guaranteed. Experimental functions aren't the object of guarantees or support services. We hope you will use them and provide feedback to our support desk.

New features

Native applications

You can now use native applications.

An application that includes a native application module (NAM) is called a native application.

  • To use the module, install it from App Square and configure the settings. In App Square, the Native Application Module tag is added.

  • After a native application is installed, it's placed under the SERVICES menu. For some applications, you can view the dashboard from Monitoring.

SFTP Service

SFTP Service is now available as the first native application.

  • When it's installed from App Square, the SFTP-related permissions are added to HULFT Square. Configure the settings as needed before use.

  • Use the IP allowlist to permit connections with specific IPs.

  • Specify public keys for specific users to allow connections with those users.

  • The storage of the SFTP service is synchronized with HULFT Square storage.

Improved features

Improvements to audit logs

  • In Audit Log, when you set On for Status, the detailed log records of the storage operations performed on HULFT Square GUI are also saved.

    *The storage operations performed by scripts, jobs, or applications aren't included.

  • In Audit Log, when you set On for Status, the detailed logs for applications are now saved as script details.

    (2024/6/3)

Improvements to applications

Applications have been improved.

  • When creating a new application, you can now specify multiple conditions to start up the application.

  • You can create applications with existing File Event Jobs or REST API Jobs.

  • You can now select an environment in which to deploy your created application per profile. You can also stop the deployment.

  • The list of applications that are running or stopped can be viewed from > JOBS > Applications.

Improvements to connectors

A functional improvement has been made to the following connector:

  • Google BigQuery connector

    Query results can be brought to the data flow directly.

Improvements to notifications

Notifications about applications have been improved.

  • You're now notified when an application is added to App Square.

Improvements to profiles

The range of settings that can be configured in profiles has been widened.

  • Profiles now also cover the HULFT Transfer settings.

  • With the above improvement, the menu position of Profiles has been moved from under DATA INTEGRATION to under > SYSTEM.

  • Existing jobs are automatically linked with profiles.

  • You may need to configure profiles to take over permissions that are managed with workspaces. To facilitate this task, Migrate from Workspace has been added to the action menu in Profiles. Members assigned to a workspace can be copied to a profile.

Improvements to storage

Storage has been improved.

  • You can now upload multiple files at a time.

  • You can also upload a file of more than 5 GB in size.

(2024/6/3)

Improvements to log output

When the log records for HULFT Integrate are output, they're now output in the order of sequenceNumber.

This reduces the burden of analysis.

(2024/6/3)

Change to the domain of the sender email

The domain included in the sender email has been changed. The domain name in the email address was changed because the company name was changed in April 2024.

(2024/6/3)

Improvements to GUI

The GUI and some words used in the GUI have been improved.

  • Breadcrumbs were added to screens that had no breadcrumbs.

  • Words and classifications have been improved.

    (Example)
    DATA INTEGRATION -> HULFT INTEGRATE
    DATA ENTRY -> HULFT TRANSFER

Experimental functions included in this release

*Refer to Functions with "Experimental" sign.

When SFTP Service first appeared, the description was "SFTP Service is an experimental function." Now, it's an official release and no longer "Experimental."

(2024/6/11)

Fixed issues

The following issues were fixed.

 

Category

Fixed issues

1

> HULFT INTEGRATE > Projects

After you edit and save a project in Designer, when you check the corresponding project from the project list, it may take some time until the version update is applied.

2

> HULFT INTEGRATE > Connections

Tips about how to use variables may be displayed for fields that aren't variable fields.

3

> APPLICATIONS > All

In the wizard for creating an application, Select… is displayed in the tag input field, but you cannot select. After you enter the characters, press the Enter key to set the tag.

4

> APPLICATIONS > All

When you create an application, if you specify a project where a script calls another script in the same project using Call Script, and select Test on the Test screen, an error occurs. Because the Test doesn't succeed, the application can't be created.

5

> SERVICES > HULFT Integrate

If you restarted by selecting Restart from a HULFT Integrate service screen, you will be notified of the service stopping, but you will not be notified when the service starts again.
Closed2023.4.1 (2024/3/10–)

Fixed issues

The following issues were fixed.

 

Category

Fixed issues

1

> HULFT INTEGRATE > Connections > FTP connector

Even if you create a connection with FTP over SSL/TLS, you may not be able to connect. Connection may not be possible depending on the encryption algorithms that are supported by the FTP server at the connection destination.

(2024/3/10)

2

> JOBS > HULFT Transfer Jobs

When you create, edit, delete, enable, or disable a HULFT Transfer job, the following message might be displayed on the screen:

"Unexpected Error Endpoint request timed out"

(2024/3/10)

3

> Audit logs

When audit logs are automatically stored and output to files, the output data may consist of only the headers.

(2024/3/10)

4

Confirmation email for user invitation

The signature of the email that HULFT Square sends to customers when a user invitation is completed has been changed to "The HULFT Square Team".

(2024/3/10)
Closed2023.4 hotfix (2024/2/21–)

Fixed issues

The following issues were fixed.

 

Category

Fixed issues

1

Designer

BOX connector

If you generated a JWT keypair for Box in October 2023 or thereafter, you can't connect to the corresponding Box.

(2024/2/21)
Closed2023.4 (2024/1/28–)

New features

Notification function

You can now send notifications to a specified email or service screen in cases like the below.

  • When a job fails (email notification)

  • When a job succeeds (browser notification on service screen)

  • When HULFT Integrate or a HULFT Transfer service shuts down or becomes available for use

  • When you have set a threshold per month for each type of value that can be checked on the dashboard, and usage exceeds one of the set values

For more details on what you can send notifications about, refer to Types of notifications and notification destinations.

Script dependency

If you use a lot of Call Script operations, the dependency of the scripts may become difficult to determine, and the version management may become a hassle.

By using this function, you can make the structure of Call Script operations visual.

The following settings can be configured for each script:

  • Always call latest version

  • Call specified version

You can also configure the above settings all at once for all scripts.

If you purchase paid options, you can display the structure graphically.

This allows you to instinctively grasp which scripts will be affected when you change the version of a script.

Additionally, if the script has multiple hierarchies, you can configure the setting to call the latest version so that the setting is inherited from the specified script to all scripts below it.

Improved features

Display of the REST API job execution count

The execution count for REST API jobs has been added to the dashboard. The total count by day and by month are now displayed.

Improvements to audit logs

In Audit Log, when you set "On" for Status, the detailed logs for the script are also saved. This is available in both HULFT Integrate and HULFT Transfer.

Improvements to applications

Applications have been officially released.

You can now specify a script or scheduled job to create an application. You can also clone an application and edit it.

Connectors

The following connector was added:

  • PostgreSQL connector

    • Supports PostgreSQL 15

Additional OS support

Windows 11 is now supported.

Fixed issues

The following issues were fixed.

 

Category

Fixed issues

1

> JOBS > File Event Jobs

Multiple file event jobs might run if all of the following conditions are met:

  • A parent directory that includes 100 or more subdirectories or files is created

  • A file event job that runs when the parent directory is deleted is created

  • The parent directory is deleted

2

Designer

In the Mapper editor of Designer, when you edit a schema and change the order of schemas, the schema structure displayed in the right pane may not be sorted, and cease to match.

3

> SERVICES

When there are 200 or more workspaces, the Integrate service may be forcibly restarted.

4

> LOGS >

If you open HULFT Square on multiple tabs of a tabbed browser and then log out on one of them, multiple logout messages may be recorded in the log.

5

> API MANAGEMENT > API Projects

If an extremely large number of versions of an API project exist, you might not be able to open the project from the resource editing screen.
Closed2023.3 hotfix3 (2023/12/3–)

Fixed issues

The following issues were fixed.

 

Category

Fixed issues

1

> HULFT INTEGRATE > Projects

If an extremely large number of versions of a project exist, you might not be able to open the project from the project screen.

(2023/12/3)
Closed2023.3 hotfix2 (2023/11/21–)

Fixed issues

The following issues were fixed.

 

Category

Fixed issues

1

> JOBS > HULFT Transfer Jobs

HULFT Transfer jobs might not start if either of the following conditions is met:

  • HULFT on the sending-side client is Ver.8 or later, and V7 compatible is selected in HULFT Transfer Hosts

  • HULFT on the sending-side client is earlier than Ver.8

(2023/11/21)

2

> SERVICES > Storage

If you delete a workspace and then create a workspace of the same name, when you attempt to display the workspace, the storage for the deleted workspace may be displayed.

(2023/11/21)
Closed2023.3 hotfix (2023/10/15–)

Fixed issues

The following issues were fixed.

 

Category

Fixed issues

1

> LOGS >

If you enable audit logs and retrieve the user login history as "audit-user-login-history-yyyymmdd.log.gz" from the storage, the order of item names in the title row and the order of item names in the output log don't match.

Title row: Date,Event Type,Email,Name,....

Output log: Date,Email,Name,Event Type,....

(2023/10/15)

2

Monitoring

When you change a username, the change might not be reflected in logs.

(2023/10/15)

3

Monitoring

If commas are included in the log data, when you output the data to a file, it might not be processed correctly as CSV.

(2023/10/15)
Closed2023.3 (2023/9/24–)

Functions with "Experimental" sign

These are trial functions to test usability. At present, proper verification of quality and usability haven't been performed yet. Therefore, because the UI and UX may change significantly in future releases, compatibility isn't guaranteed. Experimental functions aren't the object of guarantees or support services. We hope you will use them and provide feedback to our support desk.

New features

Single sign-on

Single sign-on that uses Microsoft Entra ID (formerly Azure AD) is now supported.

You can simply log in to HULFT Square with the domain credentials you currently use.

To use this function, you need to set the permissions from the policy.

For details about usage, refer to Single Sign-on and the tutorials described there.

Status of HULFT Integrate services

You can now see the usage status of the JVM Non-Heap Memory, CPU, and JVM Heap Memory in HULFT Integrate services. Based on the usage, you can choose to restart the service, or determine whether to scale up or scale out.

For details on how to make these determinations, refer to When the status of a HULFT Integrate service is yellow or red.

Applications (Experimental)

You can now install and use safe, reliable, thoroughly-reviewed applications from App Square.

You can now carry out a specific Data Integration task by simply executing an application, without the need to create a script from scratch. To use this function, you must configure a profile, HULFT Integrate service, connections, and other settings according to HULFT Square specifications.

You can use the provided applications as a base for customizations, or use them as parts for your own script.

As of this release, application events are now referred to as "service events."

Improved features

Improvements to organization information

Your AWS account ID and the global IP address of your environment that is used for HULFT Square are now displayed in your organization information. You can now quickly and easily refer to your HULFT Square IP address during tasks such as adding it to your allowlist or connecting with PrivateLink.

Additional time zone support

The number of time zones you can specify when you complete your contract has increased. Accordingly, additional considerations have been made for time zones in processing such as Date/Time Constant.

Improvements to script properties

The version and the last updated date and time are now displayed on the Basic information tab of the script properties.

Improvements to audit logs

System Events and User Login History have been added to the audit logs. You can now refer to information on changes made by users and on when users logged in or out. You can also save logs in the storage of the specified workspace and download the logs.

This doesn't include features that already supported download and export. Also, it doesn't include logs for experimental applications.

Improvements to log functions

The log functions have been improved. When the number of log records in the execution log reaches the display limit, only errors and completion messages are displayed. You can view all the log records in the event log of HULFT Integrate.

This improvement reduces unnecessary memory usage and eliminates a source of instability.

Improvements to the service event log filter

On the screen to view details of the service log or the execution log for a script, specification of hours/minutes/seconds has been added to the filter function. Also, Error has been added as a log level.

This allows you to narrow down your search to the problem area and select log records to view.

Improvements to connectors for OAuth

The OAuth 2.0 redirect URI has been changed.

Although the previous URI will be available for use until March 31, 2024, we recommend that you use the new URI from now on. For details, refer to Announcement regarding authentication incompatibility for HULFT Square Auth (OAuth 2.0) (Japanese language only).

Improvements to File connector timeout

There was a limit on File connectors of a maximum timeout of 350 seconds. This has been improved. As a result, timeouts no longer occur when copying large files.

Connectors

The following connector was updated:

  • File Operation connector

    • Compress GZIP

    • Extract GZIP

Experimental functions included in this release

*Refer to Functions with "Experimental" sign.

APPLICATIONS

Applications are experimental functions. Logs can be viewed from > Application > All, but download isn't available.

When an application that supports schedule execution is released, you will be able to execute according to a schedule. In the current version, the longest interval for execution is every day, and setting execution for every week or every month isn't available.

Fixed issues

The following issues were fixed.

 

Category

Fixed issues

1

> HULFT INTEGRATE > Connections

  • The dropdown list on the edit screen for a connection resource may be blank.

  • For the field for the settings file of the Box connector, although "Select a private key file" is displayed on the screen when you click Browse, it should actually be "Select a file".

2

> HULFT TRANSFER > Receive Config

> HULFT TRANSFER > Send Config

In File to receive of the HULFT Transfer Receive configuration and File to send of the HULFT Transfer Send configuration, on the screen that is displayed when you click Browse, "Select a directory" is displayed but it should actually be "Select a file".

3

> API MANAGEMENT > API Projects

  • Selecting for the HTTP methods for an API project may display the wrong message.

  • If the version number is a value that exceeds 400, the latest version is displayed, but there may be items that aren't displayed.

4

> JOBS > REST API Jobs

When you select Turn off job from the action menu, the message "Are you sure you want to turn on the REST API job?" is displayed. Although the opposite message is displayed, the job is disabled correctly.

In the same way, when you select Turn on job, the opposite message is displayed. The job is enabled correctly.

5

Monitoring

The Japanese word breaker of the filter may not work properly.

For example, in the filter for project name, nothing is displayed when you search for "新しい", but "新しいプロジェクト" is displayed when you search for "新".

6

> SERVICE EVENTS > HULFT Integrate

  • If an unexpected error occurs while you are running a script, it may appear in the log that the script continued running. If that occurs, the Project name and Script name will be blank.

  • If you execute multiple Script Calls using thread processing, the logged script names may differ from the actual names.

7

> USER MANAGEMENT > Users

  • Although you specify a group when you invite a user, permissions for that group may not be granted properly.

    For example, when you specify the Developer group during an invitation, if that user tries to see the accessible workspace, messages such as "Require workspace permission: READ" may be displayed.

8

Designer

  • When you create a script, if you close Designer without running the script at least once, a "Failed to load script" error occurs when you reopen the script and try to run it.

  • Although the lock information is listed in the script properties, there's no lock function in HULFT Square.

  • On the settings screen for the script variables, if you select the Required checkbox for Use as script input variable and execute a script, an error may not occur even if you don't set a value.

9

> SERVICE EVENTS > HULFT Transfer

The maximum number of displayed logs is 500. The page transition doesn't work, and 500 logs are displayed in one page.

(2023/9/27)
Closed2023.2.1 (2023/6/18–)

Fixed issues

The following issues were fixed.

 

Category

Fixed issues

1

> HULFT INTEGRATE > Projects

When you create a new project, the Edit project name dialog isn't displayed even if you click Finish.

(2023/6/18)

2

> HULFT INTEGRATE > Connections

> HULFT INTEGRATE > Variables

> HULFT INTEGRATE > Calendars

For connection resources, variables, or calendars, when you open pages from Information in the action menu, the Information menu item in the action menus for the profile list may not be displayed, regardless of whether you have the view permission.

(2023/6/18)

3

Workspaces

The color scheme of the workspace may have changed.

(2023/6/18)
Closed2023.2 hotfix (2023/6/8–)

Fixed issues

The following issues were fixed.

 

Category

Fixed issues

1

Storage access (general)

Depending on the state of the network, an exception (io.vertx.core.http.HttpClosedException) may occur when performing general storage access and script execution tasks such as those below.

  • Operating the storage service screen

  • Referring to project information while operating the screen

  • Acquiring project information at the beginning of script execution

  • Acquiring project information during script execution

  • Executing a script that contains a connector that accesses storage (*1)

    *1

    :

    Applicable connectors

    • Basic

      Assertion - Compare File

    • File

      CSV, Excel, Excel(POI), XML, Fixed-Length, Variable-Length

    • File Operation

      Filesystem

    • Network

      FTP

    • Cloud

      Amazon S3, Azure BLOB Storage, Google BigQuery, Google Cloud Storage, Google Drive, Google Sheets, BOX, SharePoint

    • Cryptography

      PGP

(2023/6/8)
Closed2023.2 (2023/5/28–)

Functions with "Experimental" sign

These are trial functions to test usability. At present, proper verification of quality and usability haven't been performed yet. Therefore, the UI and UX may change significantly in future releases. We hope you will use them and provide feedback to our support desk.

New features

Single sign-on

Single sign-on of Microsoft Active Directory is supported.

You can simply log in to HULFT Square with the domain credentials you currently use.

To use this function, you need to set the permissions from the policy.

For details about usage, refer to Single Sign-on and the tutorials described there.

Dashboard

The widget for total amount of transferred data was officially released.

The contents of your contract are now displayed.

In addition, the following widgets were added:

  • Daily quantity of allocated memory (Integrate services)

  • Daily number of vCPU (Integrate services)

  • Daily number of created VPC endpoints (Experimental)

Audit logs

The records of accessing REST API jobs can now be displayed as logs.

You can download the logs of the past 30 days all at once.

To use this function, you need to set the permissions from the policy.

Asynchronous execution of REST API jobs

REST API jobs now support asynchronous execution.

With this, you can avoid the timeout problem that jobs with long execution times have.

For details about usage, refer to When you want to execute REST API jobs asynchronously in the tutorial Execute a script using an HTTP REST request.

GDPR/CPRA support

You will now be explicitly asked to agree to the privacy policy when you begin using HULFT Square.

In addition, the date of agreement is recorded and you can check it from My Profile.

Improved the handling of the deleted workspaces

Users who have the WorkspaceAdminAccess permission can now display deleted workspaces.

Memory management

Memory management has been improved when newly creating HULFT Integrate services.

Existing HULFT Integrate services aren't affected. To apply this memory management improvement, you need to recreate the HULFT Integrate service.

Additionally, a menu item to restart HULFT Integrate services was added.

Connectors

The following connectors were updated:

  • Sharepoint connector

  • Box connector

  • REST connector

  • Excel connector

  • Excel POI connector

  • FTP connector

Experimental functions included in this release

*Refer to Functions with "Experimental" sign.

Dashboard

The information on the dashboard about VPC endpoints is displayed for reference only.

Fixed issues

The following issues were fixed.

 

Category

Fixed issues

1

Login screen

When your password expires, even if you reset your password from "Forgot your password?" on the login screen, it stays expired, and you can't log in.

2

> SERVICES > HULFT Transfer

On the registration screen for the HULFT Transfer service, you can't change or update the description.

3

> HULFT INTEGRATE > Data Formats

After you create and add a data format resource in Designer, if you edit a Variable-length connector or a Fixed-length connector in Data Formats, the format may be deleted.

4

> HULFT INTEGRATE > Calendars

You can't change a date you set as a non-business day back to a business day.

5

> API MANAGEMENT > API Projects

  • Sorting by owner may not work as expected.

  • You may not be able to delete the resources for an API project.

6

> JOBS > REST API Jobs

When multi-byte characters are included in the request body sent to a REST API endpoint, the response may be garbled or fail.

7

> JOBS > Schedule Jobs

A scheduled job set for 0:00 may be executed one more time at 0:00 on the day after the end date.

This occurs when all of the following conditions are satisfied:

  • "Time" is set as "0:00".

  • "Recurrence" is set as either "Day", "Week", "Month", or "Year".

  • The day after the "End date" satisfies the execution conditions other than "End date" (example: the job is set to execute every Saturday, and the day after the end date is a Saturday).

8

> SERVICE EVENTS > HULFT Transfer

The sorting function doesn't work.

9

> JOB EVENTS

When you open the details of a log for an error that occurred in a job event, it may transition to the top page.

10

> JOB EVENTS > HULFT Transfer Jobs

When you update a job, an error may occur.

Even if an error occurs, an update may be successful.

11

Support > Support Center

When you open Support Center, the error "Authentication header must be set" may occur.

12

> USER MANAGEMENT > Users

When you invite a user, if no operations are performed for three minutes, an error may occur.

13

> NETWORK > VPC Endpoint

When you open VPC Endpoint in the navigation menu, "Something went wrong." may be displayed.

14

> SECURITY > API Token Expiration

Even if you set the expiration date of a refresh token to be longer than 30 days, the expiration date of the refresh token may be up to only 30 days. If it expires, the display is the same as if the access token isn't yet generated.

15

Workspaces

  • Even if users with only the read permission attempt to use workspaces that they don't have enough permissions for, they may be able to use the workspaces without errors.

  • If you delete a workspace, the resources linked to the corresponding workspace will no longer be displayed on the screen. The resources themselves will remain.

    To delete a workspace, delete related resources first.

16

Designer

  • If you create multiple folders in a project and put scripts with the same name in them, they can't be differentiated when you execute jobs or scripts. Don't use the same script name multiple times in a project.

  • After you create a script that uses a connection resource, if you delete that connection resource and open the script again, the connection resource that was supposed to be deleted may be displayed as GUID instead of its specified name.

  • If you change the project name, scripts may not be able to be executed.

  • Even if you set argument values for test execution from the script properties, they may not be reflected during test execution.

  • When you run debugging, the results shown in the log may differ from the actual processing time.

  • If you use the history to edit and save a script that was previously deleted, an error may occur.

  • If changes to a script in Designer are saved locally, if you reopen the local save data, an error may occur.

  • For Google BigQuery connection, if you set an invalid value for Service account authentication key, you may not be able to set Google BigQuery operations on Designer.
Closed2023.1.1 (2023/2/26–)

New features

Connectors

The following connector was updated:

  • Salesforce connector (*1)

*1

:

Batch operations were officially released in the 2023.1.1 release. (2023/2/26)

Fixed issues

The following issues were fixed.

 

Category

Fixed issues

1

Login screen

When you reset your password from "Forgot your password?", the password policy may not be applied.

(2023/2/26)

2

> SYSTEM > Workspaces

For workspace creation, if you create a workspace with an administrator (admin) in the group, an error may occur.

(2023/2/26)

3

> SECURITY > Password Policy

Even if you change the password policy, you may not be able to apply it.

(2023/2/26)

4

Designer

  • When you debug a script, the message that should be output to the execution log may not be output.

  • You can't rearrange script names in the project explorer.

(2023/2/26)

5

File Operation connector

For the File Operation connector, a timeout of 350 seconds is set according to specifications. For operations where the processing takes a long time such as copying of large files, a timeout may occur, and the script may fail.

(2023/2/26)

6

Call Script

If you run Call Script recursively, ScriptNotFoundException may occur.

(2023/2/26)
Closed2023.1 hotfix2 (2023/1/29–)

Fixed issues

The following issues were fixed.

 

Category

Fixed issues

1

> SERVICE EVENTS > HULFT Transfer Service

The HULFT Transfer service for monitoring is hidden.

You can check the results of transfer processing for HULFT Transfer in the APP EVENTS menu.

(2023/1/29)

2

Designer

For operations for Google Sheets and Google Drive, the list of connection settings may not be displayed at the destination.

(2023/1/29)
Closed2023.1 hotfix (2023/1/18–)

Fixed issues

The following issues were fixed.

 

Category

Fixed issues

1

> SERVICES > HULFT Integrate

When you delete a file in storage from a job or script, an error may occur. Even if an error occurs, deletion of the file is performed correctly.

After the fixes are applied, the error no longer occurs. If a job or script is still running from before the fixes were released, the fixes are automatically applied after it finishes.

(2023/1/18)
Closed2023.1 (2023/1/15–)

Functions with "Experimental" sign

These are trial functions to test usability. At present, proper verification of quality and usability haven't been performed yet. Therefore, the UI and UX may change significantly in future releases. We hope you will use them and provide feedback to our support desk.

New features

Overall Summary

In HULFT Square, you can connect to various data sources such as databases and cloud services and to the HULFT system, and you can handle the relevant data and files.

When data processing is required, you can create a script by arranging and linking process icons without writing program code.

Register the completed script as a job. Various triggers are available, such as executing it repeatedly at planned dates and times, executing it when specific files are updated, or calling with HTTP REST.

Welcome to the world of data integration services.

Workspaces

By using workspaces, you can share settings such as for projects, storage, and resources with members in an organization to work together more efficiently.

The administrator can set members for workspaces and access permissions to separate each workspace safely and logically. Additionally, users can filter workspaces to display only the workspaces that they themselves have access rights to, in order to focus on their own work.

Projects

The scripts you create are managed in units known as projects.

To create a script, first create a project.

Profile

By preparing profiles such as for the production environment and for development, you can switch connection resources without changing the created script.

Calendars

If you set company holidays, you can configure settings such as to not execute jobs on those days.

API Management

Link scripts created in API projects and HTTP methods.

On the API client, set the users and IP addresses that can access the API.

Jobs

Set the triggers to run a script you created in Designer.

You can run scripts based on the triggers of file events such as file creation, setting of a schedule, and receipt of a file from the HULFT system.

Additionally, you can configure the responses for HTTP REST requests and other such settings from here.

Monitoring

You can check the amount of data and amount of communication used by the service, the records of running of jobs, and so on.

  • Dashboard

    • Daily maximum Storage usage

    • Total amount of transferred data (Experimental)

  • Application (What project/script was run or sent/received, when, and by whom are displayed. You can check the execution results for REST API jobs from here)

    • HULFT Integrate

    • HULFT Transfer

  • Job (What job was executed, when, and by whom are displayed)

    • File event job

    • Scheduled job

    • HULFT Transfer job

User management

In HULFT Square, an administrator manages users in groups and manages the permissions of the users by applying policies to the groups they belong to.

VPC endpoint

Create and manage VPC endpoints for HULFT Square.

MFA

Multifactor authentication settings are available.

MFA increases the security level to help prevent unauthorised access by third parties.

Subscription Info

You can check the service plan that you have a contract for.

You can check the contract number, contract start date, contract end date, domain name, resources, add-on services, connectors, and so on.

Connectors

The following connectors are available:

  • Amazon Aurora for MySQL connector

  • Amazon DynamoDB connector

  • Amazon EC2 connector

  • Amazon RDS connector

    • Amazon RDS for MySQL connector

    • Amazon RDS for Oracle connector

    • Amazon RDS for PostgreSQL connector

    • Amazon RDS for SQL Server connector

  • Amazon RedShift connector

  • Amazon S3 connector

  • Amazon SQS connector

  • AWS Lambda connector

  • Azure BLOB Storage connector

  • Azure CosmosDB connector

  • Azure HDInsight connector

  • Azure Queue Storage connector

  • Azure SQL Database connector

  • BOX connector

  • CSV connector

  • DB2 connector

  • Dynamics 365 for Customer Engagement connector

  • Excel connector

  • Excel POI connector

  • FTP connector

  • Gmail connector

  • Google BigQuery connector

  • Google Cloud Storage connector

  • Google Drive connector

  • Google Sheets connector

  • Google Workspace connector

  • HULFT connector

  • JDBC connector

  • kintone connector

  • Mail connector

  • MySQL connector

  • Oracle connector

  • PGP connector

  • PostgreSQL connector

  • REST connector

  • Salesforce connector

  • ServiceNow connector

  • Slack connector

  • SnowFlake connector

  • SQL Server connector

  • XML connector

  • Event notification connector

  • Fixed-length connector

  • Variable-length connector

Related Services

Status Site

We have posted a status site (https://status.square.hulft.com/).

View this site to check at a glance the operational status of core services for HULFT Square that would have an impact on work.

You can also view the history of incidents that occurred.

Technical Documents

We have posted technical documents (https://www.hulft.com/help/en-us/HULFTSquare/).

Check these for descriptions of functions and descriptions of procedures.

Experimental functions included in this release

*Refer to Functions with "Experimental" sign.

Bulk operation of the new Salesforce connector (Experimental)

Among the operations of the Salesforce connector, the following operations are experimental:

  • Bulk Read Records

  • Bulk Read Records (Child-to-parent relationship)

  • Bulk Insert Records

  • Bulk Update Records

  • Bulk Upsert Records

  • Bulk Delete Records

Metering Service (Experimental)

The amount of network use on the dashboard is a rough estimate.

Policies     (c) Saison Technology Co.,Ltd. 2021

TOP