Bulk Insert Run

The Bulk Insert Run task imports data into Infor Public Sector.

This task imports data from Amazon S3 or SFTP in the form of a delimited file, and inserts it into a specified table in the database. The main purpose of the task is to import large amounts of data quickly in a multi-tenant environment, without any downtime.

Note: The Bulk Insert Run task is also supported in on-premises environments, but with SQL Server databases only.

For example, this task might be used to import contact records from a legacy system. You must first export the records from the legacy system to a delimited file that matches the structure of the target table in the Infor Public Sector database. Then upload the delimited file to S3 or SFTP and run the task to import the data.

The Bulk Insert Run task includes two processes that can be run separately or together: validation and import.

In either case, the data from the import file is first added to a staging table in the Infor Public Sector database, which has the same structure as the target table.

If this is a validation-only run, the task then rolls back the data from the staging table.

For an import run, a stored procedure is used to transfer the data from the staging table to the target table.

Staging tables are deleted after 14 days by the Purge System Logs task.

Setup

This table describes the Configuration Editor settings that affect this task:

Configuration Comments
FileManagement configuration Stores authentication profiles for Amazon S3 and SFTP.

Invocation

When you set the conditions for the Bulk Insert Run task in the Batch Manager, you can click the Preview Data button to show the data to be imported in the Preview Data grid.

This table describes each parameter for this task:

Form Console Description
Import Mode Select the process that you want to run. You can select one of these options:
  • Validate and Import
  • Import
  • Validate
File Transfer Type Specify the source of the transfer. You can select one of these options:
  • Amazon S3
  • SFTP
Authentication Profile FileTransferAuthenticationProfile (string) Specify the authentication profile to use for Amazon S3 or SFTP. The available authentication profiles are defined in the FileManagement configuration.
File Name FileName (string) Specify the name of the delimited file from which the data will be imported.
Table Name TableName (string) Specify the name of the target table in the Infor Public Sector database.
Delimiter Delimeter (string) Select the character that is used as the delimiter in the import file.
Allow Identity Inserts IdentityInsert (bool) Indicates whether you want to keep the primary keys from the import file. If you do not select this check box, new keys will be assigned to the imported records.

Data output

This table lists the database tables in which this task adds or updates records:

Table Comments
CORE.DATA.BULKINSERTRUN Stores information about each bulk insert run.