Administrator
- Administrator
- All Products
ASK INFAPreview
Please log in to access Bolo.
ASK INFAPreview
Connection property
| Description
|
|---|---|
Connection Name
| The name of the connection.
|
Description
| Optional. Description of the SAP IQ connection that you use to identity the connection.
|
Type
| Type of connection.
Select SAP IQ as the connection type.
|
Runtime Environment
| The name of the runtime environment where you want to run the tasks.
Select the Secure Agent from the list as the runtime environment.
|
Host Name
| Name of the machine that hosts the SAP IQ database server.
|
Port
| Network port number used to connect to the SAP IQ database server.
Default is 2638.
|
Database
| The SAP IQ database that you want to connect to.
|
Schema
| Schema name in the SAP IQ server to fetch the metadata.
|
User Name
| User name for the SAP IQ database login.
|
Password
| Password for the SAP IQ database login.
|
Checkpoint
| If enabled, the SAP IQ database issues a checkpoint after successfully loading the table. If disabled, the database does not issue a checkpoint.
Default is enabled.
|
Notify Interval
| Number of rows the SAP IQ external loader loads before it writes a status message to the external loader log.
Default is 1000.
|
Datafile Directory
| The SAP IQ directory that stores the data files at runtime.
The directory must be accessible from the Secure Agent machine.
If the directory is on the Windows system, use a backslash (\) in the path:
For example,
D:\mydirectory\inputfile.out
If the directory is on the UNIX system, use a forward slash (/) in the path:
For example,
/mydirectory/inputfile.out
|
External Loader Executable
| File name and file path for the external loader executable.
When you create an SAP IQ external loader connection, the name of the external loader executable file is set to
dbisql by default.
If you use an executable file with a different name, you must update the
External Loader Executable field. If the external loader executable file directory is not in the system path, you must enter the file path and file name in this field.
If you configure the connection on Windows, you must enter
dbisql -nogui .
|
Is Staged
| Method of loading data.
Select
Is Staged to load data to a flat file staging area before loading to the database.
Default is enabled.
|
