Table of Contents

Search

  1. Preface
  2. Connectors and connections
  3. Connection configuration
  4. Connection properties
  5. Swagger file generation for REST V2 connections

Connections

Connections

SAP IQ connection properties

SAP IQ connection properties

When you set up an SAP IQ connection, you must configure the connection properties.
The following table describes the SAP IQ properties:
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.

0 COMMENTS

We’d like to hear from you!