Connector top page

This page lists links to information regarding connectors.

Refer to the descriptions on each page from the links below.

Clicking opens the corresponding contents.

None means that there is no corresponding content.

Basic
Conversion
Database
File
Application
Network
Cloud
Cryptography
HULFT

Subcategory		Message code	Exception message	Limitations
Processing	Assign Variables	None	None
	Call Script	None
	Wait	None
	Garbage Collection	None	None	None
	Raise Exception	None
	Data Check	None
	Get Data Check Error Details	None
	Validate with XML Schema	None		None
	Validate with DTD	None		None
	Output Table Model Data Log	None
	Output XML Data Log	None		None
Flow	Loop	None	None
	Conditional Loop	None	None
	Loop by Number of Data	None	None
	Conditional Branch	None	None
	Monitor Exception	None	None
	Thread	None	None
	Transaction	None	None
	end	None	None
	break	None	None	None
	continue	None	None	None
Event Notification	Notify Event(Amazon EventBridge)		None	None
Assertion	Compare Table Model	None
	Compare XML File	None		None
	Compare XML Data	None		None
	Compare File	None		None
	Compare Variable	None		None
	Assertion Exception	None		None
Others	Group	None	None	None
Others	Memo	None	None	None

Conversion

Subcategory		Message code	Exception message
Basic	Mapping	None	None
	Join	None
	Aggregate	None
	Sort	None
	Merge	None	None
Character	Convert CP932 to SJIS	None
	Convert SJIS to CP932	None
	Remove Invalid XML Characters	None
Table	Switch Row/Column	None
XSLT	Convert XSLT Structure	None

Database

Subcategory		Private Link	Others
DB2 (Common)	Read Table	Available	Table Browser
	Execute Select SQL
	Write Table
	Execute Update SQL
MySQL (Common)	Read Table	Available	Table Browser
	Execute Select SQL
	Write Table
	Execute Update SQL
	Execute Stored Procedure
Oracle (Common)	Read Table	Available	Table Browser
	Execute Select SQL
	Write Table
	Execute Update SQL
	Execute Stored Procedure
PostgreSQL (Common)	Read Table	Available	Table Browser
	Execute Select SQL
	Write Table
	Execute Update SQL
SQL Server (Common)	Read Table	Available	Table Browser
	Execute Select SQL
	Write Table
	Execute Update SQL
	Execute Stored Procedure
JDBC (Common)	Read Table	Available	Table Browser
	Execute Select SQL
	Write Table
	Execute Update SQL
	Execute Stored Procedure
Snowflake	Read Table		Table Browser
	Execute Select SQL
	Write Table
	Execute Update SQL

Available

We have verified PrivateLink connection to the AWS environment (VPC) in the Asia Pacific (Tokyo) region and confirmed that the connector works correctly.

File

Subcategory		Limitations	Others
CSV	Read CSV File
CSV	Write CSV File
Excel	Read from Sheet		Excel Read Wizard
	Read from Named Range
	Read Specified Cell
	Get Sheet Names
	Write		Excel Write Wizard
	Write Specified Cell
	Protect Workbook and Sheet
	Show/Hide Sheets/Rows/Columns
	Rename Sheet
	Delete Sheet
	Copy Sheet
Excel(POI)	Write Sheet
Excel(POI)	Write Specified Cell
XML	Read XML File
XML	Write XML File
Fixed-Length	Read Fixed-Length File		Fixed-Length Wizard
Fixed-Length	Write Fixed-Length File		Fixed-Length Write Wizard
Variable-Length	Read Variable-Length File		Variable-Length Wizard
Variable-Length	Write Variable-Length File		Variable-Length Write Wizard
File Operation	Create File
	Create Directory
	Copy
	Delete File/Directory
	Move
	Get List of File Names
	Check File/Directory Exists
	Compress ZIP
	Extract ZIP
	Compress GZIP
	Extract GZIP
Filesystem	Read Filesystem	None
Filesystem	Write Filesystem	None

Application

Subcategory		Others
Dynamics 365 for Customer Engagement	Read Entity
	Write Entity
	Delete Entity
Salesforce(deprecated)	Read Data (execute SOQL) (deprecated)	Error messages of Salesforce(deprecated) category
	Write Data(Insert) (deprecated)
	Write Data(Update) (deprecated)
	Write Data(Delete) (deprecated)
	Write Data(Upsert) (deprecated)
	Read Data(Child-Parent Relation) (deprecated)
	Bulk Write Data(Insert) (deprecated)
	Bulk Write Data(Update) (deprecated)
	Bulk Write Data(Delete) (deprecated)
	Bulk Write Data(Upsert) (deprecated)
	Bulk Get Data(Query) (deprecated)
SAP OData	Execute OData service(GET)
	Execute OData service(POST)
	Execute OData service(PATCH)
	Execute OData service(PUT)
	Execute OData service(DELETE)
	Execute OData action

Network

Subcategory		Private Link
FTP	Get List and Data	Available
	Read List
	Update
	Delete
	Rename
REST	Execute GET	Available
	Execute POST
	Execute PUT
	Execute PATCH
	Execute DELETE
Mail	Receive E-mail (POP3)	Available
	Receive E-mail (IMAP4)
	Send Multiple E-mails
	Send One E-mail

Available

We have verified PrivateLink connection to the AWS environment (VPC) in the Asia Pacific (Tokyo) region and confirmed that the connector works correctly.

Cloud

Subcategory		Limitations	Private Link	Others
Amazon Athena	Read Table		Available
Amazon Athena	Execute Select SQL		Available
Amazon Aurora for MySQL	Read Table		Available	Table Browser
	Execute Select SQL
	Write Table
	Execute Update SQL
	Execute Stored Procedure
Amazon Aurora for PostgreSQL	Read Table		Available	Table Browser
	Execute Select SQL
	Write Table
	Execute Update SQL
Amazon DynamoDB	Get Item (Scan)
	Get Item (Query)
	Add/Replace Item
	Delete Item
Amazon EC2	Start Instances
	Stop Instances
	Describe Instances
Amazon RDS for MySQL	Read Table		Available	Table Browser
	Execute Select SQL
	Write Table
	Execute Update SQL
	Execute Stored Procedure
Amazon RDS for Oracle	Read Table		Available	Table Browser
	Execute Select SQL
	Write Table
	Execute Update SQL
	Execute Stored Procedure
Amazon RDS for PostgreSQL	Read Table		Available	Table Browser
	Execute Select SQL
	Write Table
	Execute Update SQL
Amazon RDS for SQL Server	Read Table		Available	Table Browser
	Execute Select SQL
	Write Table
	Execute Update SQL
	Execute Stored Procedure
Amazon Redshift	Execute COPY Command	None	Available
Amazon S3	Get Bucket List		VPN (*1)
	Get File/Folder List
	Read File/Folder
	Write File/Folder
	Copy File/Folder
	Delete File/Folder
	Read File/Folder (Data)
	Write File/Folder (Data)
Amazon SQS	Receive Message		Available
	Send Message
	Delete Message
AWS Lambda	Invoke Lambda Function	None	Available
Azure SQL Database	Read Table			Table Browser
	Execute Select SQL
	Write Table
	Execute Update SQL
	Execute Stored Procedure
Azure BLOB Storage	Get Container List
	Read File/Directory
	Write File/Directory
	Delete File/Directory/Container
Azure Cosmos DB	Read Document
	Read Document by SQL
	Write Document
	Delete Document
Azure HDInsight	Create Cluster
	Delete Cluster
	Execute Hive Job
Azure Queue Storage	Receive Message
	Send Message
	Delete Message
Gmail	Receive E-mail (POP3)
	Receive E-mail (IMAP4)
	Send Multiple E-mails
	Send One E-mail
Google BigQuery	Load table data
	Extract table data
	Execute Select SQL
Google Cloud Storage	Read File/Folder
	Write File/Folder
	Delete File/Folder
Google Drive	Get File/Folder List
	Read File/Folder
	Write File/Folder
	Delete File/Folder
Google Sheets	Read Sheet
	Retrieve Sheets
	Writing
kintone	Get Record
	Add Record
	Update Record
	Delete Record
	Read Table
	Write Table
	Delete Table Data
	Call API
Box	Create Folder
	Copy File Request
	Move Contents
	Copy Contents
	Delete Contents
	Upload Contents
	Download Contents
	Get Contents List
	Get Content Attributes
	Get Shared Link
	Create Shared Link
	Delete Shared Link
	Create User
	Update User
	Delete User
	Create Group
	Update Group
	Delete Group
	Add Membership
	Delete Membership
	Add Collaboration
	Delete Collaboration
Slack	Post Message	None
SharePoint	Download document
	Get file path list
	Upload document
Salesforce	Read Records
	Read Records (Child-to-parent relationship)
	Read Records (SOQL)
	Insert Records
	Update Records
	Upsert Records
	Delete Records
	Bulk Read Records
	Bulk Read Records (Child-to-parent relationship)
	Bulk Read Records (SOQL)
	Bulk Insert Records
	Bulk Update Records
	Bulk Upsert Records
	Bulk Delete Records

Available	:	We have verified PrivateLink connection to the AWS environment (VPC) in the Asia Pacific (Tokyo) region and confirmed that the connector works correctly.
*1	:	We have verified VPN connection to the AWS environment (VPC) in the Asia Pacific (Tokyo) region and confirmed that the connector works correctly.

Cryptography

Subcategory		Operation name		Message code	Exception message	Limitations	Others
PGP			Encrypt
PGP			Decrypt

HULFT

Subcategory		Private Link
Request Issuance	Send File	Available
HULFT Transfer App	Send File	Available
	Send Files
	Send Files - Dynamic
	Get Send Result

Available

We have verified PrivateLink connection to the AWS environment (VPC) in the Asia Pacific (Tokyo) region and confirmed that the connector works correctly.