Infobright Loader

Description

This step allows you to load data into an Infobright database table.

Important Note for Windows users:
If you want to use the InfoBright bulk loader step under Windows, make sure to copy one of either file to your Windows system path (for example %WINDIR%/System32/):

  • libswt/win64/infobright_jni.dll (Windows 64-bit)
  • libswt/win32/infobright_jni.dll (Windows 32-bit)

Options

Option

Description

Step name

The name of this step as it appears in the transformation workspace.

Database

Drop-down menu which allows you to select the appropriate Infobright database connection. Note: List is populated only once a database connection has already been established; if no database connection has been established, this list will be blank.

Infobright product

Select which version of the Infobright product you are using; Enterprise (EE) or Community (CE) edition.

Target schema

The name of the schema for the table to write data to. This is vital for data sources which allow for table names with dots (".").

Target table

Name of the target table.

Character set

The used character set.

Agent port

Specify the port of the database.

Debug file

This step generates a debug file, this option allows you to specify the name of the debug file.