Property | Description |
|---|---|
Connection Name | Name of the connection. Each connection name must be unique within the organization. Connection names can contain alphanumeric characters, spaces, and the following special characters: _ . + -, Maximum length is 255 characters. |
Description | Description of the connection. Maximum length is 4000 characters. |
Type | SAP IQ |
Use Secret Vault | Stores sensitive credentials for this connection in the secrets manager that is configured for your organization. This property appears only if secrets manager is set up for your organization. This property is not supported by Data Ingestion and Replication. When you enable the secret vault in the connection, you can select which credentials that the Secure Agent retrieves from the secrets manager. If you don't enable this option, the credentials are stored in the repository or on a local Secure Agent, depending on how your organization is configured. For information about how to configure and use a secrets manager, see Secrets manager configuration. |
Runtime Environment | The name of the runtime environment where you want to run tasks. Select a Secure Agent. |
Host Name | The name of the machine that hosts the SAP IQ database server. |
Port | The port number that connects to the SAP IQ database server. Default is 2638. |
Database | The SAP IQ database that you want to connect to. |
Schema | The schema name in the SAP IQ server to fetch the metadata. |
User Name | The user name to connect to the SAP IQ account. |
Password | The password to connect to the SAP IQ account. |
Datafile Directory | The SAP IQ directory that stores data files at run time. The directory needs to be accessible from the Secure Agent machine. If the directory is on a Windows system, use a backslash (\) in the path. For example, \root\mydirectory\inputfile.out If the directory is on a UNIX system, use a slash (/) in the path. For example, /root/mydirectory/inputfile.out |
Property | Description |
|---|---|
Checkpoint | Enable the SAP IQ database to issue a checkpoint after successfully loading data into tables. If disabled, the database does not issue a checkpoint. Default is enabled. |
Notify Interval | Number of rows that the SAP IQ external loader loads before it writes a status message to the external loader log. Default is 1000. |
External Loader Executable | The file name and path of the external loader executable. The name of the external loader executable file is set to dbisql by default. If you configure the connection on Windows, you must enter dbisql -nogui. If the external loader executable file name is abc.exe and the path is /root/<folder name>, enter both the path and file name in the following format: /root/<folder name>/abc.exe |
Is Staged | Method of loading data Enable to write data to a staging location before loading data into an SAP IQ database. Default is enabled. |