Table of Contents

Search

  1. Preface
  2. Understanding Pipeline Partitioning
  3. Partition Points
  4. Partition Types
  5. Pushdown Optimization
  6. Pushdown Optimization and Transformations
  7. Real-time Processing
  8. Commit Points
  9. Row Error Logging
  10. Workflow Recovery
  11. Stopping and Aborting
  12. Concurrent Workflows
  13. Grid Processing
  14. Load Balancer
  15. Workflow Variables
  16. Parameters and Variables in Sessions
  17. Parameter Files
  18. FastExport
  19. External Loading
  20. FTP
  21. Session Caches
  22. Incremental Aggregation
  23. Session Log Interface
  24. Understanding Buffer Memory
  25. High Precision Data
  26. POWERCENTERHELP

Advanced Workflow Guide

Advanced Workflow Guide

Configuring Sybase IQ External Loader Attributes

Configuring Sybase IQ External Loader Attributes

You use an external loader connection type for Sybase IQ in PowerCenter. Provide the Sybase IQ database login credentials with the connect string attributes.
The connect string for Sybase IQ 15.x must contain the following attributes:
uid=user ID; pwd=password; eng=Sybase IQ database server name
For example, you might use the following connect string:
uid=qasrvr65;pwd=qasrvr65;eng=SUNQA2SybaseIQ
The session might fail if you use quotation marks in the connect string.
The following table describes the attributes for Sybase IQ external loader connections:
Attribute
Default Value
Description
Block Factor
10000
Number of records per block in the target Sybase table. The external loader applies the block factor attribute to load operations for fixed-width flat file targets only for Sybase IQ versions up to 15.x.
Block Size
50000
Size of blocks used in Sybase database operations. The external loader applies the block size attribute to load operations for delimited flat file targets only for Sybase IQ versions up to 15.x.
Checkpoint
Enabled
If enabled, the Sybase IQ database issues a checkpoint after successfully loading the table. If disabled, the database issues no checkpoints.
Notify Interval
1000
Number of rows the Sybase IQ external loader loads before it writes a status message to the external loader log.
Server Datafile Directory
n/a
The Sybase IQ server location that is accessible from the machine that hosts the Integration Service. If you specify the target file location, the Sybase IQ server might fail to access the file.
Specify this attribute relative to the database server installation directory.
If the directory is in a Windows system, use a backslash (\) in the directory path:
D:\mydirectory\inputfile.out
If the directory is in a UNIX system, use a forward slash (/) in the directory path:
/mydirectory/inputfile.out
Enter the directory path by using the syntax for the machine hosting the database server installation. For example, if the Integration Service is on a Windows machine and the Sybase IQ server is on a UNIX machine, use UNIX syntax.
External Loader Executable
For Sybase 15.x: dbisql -host<hostname> -port<port number>
Name of the Sybase IQ external loader executable. When you create a Sybase IQ external loader connection, the Workflow Manager sets the name of the external loader executable file 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.
Is Staged
Enabled
Method of loading data. Select Is Staged to load data to a flat file staging area before loading to the database. Clear the attribute to load data from a named pipe. The Integration Service can write to a named pipe if the Integration Service is local to the Sybase IQ database.


Updated July 04, 2018